Comments by Malikdanish

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

Malikdanish 2-Feb-17 13:35pm View

Dear check the above code pls

Malikdanish 2-Feb-17 13:33pm View

Deleted

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

Comments by Malikdanish (Top 159 by date)

Index

Index

TheTexting SMS GateWay Demo