Exemple #1
0
        public ActionResult Create(SAL02_Contacts modelContact, string submitCustomertoAppointment, string submitCustomer, string submitCustomerToProject)
        {
            try
            {
                ModelState.Remove("SalContId");
                if (!modelContact.EmailExists)
                {
                    modelContact.SalContEmail = BusinessConstants.NA;
                    ModelState.Remove("SalContEmail");
                }
                if (ModelState.IsValid)
                {
                    modelContact.SalContPhone  = DataAccess.Entity.Common.FormatPhoneText(modelContact.SalContPhone);
                    modelContact.SalContMobile = DataAccess.Entity.Common.FormatPhoneText(modelContact.SalContMobile);
                    modelContact.SalContFax    = DataAccess.Entity.Common.FormatPhoneText(modelContact.SalContFax);
                    var result = CustomerDAL.saveCustomer(modelContact);
                    if (result > 0)
                    {
                        Session["ContID"] = "";
                        Session.Remove("ContID");
                        if (submitCustomertoAppointment != null)
                        {
                            return(RedirectToAction("create", "appointments", new { id = result, assign = "1" }));
                        }
                        else if (submitCustomerToProject != null && submitCustomerToProject == "save")
                        {
                            return(RedirectToAction("index", "project"));
                        }
                        else if (submitCustomer != null)
                        {
                            return(RedirectToAction("index", "customers"));
                        }
                    }
                    else
                    {
                        ModelState.AddModelError(String.Empty, BusinessConstants.duplicateRecord);
                        LoadCombos();
                        ViewBag.Title = string.IsNullOrWhiteSpace(Convert.ToString(modelContact.SalContId)) ?
                                        BusinessConstants.titleNewCustomer : BusinessConstants.titleEditCustomer;
                        return(View(modelContact));
                    }
                }

                LoadCombos();
                ViewBag.Title = string.IsNullOrWhiteSpace(Convert.ToString(modelContact.SalContId)) ?
                                BusinessConstants.titleNewCustomer : BusinessConstants.titleEditCustomer;
                return(View());
            }
            catch (Exception ex)
            {
                ModelState.AddModelError(String.Empty, ex.Message + BusinessConstants.contactAdmin);
                LoadCombos();
                ViewBag.Title = string.IsNullOrWhiteSpace(Convert.ToString(modelContact.SalContId)) ?
                                BusinessConstants.titleNewCustomer : BusinessConstants.titleEditCustomer;
                return(View());
            }
        }
Exemple #2
0
        public static int saveCustomer(SAL02_Contacts modelContact)
        {
            int result = 0;

            try
            {
                string spName = string.Empty;
                List <SqlParameter> parametersList = new List <SqlParameter>();
                if (modelContact.SalContId > 0)
                {
                    parametersList.Add(new SqlParameter("@ContId", modelContact.SalContId));
                    spName = "spATL_CRM_Cont_Upd";
                }
                else
                {
                    spName = "spATL_CRM_Cont_Ins";
                }

                parametersList.Add(new SqlParameter("@CompId", modelContact.SalCompId));
                parametersList.Add(new SqlParameter("@FName", modelContact.SalContFirstName));
                parametersList.Add(new SqlParameter("@LName", modelContact.SalContLastName));
                parametersList.Add(new SqlParameter("@Address", modelContact.SalContAddress));
                parametersList.Add(new SqlParameter("@City", modelContact.SalContCity));
                parametersList.Add(new SqlParameter("@State", modelContact.SalContState));
                parametersList.Add(new SqlParameter("@ZipCode", modelContact.SalContZip));
                parametersList.Add(new SqlParameter("@Phone", modelContact.SalContPhone));
                parametersList.Add(new SqlParameter("@Ext", modelContact.SalContPhoneExt));
                parametersList.Add(new SqlParameter("@Fax", modelContact.SalContFax));
                parametersList.Add(new SqlParameter("@Mobile", modelContact.SalContMobile));
                parametersList.Add(new SqlParameter("@EMail", modelContact.SalContEmail));
                parametersList.Add(new SqlParameter("@ActiveFlag", modelContact.SalContActiveFlag));
                parametersList.Add(new SqlParameter("@LedSource", modelContact.LedSourceId));

                DataTable resultSet = (SqlHelper.ExecuteDataset(_myConnection, CommandType.StoredProcedure,
                                                                spName, parametersList.ToArray()).Tables[0]);

                result = Convert.ToInt32(resultSet.Rows[0]["ID"]);
            }
            catch (Exception ex)
            {
            }
            return(result);
        }
Exemple #3
0
        public static List <SAL02_Contacts> getCustomerCollection(dynamic dataSet)
        {
            List <SAL02_Contacts> lstContacts = new List <SAL02_Contacts>();

            foreach (var record in dataSet)
            {
                SAL02_Contacts contacts = new SAL02_Contacts();
                if (!record["SalContId"].Equals(DBNull.Value))
                {
                    contacts.SalContId = Convert.ToInt32(record["SalContId"]);
                }
                if (!record["SalContFirstName"].Equals(DBNull.Value))
                {
                    contacts.SalContFirstName = Common.ToTitleCase(Convert.ToString(record["SalContFirstName"]));
                }
                if (!record["SalContLastName"].Equals(DBNull.Value))
                {
                    contacts.SalContLastName = Common.ToTitleCase(Convert.ToString(record["SalContLastName"]));
                }
                if (!record["SalContAddress"].Equals(DBNull.Value))
                {
                    contacts.SalContAddress = Convert.ToString(record["SalContAddress"]);
                }
                if (!record["SalContCity"].Equals(DBNull.Value))
                {
                    contacts.SalContCity = Convert.ToString(record["SalContCity"]);
                }
                if (!record["SalContState"].Equals(DBNull.Value))
                {
                    contacts.SalContState = Convert.ToString(record["SalContState"]);
                }
                if (!record["SalContZip"].Equals(DBNull.Value))
                {
                    contacts.SalContZip = Convert.ToString(record["SalContZip"]);
                }
                if (record.Table.Columns.Contains("SalContPhone") && !record["SalContPhone"].Equals(DBNull.Value))
                {
                    contacts.SalContPhone = Convert.ToString(record["SalContPhone"]);
                }
                if (record.Table.Columns.Contains("SalContPhoneExt") && !record["SalContPhoneExt"].Equals(DBNull.Value))
                {
                    contacts.SalContPhoneExt = Convert.ToString(record["SalContPhoneExt"]);
                }
                if (record.Table.Columns.Contains("SalContFax") && !record["SalContFax"].Equals(DBNull.Value))
                {
                    contacts.SalContFax = Convert.ToString(record["SalContFax"]);
                }
                if (record.Table.Columns.Contains("SalContMobile") && !record["SalContMobile"].Equals(DBNull.Value))
                {
                    contacts.SalContMobile = Convert.ToString(record["SalContMobile"]);
                }
                if (record.Table.Columns.Contains("SalContEmail") && !record["SalContEmail"].Equals(DBNull.Value))
                {
                    contacts.SalContEmail = Convert.ToString(record["SalContEmail"]);
                }
                if (record.Table.Columns.Contains("SalCompId") && !record["SalCompId"].Equals(DBNull.Value))
                {
                    contacts.SalCompId = Convert.ToString(record["SalCompId"]);
                }
                if (record.Table.Columns.Contains("SalContActiveFlag") && !record["SalContActiveFlag"].Equals(DBNull.Value))
                {
                    contacts.SalContActiveFlag = Convert.ToString(record["SalContActiveFlag"]);
                }
                if (record.Table.Columns.Contains("LedSourceId") && !record["LedSourceId"].Equals(DBNull.Value))
                {
                    contacts.LedSourceId = Convert.ToInt32(record["LedSourceId"]);
                }
                lstContacts.Add(contacts);
            }

            return(lstContacts);
        }