public ActionResult saveJobSiteDetails(PRJ01_Headers JobDetails) { JobDetails.CommID = (string)Session["CommID"]; var result = ProjectDAL.saveJobStatus(JobDetails); if (result > 0) { Session["PRJID"] = result; Session["JobStatusId"] = JobDetails.JobStatusId; } return(Json(result)); }
public static CustomerProfileViewModel getCustomerProfile(int id) { DataSet dataSet = SqlHelper.ExecuteDataset(_myConnection, CommandType.StoredProcedure, "spATL_CRM_Cont_Profile", new SqlParameter("@ContId", id)); CustomerProfileViewModel profile = new CustomerProfileViewModel(); if (dataSet.Tables.Count > 0) { if (dataSet.Tables[0].Rows.Count > 0) { var contact = dataSet.Tables[0].Rows; profile.sal02_Contact = new SAL02_Contacts(); profile.sal02_Contact.SalContId = Convert.ToInt32(contact[0]["SalContId"]); profile.sal02_Contact.SalContFirstName = Common.ToTitleCase(contact[0]["SalContFirstName"].FormatTrim()); profile.sal02_Contact.SalContLastName = Common.ToTitleCase(contact[0]["SalContLastName"].FormatTrim()); profile.sal02_Contact.SalContAddress = contact[0]["SalContAddress"].FormatTrim(); profile.sal02_Contact.SalContCity = contact[0]["SalContCity"].FormatTrim(); profile.sal02_Contact.SalContState = contact[0]["SalContState"].FormatTrim(); profile.sal02_Contact.SalContZip = contact[0]["SalContZip"].FormatTrim(); profile.sal02_Contact.SalContPhone = contact[0]["SalContPhone"].FormatTrim(); profile.sal02_Contact.SalContPhoneExt = contact[0]["SalContPhoneExt"].FormatTrim(); profile.sal02_Contact.SalContFax = contact[0]["SalContFax"].FormatTrim(); profile.sal02_Contact.SalContMobile = contact[0]["SalContMobile"].FormatTrim(); profile.sal02_Contact.SalContEmail = contact[0]["SalContEmail"].FormatTrim(); profile.sal02_Contact.SalContActiveFlag = contact[0]["SalContActiveFlag"].FormatTrim() == "Y" ? "Yes" : "No"; profile.sal02_Contact.SAL01_Company = new SAL01_Company(); profile.sal02_Contact.SAL01_Company.SalCompName = contact[0]["SalCompName"].FormatTrim(); profile.sal02_Contact.PRJ06_LedSource = new PRJ06_LedSource(); profile.sal02_Contact.PRJ06_LedSource.LedSourceName = contact[0]["LedSourceName"].FormatTrim(); if (contact[0]["SalContDateCreated"] != DBNull.Value) { profile.sal02_Contact.SalContDateCreated = Convert.ToDateTime(contact[0]["SalContDateCreated"]); } } profile.sal03_ResAppointments = new List <SAL03_ResAppointments>(); if (dataSet.Tables[1].Rows.Count > 0) { var schedule = dataSet.Tables[1].Rows; for (int i = 0; i < schedule.Count; i++) { SAL03_ResAppointments objResAppointments = new SAL03_ResAppointments(); if (schedule[i]["SalApptStartDate"] != DBNull.Value) { objResAppointments.SalApptStartDate = schedule[i]["SalApptStartDate"].FormatTrim(); } if (schedule[i]["SalApptStartTime"] != DBNull.Value) { objResAppointments.SalApptStartTime = AppointmentsDAL.getComboLookupValue("Setup40_Time", "Setup40TimeID", "Setup40Time", (schedule[i]["SalApptStartTime"]).FormatTrim()); } profile.sal03_ResAppointments.Add(objResAppointments); } } profile.prj01_Headers = new List <PRJ01_Headers>(); if (dataSet.Tables[2].Rows.Count > 0) { var projects = dataSet.Tables[2].Rows; for (int i = 0; i < projects.Count; i++) { PRJ01_Headers objProjetcs = new PRJ01_Headers(); objProjetcs.PRJID = Convert.ToInt32(projects[i]["PRJID"]); if (projects[i]["PRJDateActivated"] != DBNull.Value) { objProjetcs.PRJDateActivated = Convert.ToDateTime(projects[i]["PRJDateActivated"]); } objProjetcs.CommID = projects[i]["CommID"].FormatTrim(); objProjetcs.JobNumber = projects[i]["JobNumber"].FormatTrim(); objProjetcs.ProjectName = projects[i]["ProjectName"].FormatTrim(); objProjetcs.JobStatusId = projects[i]["JobStatusId"].FormatTrim(); objProjetcs.PRJNotes = projects[i]["PRJNotes"].FormatTrim(); profile.prj01_Headers.Add(objProjetcs); } } profile.projectNotes = new List <Notes>(); if (dataSet.Tables[3].Rows.Count > 0) { var notes = dataSet.Tables[3].Rows; for (int i = 0; i < notes.Count; i++) { Notes objNotes = new Notes(); if (notes[i]["PRJDateEntered"] != DBNull.Value) { objNotes.PRJDateEntered = Convert.ToDateTime(notes[i]["PRJDateEntered"]); } objNotes.PRJNotes = notes[i]["PRJNotes"].FormatTrim(); profile.projectNotes.Add(objNotes); } } } return(profile); }