16,004,564 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Malikdanish (Top 159 by date)
Malikdanish
7-Jan-20 1:34am
View
here is the result i am getting
https://imgur.com/5O4J7vc
here is the result i want to get I want one teacher's all courses on same row
Malikdanish
7-Jan-20 1:31am
View
Here is my index controller code :
public ActionResult Index(string sortOrder, string currentFilter, string SearchString, int? page)
{
ViewBag.Course_Id = _ITeacherCoruses.PopulateCourses();
ViewBag.Teacher_Id = _ITeacherCoruses.PopulateTeachers();
ViewBag.Semester_Id = _ITeacherCoruses.PopulateSemsters();
// ViewBag.Teacher_Id = new SelectList(db.Registration, "User_Id", "FirstName");
ViewBag.CurrentSort = sortOrder;
ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date";
if (SearchString != null)
{
page = 1;
}
else
{
SearchString = currentFilter;
}
ViewBag.CurrentFilter = SearchString;
var dept = from s in db.Teacher_courses
select s;
dept =dept.Include(t => t.course).Include(t => t.regs).Include(t => t.semesterName).OrderBy(t => t.Teacher_Id);
if (!String.IsNullOrEmpty(SearchString))
{
dept = dept.Where(s => s.course.Course_Name.Contains(SearchString));
// || s.FirstMidName.Contains(searchString));
}
switch (sortOrder)
{
case "name_desc":
dept = dept.OrderByDescending(s => s.course.Course_Name);
break;
case "Date":
dept = dept.OrderBy(s => s.Course_Assignment_date);
break;
case "date_desc":
dept = dept.OrderByDescending(s => s.Course_Assignment_date);
break;
default:
dept = dept.OrderBy(s => s.course.Course_Name);
break;
}
int pageSize = 5;
int pageNumber = (page ?? 1);
// var teacher_courses = db.Teacher_courses.Include(t => t.course).Include(t => t.regs).Include(t => t.semesterName).OrderBy(t=>t.Teacher_Id);
dept = dept.Include(t => t.course).Include(t => t.regs).Include(t => t.semesterName).OrderBy(t => t.Teacher_Id);
//return View(groupedUsers);
return View(productsArray.ToPagedList(pageNumber, pageSize));
// return View(teacher_courses.ToList());
}
----
Here is my index view :
@*@model IEnumerable<cms_monitoring.models.teacher_courses>*@
@using PagedList;
@using PagedList.Mvc;
@using CMS_Monitoring.Helpers;
@model PagedList.IPagedList<cms_monitoring.models.teacher_courses>
@{
ViewBag.Title = "Index";
Layout = "~/Views/Shared/_Layout2.cshtml";
}
Index
setTimeout(function () {
$('#successMessage').fadeOut('slow');
}, 12000); // <-- time i
@Html.ActionLink("Create New", "Create", "Departments", new { @class = "btn btn-info" })
@if (TempData["UpdatedMessage"] != null)
{
@TempData["UpdatedMessage"]
}
@Html.ActionLink("Create New", "Create")
@using (Html.BeginForm())
{
Find by Department name: @Html.TextBox("SearchString")
if (TempData["DeleteDepartment"] != null)
{
@TempData["DeleteDepartment"]
}
@foreach (var item in Model)
{
}
@Html.DisplayNameFor(model => model[0].course.Course_Name)
@Html.DisplayNameFor(model => model[0].regs.FirstName)
@Html.DisplayNameFor(model => model[0].semesterName.Semester_Title)
@Html.D
Malikdanish
7-Jan-20 0:41am
View
By sql i have done it using STuff function I want to do it with entity framework only using Linq , no matter either to make it from controller or from view i do not want to call the stored procedure i am using Entity framework using linq
Malikdanish
7-Jan-20 0:34am
View
Hi i have changed my view code to group the data there
@foreach (var item in Model)
{
@foreach(var group in Model.GroupBy(model=> model.regs.FirstName))
{
@Html.Encode(group.Key)
@foreach(var tm in group)
{
@Html.Encode(tm.course.Course_Name)}
}
@*@Html.DisplayFor(modelItem => item.course.Course_Name)*@
but check it's out put is wrong i am not sure why , it is showing five courses for ALAM but in db there are 4 rows for this user,secondly the grouping is still repeating the number of rows which is wrong
https://imgur.com/33BJUjA
Malikdanish
6-Jan-20 23:41pm
View
I just want to ask how do i send this data to view ?
Malikdanish
6-Jan-20 23:19pm
View
this is the razor view not aspx , I just want to say as i am grouping the records in the loop so it is not in a form which could be passed as data object to the view.
Malikdanish
6-Jan-20 22:23pm
View
below is my view can you update it as per my return data
@*@model IEnumerable<cms_monitoring.models.teacher_courses>*@
@using PagedList;
@using PagedList.Mvc;
@using CMS_Monitoring.Helpers;
@model PagedList.IPagedList<cms_monitoring.models.teacher_courses>
@{
ViewBag.Title = "Index";
Layout = "~/Views/Shared/_Layout2.cshtml";
}
Index
setTimeout(function () {
$('#successMessage').fadeOut('slow');
}, 12000); // <-- time i
@Html.ActionLink("Create New", "Create", "Departments", new { @class = "btn btn-info" })
@if (TempData["UpdatedMessage"] != null)
{
@TempData["UpdatedMessage"]
}
@Html.ActionLink("Create New", "Create")
@using (Html.BeginForm())
{
Find by Department name: @Html.TextBox("SearchString")
if (TempData["DeleteDepartment"] != null)
{
@TempData["DeleteDepartment"]
}
@foreach (var item in Model)
{
}
@Html.DisplayNameFor(model => model[0].course.Course_Name)
@Html.DisplayNameFor(model => model[0].regs.FirstName)
@Html.DisplayNameFor(model => model[0].semesterName.Semester_Title)
@Html.DisplayNameFor(model => model[0].is_on_Substitute)
@Html.DisplayNameFor(model => model[0].Active)
@Html.DisplayNameFor(model => model[0].Course_Assignment_date)
@Html.DisplayNameFor(model => model[0].Date_Modified)
@Html.DisplayNameFor(model => model[0].Added_By)
@Html.DisplayFor(modelItem => item.course.Course_Name)
@Html.DisplayFor(modelItem => item.regs.FirstName)
@Html.DisplayFor(modelItem => item.semesterName.Semester_Title)
@Html.DisplayFor(modelItem => item.is_on_Substitute)
@Html.DisplayFor(modelItem => item.Active)
@Html.DisplayFor(modelItem => item.Course_Assignment_date)
@Html.DisplayFor(modelItem => item.Date_Modified)
@Html.DisplayFor(modelItem => item.Added_By)
@Html.ActionLink("Edit", "Edit", new { id = item.Id }) |
@Html.ActionLink("Details", "Details", new { id = item.Id }) |
@Html.ActionLink("Delete", "Delete", new { id = item.Id })
}
Page @(Model.PageCount < Model.PageNumber ? 0 : Model.PageNumber) of @Model.PageCount
@Html.PagedListPager(Model, page => Url.Action("Index",
new { page, sortOrder = ViewBag.CurrentSort, currentFilter = ViewBag.CurrentFilter }))
Malikdanish
2-Dec-19 13:10pm
View
Hi can you explain it a little bit ?
Malikdanish
19-Nov-19 0:02am
View
@string.Join(", ", item.Roles.Select(ur => ur.Role.Name)) This line says that role does not contain a definition of Select ?
Malikdanish
18-Nov-19 23:19pm
View
My Model is UserRoles not Users Table , and in my User table there is not any relationship with UserRoles Table , but the UserRoles table have the foriegnkey of UserId in it .so which model class i need to use with my view
Malikdanish
13-Nov-19 23:22pm
View
I am using entity framework . private DatabaseContext db = new DatabaseContext();
// GET: UserRoles
public ActionResult Index()
{
return View(db.UserRoles.ToList());
}
Malikdanish
25-Oct-19 6:19am
View
Deleted
Here is the complete code
@model IEnumerable<cms_monitoring.models.student_experience>
@{
Layout = null;
}
<title>Index
// var DeleteClick = function (id) {
//$doucment.getElementById('#btnDelete').click(function (e) {
// alert('i am clicked ');
// // e.preventDefault();
// debugger;
function DeleteClick(id)
{
$.ajax({
type: "POST",
//url: "/Student_Experience/Delete",
url: '@Url.Action("Delete", "Student_Experience")',
data: JSON.stringify({ id: id }), //use id here
// dataType: "json",
// contentType: "application/json; charset=utf-8",
success: function () {
// alert("Data has been deleted.");
location.reload();
$(".demo1").html(result);
},
error: function () {
alert("Error while deleting data");
}
});
}
@*function DeleteClick(id) {
$('#btnDelete').click(function (e) {
e.preventDefault();
$.ajax({
type: "POST",
url: '@Url.Action("Delete", "Student_Experience")',
data: JSON.stringify({ id: id }), //use id here
dataType: "json",
contentType: "application/json; charset=utf-8",
success: function () {
// alert("Data has been deleted.");
location.reload();
$(".demo1").html(result);
},
error: function () {
alert("Error while deleting data");
}
});
})*@
@*var DeleteClick= function(id) {
// $(document.getElementById("sbmtInput").click(function(e){}
$('#btnDelete').click(function (e) {
alert('this is me');
e.preventDefault();
$.ajax({
type: "POST",
url: '@Url.Action("Delete", "Student_Experience")',
data: JSON.stringify({ id: id }), //use id here
// dataType: "json",
// contentType: "application/json; charset=utf-8",
success: function () {
// alert("Data has been deleted.");
location.reload();
$(".demo1").html(result);
},
error: function () {
alert("Error while deleting data");
}
});
});*@
@*
@Html.ActionLink("Create New", "Create")
*@
@if (Model.Count() > 0)
{
@foreach (var item in Model)
{
}
@Html.DisplayNameFor(model => model.Degree_Level)
@Html.DisplayNameFor(model => model.Degree_Name)
@Html.DisplayNameFor(model => model.Institution_Attended)
@Html.DisplayNameFor(model => model.BoardORUniversity)
@Html.DisplayNameFor(model => model.MarksObtained)
@Html.DisplayNameFor(model => model.TotalMarks)
@Html.DisplayNameFor(model => model.Year_Passed)
@Html.DisplayNameFor(model => model.Active)
@Html.DisplayNameFor(model => model.Date_Started)
@Html.DisplayNameFor(model => model.Date_End)
Actions @Html.DropDownL
Malikdanish
25-Oct-19 5:37am
View
Line 86: Line 87:
Line 88: @foreach (var item in Model)
Line 89: {
Line 90:
Malikdanish
18-Oct-19 6:14am
View
The entity types 'ExtendedUser' and 'Registration' cannot share table 'Registrations' because they are not in the same type hierarchy or do not have a valid one to one foreign key relationship with matching primary keys between them.
Malikdanish
18-Oct-19 5:37am
View
i have custom created classes not the entity framework generated classes.
Malikdanish
18-Oct-19 5:22am
View
Now getting this error messsage
The entity type ActivateUser is not part of the model for the current context..
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: The entity type ActivateUser is not part of the model for the current context.
Source Error:
Line 162: // ModelState["Password"].Errors.Clear();
Line 163: // registration.Password = "ASDF";
Line 164: db.Entry(ActivateUsers).State = EntityState.Modified;
Line 165: try
Line 166: {
Malikdanish
18-Oct-19 5:04am
View
F_ES siteCore
ModelState.Remove("FirstName");
ModelState.Remove("LastName");
ModelState.Remove("ReportingManager");
ModelState.Remove("ResetPasswordCode");
ModelState.Remove("Mobile");
ModelState.Remove("Password");
why it is not removing Password from model
Malikdanish
18-Oct-19 4:47am
View
should i not create a small view with just four properties and then use that view but how do i map this view to the same table to which the first view is mapped
Malikdanish
12-Sep-19 2:55am
View
can you share a running code sample , I have created the dynamic controls but right now i am not able to submit all form values to controller how to do that , My input control is having this mark up
Malikdanish
1-May-19 8:23am
View
there is only one record having that email and password
Malikdanish
1-May-19 8:22am
View
[Table("Registration")]
public class Registration
{
[Key]
public int RegistrationID { get; set; }
[Required(ErrorMessage = "Enter Name")]
public string Name { get; set; }
[Required(ErrorMessage = "Mobileno Required")]
[RegularExpression(@"^(\d{10})$", ErrorMessage = "Wrong Mobileno")]
public string Mobileno { get; set; }
[Required(ErrorMessage = "EmailID Required")]
[RegularExpression(@"^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$", ErrorMessage = "Please enter a valid e-mail adress")]
public string EmailID { get; set; }
[MinLength(6, ErrorMessage = "Minimum Username must be 6 in charaters")]
[Required(ErrorMessage = "Username Required")]
public string Username { get; set; }
[MinLength(7, ErrorMessage = "Minimum Password must be 7 in charaters")]
[Required(ErrorMessage = "Password Required")]
public string Password { get; set; }
[Compare("Password", ErrorMessage = "Enter Valid Password")]
public string ConfirmPassword { get; set; }
[Required(ErrorMessage = "Gender Required")]
public string Gender { get; set; }
public DateTime? Birthdate { get; set; }
public DateTime? DateofJoining { get; set; }
public int? RoleID { get; set; }
[MaxLength(5, ErrorMessage = "Minimum Password must be 7 in charaters")]
public string EmployeeID { get; set; }
public DateTime? CreatedOn { get; set; }
public int? ForceChangePassword { get; set; }
}
}
my table name is Registration
Malikdanish
1-May-19 8:19am
View
public partial class DatabaseContext : DbContext
{
public DatabaseContext()
: base("name=TimesheetDBEntities")
{
}
//protected override void OnModelCreating(DbModelBuilder modelBuilder)
//{
// base.OnModelCreating(modelBuilder);
//}
public DbSet<registration> Registration { get; set; }
public DbSet<roles> Role { get; set; }
public DbSet<projectmaster> ProjectMaster { get; set; }
public DbSet<timesheetmaster> TimeSheetMaster { get; set; }
public DbSet<timesheetdetails> TimeSheetDetails { get; set; }
public DbSet<expensemodel> ExpenseModel { get; set; }
public DbSet<documents> Documents { get; set; }
public DbSet<timesheetaudittb> TimeSheetAuditTB { get; set; }
public DbSet<expenseaudittb> ExpenseAuditTB { get; set; }
public DbSet<audittb> AuditTB { get; set; }
public DbSet<descriptiontb> DescriptionTB { get; set; }
public DbSet<assignedroles> AssignedRoles { get; set; }
public System.Data.Entity.DbSet<webtimesheetmanagement.models.notificationstb> NotificationsTBs { get; set; }
}
Malikdanish
1-May-19 8:13am
View
i have record in table
Malikdanish
24-Jun-18 11:14am
View
Ok , thanks for assisting in a true manner . I will check by that way.
Malikdanish
10-Jun-18 14:15pm
View
issue is with your project not with signalR try to create another project and repeat the steps
Malikdanish
7-Feb-18 15:47pm
View
easy response i checked
Malikdanish
15-Jan-18 12:47pm
View
static void Main(string[] args)
{
// Create a request for the URL.
WebRequest request = WebRequest.Create("https://gdgsdf.myshopify.com/admin/customers.json");
// Set the credentials.
request.Credentials = new NetworkCredential("hhhh", "hhhh");
// Get the response.
HttpWebResponse response = null;
try
{
// This is where the HTTP GET actually occurs.
response = (HttpWebResponse)request.GetResponse();
}
catch (Exception a)
{
Console.WriteLine(a.ToString());
}
// Display the status. You want to see "OK" here.
Console.WriteLine(response.StatusDescription);
// Get the stream containing content returned by the server.
Stream dataStream = response.GetResponseStream();
// Open the stream using a StreamReader
StreamReader reader = new StreamReader(dataStream);
// Read the content. T
string responseFromServer = reader.ReadToEnd();
// Display the content.
Console.WriteLine(responseFromServer);
// Cleanup the streams and the response.
reader.Close();
dataStream.Close();
response.Close();
}
that solve my issue
Malikdanish
15-Jan-18 9:56am
View
my code gives error on that line " using (var resp = (HttpWebResponse)req.GetResponse())
The request was aborted: Could not create SSL/TLS secure channel
Malikdanish
15-Jan-18 9:55am
View
this project is not opening in vs 2010/2013
Malikdanish
29-Jul-17 15:09pm
View
i fix the issue :) quite a long ago
Malikdanish
25-Mar-17 0:40am
View
I shared a code for review
Malikdanish
4-Feb-17 7:00am
View
I have a simple index view in which i have five text box and i have a method in home controller i want to get call this method on button click of a button placed on index method how to achieve this can i send you my code on email
Malikdanish
4-Feb-17 5:58am
View
When i remove the [httppost] and put a debug breakpoint then it comes to method but when i make is
httppost then it does not come to my method
Malikdanish
4-Feb-17 5:37am
View
Thanks Afzaal Ahmad Zeeshan , basically I have a simple MVC view having four labels and four textboxes i am using API to send sms to any number so my textboxes would have values
1-API_KEY (required to send sms from API Gateway Like thetexting.com)
2-API_SECRET(also required......)
3-TO_Number ( to which i want to send sms)
4-Message(message which need to be send)
for that purposes i write simple class name configuration class
public class ConfigurationSettings
{
[Key]
[ScaffoldColumn(false)]
public int RecordID { get; set; }
// [Required(ErrorMessage = "EmployeeName is required")]
//public string EmployeeName { get; set; }
// [Required(ErrorMessage = "EmployeeID is required")]
// public int EmployeeID { get; set; }
[Required(ErrorMessage = "API_KEY is required")]
public string API_KEY { get; set; }
[Required(ErrorMessage = "API_SECRET is required")]
public string API_SECRET { get; set; }
[Required(ErrorMessage = "API_SECRET address is required")]
[Display(Name = "To_Number")]
public int To_Number { get; set; }
[Required(ErrorMessage = "To_Number is required")]
[DataType(DataType.PhoneNumber)]
public string TextMessage { get; set; }
and my view is
@model TheTextingDemo.Models.ConfigurationSettings
TheTexting SMS GateWay Demo
<script src="@Url.Content("~/Scripts/jquery.validate.min.js")" type="text/javascript">
<script src="@Url.Content("~/Scripts/jquery.validate.unobtrusive.min.js")" type="text/javascript">
@Html.ValidationSummary(true, "Login was unsuccessful. Please correct the errors and try again.")
@using (Html.BeginForm())
{
Account Information
@Html.LabelFor(model => model.API_KEY)
@Html.TextBoxFor(model => model.API_KEY)
@*@Html.ValidationMessageFor(model => model.API_KEY)*@
@Html.LabelFor(model => model.API_SECRET)
@Html.TextBoxFor(model => model.API_SECRET)
@*@Html.ValidationMessageFor(model => model.API_SECRET)*@
@Html.LabelFor(a => a.To_Number)
@Html.TextBoxFor(a => a.To_Number)
@*@Html.ValidationMessageFor(a => a.To_Number)*@
@Html.LabelFor(a => a.TextMessage)
@Html.TextBoxFor(a => a.TextMessage)
@Html.ValidationMessageFor(a => a.TextMessage)
@*@Html.ActionLink("link text", "SendSMS", "Home", null, null)
Add an Admin
@Url.Action("SendSMS", "Home")
*@
}
and my method is
public ActionResult SendSMS(ConfigurationSettings sm)
{
// TheTextingDemo.Models.ConfigurationSettings s1 = new Models.ConfigurationSettings();
//string API_KeY = Request.QueryString["txtRate"].ToString();
string API_KEY = "wwpiub1gcfk49a1";
string API_SECRET = "j5hsuac8f6mdzdd";
string TO = "923215029981";
string Message = "Hello world";
string sURL;
StreamReader objReader;
//string ssurl="https://www.thetexting.com/rest/sms/json/message/send?api_key=wwpiub1gcfka1&api_secret=j5hsf6mdzdd&to=9232199999981&text=Hello"
sURL = "https://www.thetexting.com/rest/sms/json/message/send?api_key=" + API_KEY + "&api_secret=" + API_SECRET + "&to=" + TO + "&text=" + Message;
WebRequest wrGETURL;
Malikdanish
2-Feb-17 13:35pm
View
Dear check the above code pls
Malikdanish
2-Feb-17 13:33pm
View
Deleted
function onClick() {
var apiKey = document.getElementById("api").value;
var secret = document.getElementById("secret").value;
var to = document.getElementById("to").value;
var from = document.getElementById("from").value;
var text = document.getElementById("text").value;
var data = "api_secret=" +
secret + // chane
"&api_key=" +
apiKey + // change
"&to=" +
to + // change
"&text=" +
text + // change
"&type=text";
var xhr = new XMLHttpRequest();
xhr.withCredentials = true;
xhr.onreadystatechange = function () {
if (this.readyState === 4 && this.status === 200) {
alert("Message Sent");
// document.getElementById("api").value = "";
// document.getElementById("secret").value = "";
document.getElementById("to").value = "";
document.getElementById("from").value = "";
document.getElementById("text").value = "";
} else {
// alert("Message Failed");
// document.getElementById("api").value = "";
// document.getElementById("secret").value = "";
document.getElementById("to").value = "";
document.getElementById("from").value = "";
document.getElementById("text").value = "";
}
};
xhr.open("POST", "https://www.thetexting.com/rest/sms/json/message/send");
xhr.setRequestHeader("cache-control", "no-cache");
xhr.setRequestHeader("content-type", "application/x-www-form-urlencoded");
xhr.send(data);
}
API key:
Secret:
To:From: text:
Malikdanish
2-Feb-17 13:26pm
View
Deleted
how to make the url like that once i collect all the data from the user in textboxes then what i have to do?
Malikdanish
19-Dec-16 5:45am
View
If i came into with an issue which is still exists even if it is very odd one , but before some time this was a method to get values , i know i should have to go with strongly type models to make the database transaction , but my question is here how to get the textbox values in code with Request object or form object I have tried that .
@using (Html.BeginForm("SaveRecords","Property",FormMethod.Post))
{
@Html.TextBox("title")
Price
(in PKR)
@Html.TextBox("txtPrice", null, new { @class = "form-control valid", @data_val = "true", @data_val_required = "Property Price is required" })
@Html.ValidationSummary()
}
my controller is like that
[HttpPost]
public ActionResult SaveRecords(FormCollection form)
{
if(form != null)
{
string principle1 = form["title"].ToString();
string principle = Request["title"].ToString();
}
string Title=Request.QueryString["title"];
String connectionString = "Data Source=ASPKCO-DANISH\\SQLEXPRESS1;Initial Catalog=PakeezaSodagran;Integrated Security=True;";
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand comm = new SqlCommand("insert into PropertyPosts(title) values(" + Request.QueryString["title"], conn);
try
{
comm.ExecuteNonQuery();
// Request.QueryString["text"] = null;
}
catch (Exception)
{
// MessageBox.Show("Not Saved");
}
finally
{
conn.Close();
}
return View();
}
Malikdanish
12-Oct-16 10:18am
View
Thanks for support and assistance as i already told you that I am trying to debug the code but before going to the Debug point i get an error , and secondly sometimes there are visual errors I mean the error's which can be traced by visualization so that is the need I placed the whole code of my Model.. there is nothing wrong with the duplication of records inserted into the table because my code does not reach the point to insert the data before that it gives the above error
Malikdanish
12-Oct-16 10:16am
View
Thanks for your support i know the Security Back locks here but the issue is here related to model ? can you assists in that
Malikdanish
12-Oct-16 6:22am
View
IF I am placing the whole code as i am not sure where the error comes from and as per my R & D the issues suggest that I have some duplicate properties i have checked that and i could not found any duplication as all the resources require the full model code so i place the full code here i am trying to format it ,
Malikdanish
12-Oct-16 6:10am
View
All code is required and it is formatted i think as well this whole code belongs to my model and there is not any specific place where i am getting error my application does not go to the code in debug mode before that it gives an error mentioned on title of the thread
Malikdanish
10-Oct-16 4:12am
View
yes they said that we have all things ok up and running but the crystal report version differ at both sides ? does this problem is due to that difference
Malikdanish
3-Oct-16 13:46pm
View
No Url.Content is available i thing Server.MapPath() is an alternative but it also not worked for me
Malikdanish
3-Oct-16 12:31pm
View
Dear thanks for your response by doing that my images from the home{index view} also disappear when i checked the path of the images it is like that
C:\Users\dhabib\Documents\Visual Studio 2010\Projects\MVC\BusinessApplicationTemplate\BusinessApplicationTemplate\Images\img\009-Living_Room-2169443-large-2.png
I have solve the issue by
src = "../../Images/img/" + fileName
Thanks again for your support
Malikdanish
2-Oct-16 5:24am
View
public List(slider) GetData()
{
string[] filePaths = Directory.GetFiles(System.Web.HttpContext.Current.Server.MapPath("/Images/img/"));
List(slider) files = new List(slider)();
var model = new System.Collections.Generic.List(slider)();
foreach (string filePath in filePaths)
{
string fileName = Path.GetFileName(filePath);
model.Add(new slider
{
title = fileName.Split('.')[0].ToString(),
src = "../Images/img/" + fileName
});
}
return model;
}
angle brakets are now allowed so i place () brakets
Malikdanish
2-Oct-16 5:21am
View
Basically My silder and css works fine on home controller also on service controller but when i click on any of the service details then the images get broken i found why it is so when i hover on the img tag using inspect element in chrome browser it shows that instead of finding the image from root/Images/google.png it is finding the image from root/Service/images/google.png
below is my readmore button as well as controller method
@Html.ActionLink("ReadMore", "Details", "Service", new { id = item.ID },null)
public ActionResult Details(int id)
{
slider sd = new slider();
//sd.GetData();
// viewModelVm vm = new viewModelVm();
Service sr = new Service();
sr.Getdatabyid(id);
viewModelVm vm = new viewModelVm();
vm.slider = sd.GetData();
vm.service = sr.Getdatabyid(id);
Service ss = sr.Getdatabyid(id);
return View(vm);
}
Malikdanish
2-Oct-16 5:18am
View
Deleted
public class slider : Controller
{
public string src { get; set; }
public string title { get; set; }
public List
Malikdanish
20-Sep-16 0:25am
View
My Question Is not related to hosting issue , i just define the sceniro why i have been provided a space to another server {because my crystal reports } was not working .
Now My question is {I have been given a hosting space of the server with the server IP and username,password, I logged into that account and went to the admin panel i have uploaded my project there , How to test this project which is hosted on new domain using IIS ? how do i publish the website using IIS by giving the server IP , UserName and password.I want to Test the application i have given the space but not the domain name {i mean the url to go and test the application } so I can test it locally using IIS and i need to configure my IIS to use the server IP and there hosted application , instead of the application residing on my machine .
Thanks for clerification regarding my query .. I understood
Malikdanish
19-Sep-16 14:42pm
View
if you are unable to understand the issue then you need to let the other's to listen
Malikdanish
19-Sep-16 14:41pm
View
Do not by hyper , my question clearly mentioning the hosting related issue how to host the application on the server using IIS ?
Malikdanish
7-Sep-16 7:16am
View
They said that everything is ok from our side
Malikdanish
5-Sep-16 7:55am
View
It does not work on the pages having crystal reports in them http://www.planrbme.com.pk/Default.aspx becomes http://planrbme.com.pk/hello/login.aspx?ReturnUrl=%2fhello%2fDefault.aspx
Why it becomes like that I am using simple Login Form Authentication in web forms asp.net
Malikdanish
5-Sep-16 7:21am
View
I have a simple Crystal report on the page , http://www.planrbme.com.pk/Default.aspx becomes http://planrbme.com.pk/hello/login.aspx?ReturnUrl=%2fhello%2fDefault.aspx
Why it becomes like that I am using simple Login Form Authentication in web forms asp.net
Malikdanish
2-Aug-16 12:10pm
View
Dan habib yes i did
Malikdanish
2-Aug-16 7:36am
View
may i add you on my professional network ?
Malikdanish
2-Aug-16 6:47am
View
I did that too. Thanks again
Malikdanish
2-Aug-16 3:19am
View
The problem was from the server which was not receiving my email , may b blocking the IP so contacting them resolved the issue Many Thanks to all of you specially Tadit Dash you support alot , now i will write an article on that specific Topic very soon because after doing lot of R & D i have to put it int a forum and code project is the absolute place.
Malikdanish
2-Aug-16 3:16am
View
it was the issue from the mail server which was blocking the IP , Thanks you all for support OriginalGriff many thanks you too to put me on debugging until the problem resolved .:) thanks its a good practice
Malikdanish
1-Aug-16 14:02pm
View
I am also confused it is sending email to marktabor47@gmail.com,also send email to spober_woh@yahoo.com but not to danish.habib@plan-international.org
Malikdanish
1-Aug-16 8:15am
View
nothing it is sending nothing ? when it gets danish.habib@plan-international.org when i Hard code this email to mail.CC.ADD("danish.habib@plan-international.org") then it sends email correctly
Malikdanish
1-Aug-16 7:36am
View
method in the button click
1- SendMAilMessage()
2- Private Sub SendMAilMessage()
Dim body As String = Me.PopulateBody("Dear User", _
"Result based Monitoring And Evaluation system from Plan PAKISTAN", _
"http://www.planrbme.com.pk" & _
"", _
("we are very pleased to inform you that your requested achievement against the targets have been approved by the supervisor .<br/> " & _
"
Suggested Comments are :
{" & AcceptComments & "} .<br/>.<br/> " & _
"<br/>.<br/>
Dated:
" & DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss ")))
Me.SendHtmlFormattedEmail(GetUserIDEmail(ddlusers.SelectedValue), "Record Accepted", body)
End Sub
3- Private Sub SendHtmlFormattedEmail(ByVal recepientEmail As String, ByVal subject As String, ByVal body As String)
Dim mailMessage As System.Net.Mail.MailMessage = New System.Net.Mail.MailMessage
Try
mailMessage.From = New MailAddress(ConfigurationManager.AppSettings("UserName"))
' mailMessage.CC.Add("danish.habib@plan-international.org")
mailMessage.Bcc.Add("spober_woh@yahoo.com")
mailMessage.Subject = subject
mailMessage.Body = body
mailMessage.IsBodyHtml = True
mailMessage.To.Add(New MailAddress(recepientEmail))
Dim files As List(Of HttpPostedFile) = DirectCast(Cache(Me.Key), List(Of HttpPostedFile))
For Each file As HttpPostedFile In files
mailMessage.Attachments.Add(New Attachment(file.InputStream, Path.GetFileName(file.FileName), file.ContentType))
Next
mailMessage.From = New MailAddress("omer@planrbme.com.pk")
Dim smtp As New SmtpClient()
smtp.Host = "202.165.228.15"
smtp.EnableSsl = False
smtp.Credentials = New System.Net.NetworkCredential("omer@planrbme.com.pk", "Pakistan_123")
smtp.Port = 25
smtp.Send(mailMessage)
Catch ex As Exception
ex.Message.ToString()
End Try
End Sub
Private Function GetUserIDEmail(ByVal UserId As Integer) As String
Dim UserType As String = Nothing
Dim cnnResource As New SqlConnection(AppSettings("DbSqlPortal"))
Dim cmdResource As New SqlCommand("GetEmailAddressForDropdownFromPartner", cnnResource)
Dim drResource As SqlDataReader = Nothing
cmdResource.CommandType = CommandType.StoredProcedure
cmdResource.Parameters.Add("@UserId", SqlDbType.NVarChar).Value = ddlusers.SelectedValue
Try
cnnResource.Open()
drResource = cmdResource.ExecuteReader(CommandBehavior.SingleRow)
If drResource IsNot Nothing AndAlso drResource.Read() Then
UserType = drResource("Email")
Else
Throw New Exception("Record could not be found/read.")
End If
Catch ex As Exception
ex.Message.ToString()
Finally
End Try
Hdm.Value = UserType
Return UserType
End Function
Malikdanish
1-Aug-16 3:57am
View
it gets the email address correctly
Malikdanish
1-Aug-16 2:53am
View
secondly when previouslly when i was not getting any exception than i receive that email i think it puts my email into the spam folder as shown below how to allow to receive email on domain danish.habib@plan-international.org
Here is your quarantine summary for 7/31/2016 - 8/1/2016:
These messages were quarantined before they reached your inbox as potential spam. The quarantined messages can be sent to your inbox using the Deliver links below. This will train the system not to identify similar messages as spam.
Subject Sender Date Action
Record Accepted omer@planrbme.com.pk
8/1/2016 6:40 AM Deliver
Record Accepted omer@planrbme.com.pk
8/1/2016 6:35 AM Deliver
Record Accepted omer@planrbme.com.pk
8/1/2016 5:38 AM Deliver
Record Accepted omer@planrbme.com.pk
7/31/2016 7:32 PM Deliver
Record Accepted omer@planrbme.com.pk
7/31/2016 7:10 PM Deliver
Record Accepted omer@planrbme.com.pk
7/31/2016 7:05 PM Deliver
Record Accepted omer@planrbme.com.pk
7/31/2016 7:01 PM Deliver
Record Accepted omer@planrbme.com.pk
7/31/2016 6:57 PM Deliver
Record Accepted omer@planrbme.com.pk
7/31/2016 6:52 PM Deliver
HBO's UX Design Team uses UXPin UXPin
hello@uxpin.com
7/31/2016 2:00 PM Deliver
Record Rejection omer@planrbme.com.pk
7/31/2016 12:53 PM Deliver
Record Rejection omer@planrbme.com.pk
7/31/2016 12:43 PM Deliver
Record Rejection omer@planrbme.com.pk
7/31/2016 12:08 PM Deliver
Record Rejection omer@planrbme.com.pk
7/31/2016 10:19 AM Deliver
Malikdanish
1-Aug-16 2:51am
View
i am getting "Failure sending mail." message it did not work for any of the email address , my project sometimes gives that error i do not know why it is so Inner exception shows "{"A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 202.165.228.15:25"}"
Malikdanish
1-Aug-16 2:18am
View
ok Thanks i am checking that Thanks for assistance and support
Malikdanish
1-Aug-16 2:10am
View
mailMessage.To.Add(New MailAddress(recepientEmail)) when i check my recepientEmail it has correct address but i do not know weather i have to convert it into a string at the end or not , my recepientEmail having correct email address
Malikdanish
1-Aug-16 1:11am
View
When i am getting my domain email address by calling a method then it does not send email to that address when i hard coded it then it send the email my domain email is d.habib@plan-international.org , below the code of send email method .
Private Sub SendHtmlFormattedEmail(ByVal recepientEmail As String, ByVal subject As String, ByVal body As String)
Dim mailMessage As System.Net.Mail.MailMessage = New System.Net.Mail.MailMessage
Try
mailMessage.From = New MailAddress(ConfigurationManager.AppSettings("UserName"))
' mailMessage.CC.Add("danish.habib@plan-international.org")
mailMessage.Bcc.Add("spober_woh@yahoo.com")
mailMessage.Subject = subject
mailMessage.Body = body
mailMessage.IsBodyHtml = True
mailMessage.To.Add(New MailAddress(recepientEmail))
Dim files As List(Of HttpPostedFile) = DirectCast(Cache(Me.Key), List(Of HttpPostedFile))
For Each file As HttpPostedFile In files
mailMessage.Attachments.Add(New Attachment(file.InputStream, Path.GetFileName(file.FileName), file.ContentType))
Next
mailMessage.From = New MailAddress("omer@planrbme.com.pk")
Dim smtp As New SmtpClient()
smtp.Host = "202.165.228.15"
smtp.EnableSsl = False
smtp.Credentials = New System.Net.NetworkCredential("omer@planrbme.com.pk", "Pakistan_123")
smtp.Port = 25
smtp.Send(mailMessage)
Catch ex As Exception
ex.Message.ToString()
End Try
End Sub
End Sub
Malikdanish
28-Jul-16 3:53am
View
no exception I have two method to send an email the one having the formatting does not send an email and the other one send correctly , they both are good with other email accounts excepts my domain email like danish.h@plan-international.org the second method have no formatting works on all email address but the first one having formatting does not work on that domain and work on other domains . today i got an email from the method which does not sending email i got email like below
Now i have received an email which says
Here is your quarantine summary for 7/27/2016 - 7/28/2016:
These messages were quarantined before they reached your inbox as potential spam. The quarantined messages can be sent to your inbox using the Deliver links below. This will train the system not to identify similar messages as spam.
system not to identify similar messages as spam.
Subject
Sender
Date
Action
Record Accepted
rbme@planrbme.com.pk
7/28/2016 6:59 AM
Deliver
Record Accepted
rbme@planrbme.com.pk
7/28/2016 6:44 AM
Deliver
it means they are considering it as spam and then send an email to me here i have to click the Deliver Action then it get send ? what is the work around to fix this issue ?
Malikdanish
27-Jul-16 3:14am
View
thanks for assistance my code works fine for other email addresses except my company domain email address danish.habib@plan-international.org
, I have another method which is sending email correctly to all email address but that method is not formatting the email content so i wrote another method which is not sending email .
Malikdanish
26-Jul-16 6:44am
View
Thank Richard MacCutchan I am checking it again Thanks for putting time on my issue
Malikdanish
26-Jul-16 6:38am
View
I have cross checked my email credentials they are 100% working and when i tried the same email using gmail smtp it works fine
Malikdanish
26-Jul-16 6:29am
View
remove all the email body and write it again ?
Malikdanish
26-Jul-16 6:21am
View
i have checked my domain email address using webmail it is sending and receiving both,
Malikdanish
26-Jul-16 6:19am
View
I have checked that and using telnet as well as manually send email using my domain email account it works fine with port 25
Malikdanish
26-Jul-16 6:01am
View
yes. Then should I contact with them ?
Malikdanish
26-Jul-16 5:57am
View
I did post all of these Question , but they are not in similar nature , if you can go through them , secondly if i am posting here then it is understood that i have gone through all the resources from the internet and i could not find a solution so i thought that from here i can get assistance , if Codeproject team is annoyed on posting then sorry for that , I have my community all are subscribed with Code project , if this post looks similar to previous then you do not need to think about it . Sorry if any word which is harmful
Malikdanish
26-Jul-16 1:28am
View
can you assist me any more , i want to share with you the whole code snippet
Malikdanish
26-Jul-16 1:27am
View
can you assist me more
Malikdanish
26-Jul-16 1:26am
View
can you assist me share your email i will send you the whole code snippets i am trying from past one day but still get stuck
Malikdanish
25-Jul-16 11:23am
View
my second method works fine the first one is having issue i may have removed that line from second method , but the issue is with first method.
Malikdanish
25-Jul-16 9:25am
View
Dear I Understand what you said , Actually i just want to confirm that why my second method works fine with same smtp configuration and my first method is not working , Actually My first methods is called by another method ,so it calls that email sending method.
Malikdanish
25-Jul-16 9:20am
View
My code executed well no error no warning no exception , I have specified the Mail.TO as well in my code
mailMessage.To.Add(New MailAddress(recepientEmail))
Malikdanish
25-Jul-16 7:41am
View
I have outlook configured it has inbox,Drats,SentItem,deletedItems,Junk,outbox,Clutter, No Spam folder and in these my email does not coming in these folder
Malikdanish
25-Jul-16 7:22am
View
I want to send an email to a company domain account like danish.habib@plan-international.org
Malikdanish
25-Jul-16 7:20am
View
my first method is using the same smtp.gmail and it works fine ?why the second one is not working
Malikdanish
17-Jun-16 2:07am
View
it works
Malikdanish
17-Jun-16 1:15am
View
SELECT t1.DynamicIndicatorID,t1.District,x.filenameName,t1.Quarter,t1.District,t1.TFA,t1.TFB,t1.TFG,t1.TFW,t1.TFM,x.fileID as fileID ,x.filenameName,x.IndicatorID
FROM DynamicIndicatorsTargetsForPu t1
LEFT JOIN (
SELECT tb.IndicatorID,tb.filenameName,tb.filePath, tb.Createdby,tb.fileID
FROM tblUploadedFiledetailsForPartners as tb
INNER JOIN
(SELECT IndicatorID, MAX(fileID) AS fileid
FROM tblUploadedFiledetailsForPartners group by IndicatorID)Tab
ON
tab.fileid=tb.fileID AND
tab.IndicatorID=tb.IndicatorID
) x ON t1.DynamicIndicatorID = x.IndicatorID
where t1.UserId=59
that is good one
Malikdanish
17-Jun-16 0:42am
View
SELECT t1.DynamicIndicatorID,t1.District,t1.Quarter,t1.District,t1.TFA,t1.TFB,t1.TFG,t1.TFW,t1.TFM,x.fileID as fileID ,TP.filenameName
FROM DynamicIndicatorsTargetsForPu t1
INNER JOIN tblUploadedFileDetailsForPartners as TP on TP.IndicatorID=t1.DynamicIndicatorID
LEFT JOIN (
SELECT IndicatorID, MAX(fileID) AS fileid
FROM tblUploadedFiledetailsForPartners group by IndicatorID
) x ON t1.DynamicIndicatorID = x.IndicatorID
where t1.UserId=59
it is giving all records instead of the latest Max(fileID)
Malikdanish
16-Jun-16 0:05am
View
how to add filename from table2 with the below query
SELECT t1.DynamicIndicatorID,t1.District,t1.Quarter,t1.District,t1.TFA,t1.TFB,t1.TFG,t1.TFW,t1.TFM,x.fileID as fileID
FROM DynamicIndicatorsTargetsForPu t1
LEFT JOIN (
SELECT IndicatorID, MAX(fileID) AS fileid
FROM tblUploadedFiledetailsForPartners group by IndicatorID
) x ON t1.DynamicIndicatorID = x.IndicatorID where t1.UserId=61
Malikdanish
15-Jun-16 5:36am
View
it works some how ? i am trying to get full result from that and then will mark you the right ghy :)
Malikdanish
15-Jun-16 2:03am
View
SELECT t1.DynamicIndicatorID,t1.District,t1.Quarter,t1.District,t1.TFA,t1.TFB,t1.TFG,t1.TFW,t1.TFM,x.fileID as fileID,x.filenameName as FileName
FROM DynamicIndicatorsTargetsForPu t1
LEFT JOIN (
SELECT IndicatorID, MAX(fileID) AS fileid,filenameName
FROM tblUploadedFiledetailsForPartners group by IndicatorID
) x ON t1.DynamicIndicatorID = x.IndicatorID where t1.UserId=59
it is saying "Msg 8120, Level 16, State 1, Line 4
Column 'tblUploadedFiledetailsForPartners.filenameName' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause." otherwise it works
Malikdanish
15-Jun-16 0:30am
View
No worked , thanks for putting the time i am trying
Malikdanish
14-Jun-16 11:52am
View
DynamicIndicatorID primary key
AND IndicatorID Foreign key
Malikdanish
14-Jun-16 11:51am
View
I did Left Outer Join
select DI.DynamicIndicatorID,Di.District ,Di.Quarter,DI.District,DI.TFA,DI.TFB,DI.TFG,DI.TFW,DI.TFM from DynamicIndicatorsTargetsForPu
AS DI
LEFT OUTER JOIN tblUploadedFiledetailsForPartners as tpl ON tpl.fileID IN ( select max(fileID) from tblUploadedFiledetailsForPartners group by fileID)
where DI.Userid=61 AND DI.DynamicIndicatorID=tpl.IndicatorID
Malikdanish
14-Jun-16 11:48am
View
it is not showing the records who does not have file in second table
Malikdanish
14-Jun-16 11:27am
View
I have tried this but it does not work ? can you write it how you are saying ?
Malikdanish
12-May-16 9:43am
View
Dear As i stated i have download a project in which in the _Layout view it is calling a partial view for menu item but it is static view i want the menu to be dynamic comes from database table using the entity data model , How to call a partial view having a controller action as well ?
Malikdanish
19-Feb-16 2:21am
View
I have updated that section now ..
Malikdanish
13-Feb-16 5:09am
View
Deleted
Where to find www.google.com :)
Malikdanish
10-Feb-16 12:49pm
View
its solved now Thanks Sascha
Malikdanish
10-Feb-16 11:25am
View
Dear Sascha Lefevre can you check this here i explained in greater details about my issue http://www.c-sharpcorner.com/forums/gridview-editing-issue
Malikdanish
10-Feb-16 10:52am
View
i have showed now ...check it ..
Malikdanish
10-Feb-16 7:47am
View
Deleted
[moved code to question] (Sascha)
Malikdanish
25-Jan-16 10:53am
View
ok thanks
Malikdanish
24-Jan-16 22:20pm
View
yes i did they are not responding ..
Malikdanish
17-Nov-15 7:50am
View
Thanks
Malikdanish
17-Nov-15 6:10am
View
I am asking for an idea not the code my dear
Malikdanish
21-Oct-15 13:35pm
View
Deleted
Foothill your query modification works fine Thanks alot you done the job very nice , if you can explain why my previous query does not work with sqlite but work well with sql ..than i would be more thankful
Malikdanish
21-Oct-15 13:22pm
View
Deleted
Please define i am not getting what you are saying below is my query
com.CommandText = "SELECT MAX(DocumentCode) AS DocumentCode FROM DocumentsHeader WHERE (DocumentCode LIKE @DocumentCode + '%')";
Malikdanish
21-Oct-15 13:21pm
View
com is a sqlite command type
com = new SQLiteCommand();
Malikdanish
21-Oct-15 13:15pm
View
ok
Malikdanish
21-Oct-15 13:08pm
View
Deleted
public string GetDocumentCode(string Passvalue)
{
object returnvalue = null;
try
{
con = new SQLiteConnection(DMS_2008_Data.Properties.Settings.Default.DataConnection.ToString());
con.Open();
com = new SQLiteCommand();
com.Connection = con;
com.CommandType = CommandType.Text;
//com.CommandText = "SELECT MAX(DocumentCode) AS DocumentCode FROM DocumentsHeader";
com.CommandText = "SELECT MAX(DocumentCode) AS DocumentCode FROM DocumentsHeader WHERE (DocumentCode LIKE @DocumentCode + '%')";
// com.CommandText = "SELECT MAX(DocumentCode) AS DocumentCode FROM DocumentsHeader WHERE (DocumentCode '%' LIKE ('@DocumentCode')";
com.Parameters.Add("@DocumentCode", SqlDbType.NVarChar).Value = Passvalue.ToString().Trim();
returnvalue = com.ExecuteScalar();
if (returnvalue == null || returnvalue == DBNull.Value)
{
returnvalue = Passvalue + "00001";
}
else
{
int getvalue = 0;
getvalue = Convert.ToInt32(returnvalue.ToString().Substring(13, 5));
getvalue += 1;
if (getvalue >= 0 && getvalue <= 9)
{
returnvalue = Passvalue + "0000" + getvalue;
goto q;
}
else if (getvalue >= 0 && getvalue <= 99)
{
returnvalue = Passvalue + "000" + getvalue;
goto q;
}
else if (getvalue >= 0 && getvalue <= 999)
{
returnvalue = Passvalue + "00" + getvalue;
goto q;
}
else if (getvalue >= 0 && getvalue <= 9999)
{
returnvalue = Passvalue + "0" + getvalue;
goto q;
}
else if (getvalue >= 0 && getvalue <= 99999)
{
returnvalue = Passvalue + getvalue;
}
}
q: ;
com.Parameters.Clear();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (com != null)
com.Dispose();
if (con != null)
con.Dispose();
com = null;
con = null;
}
return returnvalue.ToString();
}
Malikdanish
21-Oct-15 13:07pm
View
When I remove the where part it is pulling the data and fetching the data . mean while this Query works fine with SQL server having similar DB schema , Is there any problem with Like operator or using this wild cards character + '%' .. The Same query works fine in sql server i have both Db for test purposes i test with SQL it works fine.Is there any difference in Like operator between these Two Database ?
Malikdanish
21-Oct-15 1:24am
View
Thanks u did great job Deeming
Malikdanish
21-Oct-15 0:48am
View
com.CommandText = "SELECT MAX(DocumentCode) AS DocumentCode FROM DocumentsHeader WHERE (DocumentCode LIKE @DocumentCode + '_')";
com.Parameters.Add("@DocumentCode", SqlDbType.NVarChar).Value = Passvalue.ToString().Trim();
returnvalue = com.ExecuteScalar();
Malikdanish
21-Oct-15 0:46am
View
It is of type nvarchar(255)
Malikdanish
20-Oct-15 16:14pm
View
My Database is having the record which is matched with wildcard % and it works fine but when i am woring with sqlite it does nt fetch the record from the db , I mean to say that This query works fine with SQL but with SQLITE it is not . about DB both DB Having 100 % same entries and same schema of DB as well
Malikdanish
20-Oct-15 16:12pm
View
Richard Deeming i checked that code and it works fine i devoted whole the day but i could not get what you told me within few minutes Thanks you Very Much
Malikdanish
20-Oct-15 15:55pm
View
Ok Richard I am on testing and will inform you .. Thanks alot
Malikdanish
20-Oct-15 15:49pm
View
After which line should i add this line of code ? Richard Deeming
Malikdanish
20-Oct-15 15:42pm
View
Thanks Richard Deeming I am checking and will inform you about Thanks Thanks for devoting your time and effort Appreciatable
Malikdanish
20-Oct-15 15:27pm
View
I did which you said
Malikdanish
20-Oct-15 15:22pm
View
Deleted
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Email.Attributes("type") = "email"
End Sub
Protected Sub ContactUsclick()
Try
If ctrlGoogleReCaptcha.Validate Then
Dim ID = System.Guid.NewGuid
Dim FullNameText = Trim(FullName.Value)
Dim CompanyNameText = Trim(CompanyName.Value)
Dim EmailText = Trim(Email.Value)
Dim PhoneText = Phone.Value
Dim SerialNumberText = SerialNumber.Value
Dim ProductLocationAddress = ProductLocation.Value
Dim CommentText = Trim(Comment.Value)
DataAccessLayer.DataAccess.InsertServiceRequest(ID, FullNameText, CompanyNameText, EmailText, _
PhoneText, SerialNumberText, ProductLocationAddress, CommentText)
Dim AttachmentList As New List(Of Attachment)
For Each UploadedFile As HttpPostedFile In FileUpload.PostedFiles
Dim ServiceQueueUniqueIdentifier = System.Guid.NewGuid
Dim strFileName As String = System.IO.Path.GetFileName(UploadedFile.FileName)
Dim attachment As New Attachment(UploadedFile.InputStream, strFileName)
AttachmentList.Add(attachment)
Dim fs As Stream = UploadedFile.InputStream
Dim br As New BinaryReader(fs)
'Dim bytes As Byte() = br.ReadBytes(fs.Length)
DataAccessLayer.DataAccess.InsertServiceRequestAttachments(ServiceQueueUniqueIdentifier, ID, UploadedFile.FileName, UploadedFile.ContentType, br.ReadBytes(fs.Length))
Next
Dim body As String = BusinessLogic.Utilities.MailingFunctions.FormatServiceRequestToXML(FullNameText, CompanyNameText, EmailText, PhoneText, _
SerialNumberText, ProductLocationAddress, CommentText, AttachmentList.Count)
BusinessLogic.Utilities.MailingFunctions.SendSMTPContactRequest("""Phiston Feedback Mailer""" & "<" & ConfigurationManager.AppSettings("ContactUSFromEmailAddress") & ">", _
"Shahrouz.ebadian@gmail.com", "Service Request Received", body, AttachmentList, Nothing)
'BusinessLogic.Utilities.MailingFunctions.SendSMTPContactRequest("""Phiston Feedback Mailer""" & "<" & ConfigurationManager.AppSettings("ContactUSFromEmailAddress") & ">", _
' ConfigurationManager.AppSettings("ServiceContactToEmailAddress"), "Service Request Received", body, AttachmentList, Nothing)
Response.Redirect("contactthanks.aspx")
Else
ErrorLbl.Visible = True
End If
Catch ex As Exception
Throw
End Try
End Sub
Public Shared Function FormatServiceRequestToXML(ByVal FullName As String, ByVal CompanyName As String, ByVal Email As String, ByVal Phone As String, _
ByVal Serial As String, ByVal ProductAddress As String, ByVal comment As String, ByVal AttachmentCount As Integer)
Try
Dim builder As StringBuilder = New StringBuilder
Dim body As String = ""
builder.Append("<table bgcolor='#33ffff' width='100%' border='1' cellpadding='0' cellspacing='0'>")
builder.Append("<tr>")
builder.Append("<td width='100%' align='center' colspan='2' bgcolor='#00bbff'>")
builder.Append("
Phiston Contact Us
")
builder.Append("</td>")
builder.Append("</tr>")
builder.Append("<tr>")
builder.Append("<td style='width: 20%'>
Date
</td>")
builder.Append("<td style='width: 80%'> ")
builder.Append(Now().ToLongDateString & " " & Now().ToLongTimeString)
builder.Append("</td>")
builder.Append("</tr>")
builder.Append("<tr>")
builder.Append("<td style='width: 20%'>
DB Name
</td>")
builder.Append("<td style='width: 80%'> ")
builder.Append(BusinessLogic.SystemInfo.SystemInformation.GetDBName)
builder.Append("</td>")
builder.Append("</tr>")
builder.Append("<tr>")
builder.Append("<td style='width: 100%' align='center' colspan='2' bgcolor='#00bbff'>
Information
</td>")
builder.Append("</tr>")
builder.Append("<tr>")
builder.Append("<td style='width: 20%' align='left'>
Full Name
</td>")
builder.Append("<td style='width: 80%' align='left'>" & FullName & "</td>")
builder.Append("</tr>")
builder.Append("<tr>")
builder.Append("<td style='width: 20%' align='left'>
Company Name
</td>")
builder.Append("<t
Malikdanish
20-Oct-15 15:20pm
View
Deleted
Dear Richard Its about 525 lines should i share it here ? can i attach a file over here
Malikdanish
20-Oct-15 15:18pm
View
Deleted
that the whole page code nothing else i have
Malikdanish
20-Oct-15 15:06pm
View
My Dear I am working remotely why i hide my code i also just made this calling method and the others methods are in build into our enterprise app they are working on other pages , and the error i already mention the line which create error the error is that when i add this line into my method it save the file into the db but does not send it via email attachment and when i omit or remove this line the email does have attachment but the file does not saved so instead of two one operation performed if i remove then line then attachment goes
Malikdanish
20-Oct-15 14:43pm
View
Thanks for response now that is the issue ..
So the code is for a webpage where a user UploadsFiles
I want to take the uploaded Files an do 2 things
1) Save files to Database
2) Email Files
The problem is I cant do both and let me explain why
This one line of code is causing a problem
DataAccessLayer.DataAccess.InsertServiceRequestAttachments(ServiceQueueUniqueIdentifier, ID, UploadedFile.FileName, UploadedFile.ContentType, br.ReadBytes(fs.Length))
That is the line that inserts the files into the database
that part works..
it inserts the data into the database no problem.. BUT
when that line is there when I get the emails the attachments are blank
If I take that line out... I get the email with the attachments no problem
make sense?
If I omit that line I get the attachments fine in the email
If i add the line. It saves to Database no problem but email has issues
So not sure why but something on that line is causing my email attachments to get cleared
Malikdanish
20-Oct-15 14:13pm
View
http://www.sqlite.org/download.html
Malikdanish
20-Oct-15 14:03pm
View
sqlite 3.7 i am using for me DB
Malikdanish
14-Oct-15 14:37pm
View
Dear i did not said that i am new to this section having just 2 to 3 year of experience i have been asked to migrate the app from sql server to Advantage database so i asked that can i do that in a simpler fashion can i use the SQL Script for creating object in sybase Advantage database
Malikdanish
14-Oct-15 13:55pm
View
do you know about large footprint of SQL Server ? if you know then you got why i am migrating from
Malikdanish
14-Oct-15 12:16pm
View
I agree with you AnvilRanger , I just want to ask if some one saying me to convert a SQL server database to Advantage Database server (sybase/SAP) does it require lot of work or with using the script i can gerenate the objects like table,views,stored procedure or the syntax is different between these two also in code behind do i need lot or effort or a small effort will do the job..Please assists
Malikdanish
14-Oct-15 12:08pm
View
thanks
Malikdanish
14-Oct-15 12:07pm
View
its open ended question lolx thanks for participation
Malikdanish
14-Oct-15 11:54am
View
Dear it exists and it is up and running http://devzone.advantagedatabase.com/dz/content.aspx?key=1
Malikdanish
14-Oct-15 11:54am
View
I just want to go with Advantage database server
Malikdanish
8-Sep-15 3:10am
View
they have there direct relation in their own table , this table is secondary table and the district and village id is foreign key here and primary key in their own table
Malikdanish
31-Aug-15 0:59am
View
I already told you that against one target i may have 100 replies so how can i combine these two into a single table , secondly if i combine them into a single table the if I have 100 achieved values against one target value then i will duplicate this target values 100 times so data redundancy get lost.
Malikdanish
30-Aug-15 0:12am
View
There is one questionTarget and for this questionTarget there are many Answers that is the rule so
see the picture
calculate the sum of QuestionTarget column from QuestionTarget table and calculate the sum of QTotal Column from the AnswersNew table see the picture for tables data
link of picture is http://tinypic.com/r/2cxys2f/8
Malikdanish
29-Aug-15 15:47pm
View
check the link for Relationship , this gives incorrect record set may be due to the reason for one row of question target table i have many rows in answersnew table
http://tinypic.com/r/206iipv/8
Malikdanish
26-Aug-15 12:32pm
View
http://tinypic.com/r/33ve06p/8 access this share your email if u can
Malikdanish
26-Aug-15 11:20am
View
Thanks for giving a new information :) i will try to signup over there and will back to you if i require assistance THanks again
Malikdanish
26-Aug-15 11:15am
View
andy Lanng I am checking it thanks for the time you put on it .. here is no option to attach an image if i have an email of you then i can send you the pictures
Malikdanish
26-Aug-15 11:10am
View
my Dear my requirments still remains as previously they was i made it simpler due to understanding purposes
Malikdanish
26-Aug-15 9:15am
View
i am making it simple for you so i am writing now the whole story , Basically I have four tables
1-Question(QuestionID(P),QuestionText)
2-QuestionTarget(RecordID(P),Question_ID(F),QuestionTarget(int))
3-AnswersNew(ID(P),Question_ID(F),QTotal,VlgID(F))
4-Villages(VlgID(P),VillageName)
The issue was raised when I want to get the sum of column QuestionTarget(from Question table ) and the sum of QTotal (from the AnswersNew Table I have no primary foreign key relation ship between these two table , both having forign keys of Question_ID from Question Table so I want to get data from both of them like i want to calculate the sum of questionTarget(is column) from QuestionTarget table and sum of QTotal from AnswersNew table , when i was using inner join it gives me wrong result set so i have from a friend who made that subqueries to solve the issue "
SELECT SUM(Target) Target , Sum(Achieved) Achieved FROM
(SELECT Sum(Achieved) AS Achieved , SUM(DISTINCT( Target)) AS Target FROM AnswersNew1 AS S
RIGHT OUTER Join
(SELECT Question_ID , Sum(TargetValue) AS "Target" FROM QuestionTarget1
GROUP BY Question_ID )CTE
ON
CTE.Question_ID=S.Question_ID
GROUP BY CTE.Question_ID)Cte1"
Now you are just requested that my above query return two columns target and achieved you are required to join my fourth table named villages and then in my select also show the village name thats all
Malikdanish
26-Aug-15 7:41am
View
Dear it is understood that when i am joining Tables like INNER JOIN Villages ON V.VlgID=AN.VillageID then it is understood that there is a village table and in it there is a villageId The tables and there column semantic are correct i just want to merge these two queries into a single query ,If you want to see the full table description then give me the email so that i can give you the whole script of my db
Malikdanish
26-Aug-15 5:45am
View
Andy Listen to me now
I have two queries both are accessing the same base tables (questionTarget,AnswersNew) below is the query which was written to get the Two Columns (Target,Achieved) now I need other columns too for that i HAve that below query I want to make a single query from these two queries to return a signle result set containing all columns
First Query:SELECT SUM(Target) Target , Sum(Achieved) Achieved FROM
(SELECT Sum(QTotal) AS Achieved , SUM(DISTINCT(Target)) AS Target FROM AnswersNew AS S
RIGHT OUTER Join
(SELECT Question_ID , Sum(QuestionTarget) AS "Target" FROM QuestionTarget
GROUP BY Question_ID )CTE
ON
CTE.Question_ID=S.Question_ID
GROUP BY CTE.Question_ID)Cte1
Second Query:"SELECT
QT.Question_ID,
Q.QuestionText,AN.QTotal As Achieved,
QT.QT_ForWomen AS TW,
AN.id,
QT.QT_FormMen AS TM,
AN.QT_ForMen AS AM,
AN.QT_ForWomen AS AW,
QT.QT_ForGirl AS TG,
AN.QT_ForGirl AS AG,
QT.QT_ForBoy AS TB,
AN.QT_ForBoy AS AB,
V.VillageName,
AN.CdfPErsonName,
QT.District,AN.Year,
AN.Quarter,D.DistrictName,
QU.Quarter_Name,
CC.CommunityCodeName,
G.Group_Name,
Y.Year_Name,
AN.Date_Created,
AN.UserTypes,
AN.AnswerID,
U.IsActive,
AN.Status
from AnswersNew AN
INNER JOIN QuestionTarget QT
ON QT.Question_ID= AN.Question_ID
AND QT.Year=AN.Year
AND QT.Quarter=AN.Quarter
AND AN.DistrictId=QT.District
INNER JOIN Villages V ON V.VlgID=AN.VillagesId
INNER JOIN Quarter Qu ON Qu.Quarter_ID=AN.Quarter
INNER JOIN Users U ON U.UserId=AN.CDF_ID
INNER JOIN Questions Q ON Q.QuestionIds=QT.Question_ID
INNER JOIN CommunityCodes CC ON CC.CommunityCodeID =AN.CommunityCodes
INNER JOIN Groups G ON G.Group_ID=AN.UserTypes
INNER JOIN Year Y ON Y.YEAR_ID=AN.Year
INNER JOIN Districts D on D.DistrictId=U.DistrictId
WHERE U.IsVisible = 1"
The Tables N relationship are mentioned in query make a one query like stored procedure which can show the whole result set all required columns in both select queries
Malikdanish
25-Aug-15 12:45pm
View
Thanks Andy
Malikdanish
25-Aug-15 12:25pm
View
ok Thanks I can
Malikdanish
25-Aug-15 12:14pm
View
The question is super easy . as above I have two queries both are using same tables I want to make a single query returning the result (combination of one and two) means return all result set of select command
Malikdanish
25-Aug-15 12:14pm
View
The question is super easy . as above I have two queries both are using same tables I want to make a single query returning the result (combination of one and two) means return all result set of select command
Malikdanish
25-Aug-15 12:14pm
View
The question is super easy . as above I have two queries both are using same tables I want to make a single query returning the result (combination of one and two) means return all result set of select command
Malikdanish
25-Aug-15 12:10pm
View
Your modification Returns wrong result..
Malikdanish
25-Aug-15 10:46am
View
check the query both first and second i want to make a single one query i have nested select statements , I want to make them a one query with results
Malikdanish
16-Apr-15 3:16am
View
Dear Sir, first and for most important thing that (association with District, Tehsils, Villages ) these have rules
mean that a user can have one or many district
A user can have one or many tehsils
A user can have one or many Villages
so I have 1000 of Users and approximately one user belongs to 200 Villages so 1000*200 = ?? so while getting the village ID it become too slow that Is why I am separating the User basic information like id and name into a separate table and their other information like District,Tehsil,Villages into an other table ....
Malikdanish
15-Apr-15 8:54am
View
simply i am using four table value paramter for insertion and process get too slow to insert the record
Malikdanish
2-Feb-15 2:50am
View
Dear I Got What you have assist me , The problem is that i am new to programming and Development IF I made a singel table to manage the regions then how i Associate each user to the combination of these four entities mean (district,TEhsil,UC,Villages) For example Consider the following case
I have one district ,3 Tehsils,90 UCs,200 Villages and there not certain rules of association mean that a user can be assigned one district , 3 tehsil,4 ucs,and then the associated villages(any number of these villages) .
Now i am saving the records but the problem comes in editing on edit i have 200 rows and the datareader goes row by row for example if first IT first loop through the District and then pass this district id to Tehsil Method and populates tehsils and then find the selcted tehsil and pass this tehsil to UC method and then find the selected uc and pass this uc id to villages method to pupulates and then select the selected villages so if i have 200 Rowss commming then while loop iterate 200 times so i think it times out on edit and make the process slow , do u have any example for reference then share please
Malikdanish
2-Feb-15 1:21am
View
SQL SERVER 2008 R2
Show More