private void SetViewBagForCombos(SAL03_ResAppointments appointments)
{
ViewBag.StartTime = AppointmentsDAL.getComboLookupValue("Setup40_Time", "Setup40TimeID", "Setup40Time", appointments.SalApptStartTime);
ViewBag.EndTime = AppointmentsDAL.getComboLookupValue("Setup40_Time", "Setup40TimeID", "Setup40Time", appointments.SalApptEndTime);
ViewBag.FenceType = AppointmentsDAL.getComboLookupValue("Setup25_FenceTypes", "FenceTypeID", "FenceType", Convert.ToString(appointments.FenceTypeID));
ViewBag.SalesType = AppointmentsDAL.getComboLookupValue("SAL10_SalesTypes", "SalTypeId", "SalType", Convert.ToString(appointments.SalTypeId));
}
public ActionResult Create(SAL03_ResAppointments modelAppt)
{
try
{
ModelState.Remove("SalApptId");
if (!modelAppt.EmailExists)
{
modelAppt.SalApptEmail = BusinessConstants.NA;
ModelState.Remove("SalApptEmail");
}
if (ModelState.IsValid)
{
modelAppt.SalApptUserEntered = User.Identity.Name;
if (AppointmentsDAL.SaveAppointment(modelAppt))
{
return(RedirectToAction("index", "calendar"));
}
else
{
LoadAppointmentCombos();
ModelState.AddModelError(String.Empty, BusinessConstants.duplicateRecord);
return(View(modelAppt));
}
}
else
{
LoadAppointmentCombos();
ModelState.AddModelError(String.Empty, BusinessConstants.ValidateEntries);
return(View(modelAppt));
}
}
catch (Exception ex)
{
LoadAppointmentCombos();
ModelState.AddModelError(String.Empty, BusinessConstants.contactAdmin);
return(View(modelAppt));
}
}
//
// GET: /Appointment/Create
public ActionResult Create(string id = "", string assign = "0")
{
LoadAppointmentCombos();
id = string.IsNullOrWhiteSpace(id) ? "0" : Convert.ToString(id);
int ApptId = int.Parse(id);
if (ApptId == 0 || assign.Equals("1"))
{
ViewBag.Title = BusinessConstants.titleNewAppointments;
var Appointment = new SAL03_ResAppointments();
Appointment.SalApptStartDate = DateTime.Now.ToShortDateString();
Appointment.SalApptEndDate = DateTime.Now.ToShortDateString();
return(View(Appointment));
}
else
{
var Appointment = AppointmentsDAL.getEditAppointment(ApptId);
ViewBag.Title = BusinessConstants.titleEditAppointments;
Appointment.SalApptStartDate = Convert.ToDateTime(Appointment.SalApptStartDate).ToShortDateString();
Appointment.SalApptEndDate = Convert.ToDateTime(Appointment.SalApptStartDate).ToShortDateString();
if (String.IsNullOrWhiteSpace(Appointment.SalApptEmail) ||
Appointment.SalApptEmail.Equals(BusinessConstants.NA))
{
Appointment.SalApptEmail = string.Empty;
Appointment.EmailExists = false;
}
else
{
Appointment.EmailExists = true;
}
return(View(Appointment));
}
}
private static List <SAL03_ResAppointments> getAppointmentsCollection(dynamic dataSet)
{
List <SAL03_ResAppointments> lstAppointment = new List <SAL03_ResAppointments>();
foreach (var record in dataSet)
{
SAL03_ResAppointments appointment = new SAL03_ResAppointments();
if (!record["SalApptId"].Equals(DBNull.Value))
{
appointment.SalApptId = Convert.ToInt32(record["SalApptId"]);
}
if (!record["SalContId"].Equals(DBNull.Value))
{
appointment.SalContId = Convert.ToInt32(record["SalContId"]);
}
if (!record["SalApptFirstName"].Equals(DBNull.Value))
{
appointment.SalApptFirstName = Common.ToTitleCase(Convert.ToString(record["SalApptFirstName"]));
}
if (!record["SalApptLastName"].Equals(DBNull.Value))
{
appointment.SalApptLastName = Common.ToTitleCase(Convert.ToString(record["SalApptLastName"]));
}
if (!record["SalApptAddress"].Equals(DBNull.Value))
{
appointment.SalApptAddress = Convert.ToString(record["SalApptAddress"]);
}
if (!record["SalApptCity"].Equals(DBNull.Value))
{
appointment.SalApptCity = Convert.ToString(record["SalApptCity"]);
}
if (!record["SalApptState"].Equals(DBNull.Value))
{
appointment.SalApptState = Convert.ToString(record["SalApptState"]);
}
if (!record["SalApptZip"].Equals(DBNull.Value))
{
appointment.SalApptZip = Convert.ToString(record["SalApptZip"]);
}
if (record.Table.Columns.Contains("SalApptPhone") && !record["SalApptPhone"].Equals(DBNull.Value))
{
appointment.SalApptPhone = Convert.ToString(record["SalApptPhone"]);
}
if (record.Table.Columns.Contains("SalApptPhoneExt") && !record["SalApptPhoneExt"].Equals(DBNull.Value))
{
appointment.SalApptPhoneExt = Convert.ToString(record["SalApptPhoneExt"]);
}
if (record.Table.Columns.Contains("SalApptFax") && !record["SalApptFax"].Equals(DBNull.Value))
{
appointment.SalApptFax = Convert.ToString(record["SalApptFax"]);
}
if (record.Table.Columns.Contains("SalApptMobile") && !record["SalApptMobile"].Equals(DBNull.Value))
{
appointment.SalApptMobile = Convert.ToString(record["SalApptMobile"]);
}
if (record.Table.Columns.Contains("SalApptEmail") && !record["SalApptEmail"].Equals(DBNull.Value))
{
appointment.SalApptEmail = Convert.ToString(record["SalApptEmail"]);
}
if (record.Table.Columns.Contains("SalApptStartDate") && !record["SalApptStartDate"].Equals(DBNull.Value))
{
appointment.SalApptStartDate = Convert.ToString(record["SalApptStartDate"]);
}
if (record.Table.Columns.Contains("SalApptStartTime") && !record["SalApptStartTime"].Equals(DBNull.Value))
{
appointment.SalApptStartTime = Convert.ToString(record["SalApptStartTime"]);
}
if (record.Table.Columns.Contains("SalApptEndDate") && !record["SalApptEndDate"].Equals(DBNull.Value))
{
appointment.SalApptEndDate = Convert.ToString(record["SalApptEndDate"]);
}
if (record.Table.Columns.Contains("SalApptEndTime") && !record["SalApptEndTime"].Equals(DBNull.Value))
{
appointment.SalApptEndTime = Convert.ToString(record["SalApptEndTime"]);
}
if (record.Table.Columns.Contains("FenceTypeID") && !record["FenceTypeID"].Equals(DBNull.Value))
{
appointment.FenceTypeID = Convert.ToInt32(record["FenceTypeID"]);
}
if (record.Table.Columns.Contains("CommID") && !record["CommID"].Equals(DBNull.Value))
{
appointment.CommID = Convert.ToString(record["CommID"]);
}
if (record.Table.Columns.Contains("SalTypeId") && !record["SalTypeId"].Equals(DBNull.Value))
{
appointment.SalTypeId = Convert.ToInt32(record["SalTypeId"]);
}
if (record.Table.Columns.Contains("Notes") && !record["Notes"].Equals(DBNull.Value))
{
appointment.Notes = Convert.ToString(record["Notes"]);
}
if (record.Table.Columns.Contains("SalApptUserEntered") && !record["SalApptUserEntered"].Equals(DBNull.Value))
{
appointment.SalApptUserEntered = Convert.ToString(record["SalApptUserEntered"]);
}
lstAppointment.Add(appointment);
}
return(lstAppointment);
}
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);
}
