public static List <SAL01_Company> getAllCompanies()
{
var dataSet = SqlHelper.ExecuteDataset(_myConnection, CommandType.Text, "Select * from SAL01_Company order by SalCompName")
.Tables[0].AsEnumerable().ToList();
List <SAL01_Company> lstCompanies = new List <SAL01_Company>();
foreach (var record in dataSet)
{
SAL01_Company company = new SAL01_Company();
company.SalCompId = Convert.ToString(record["SalCompId"]);
company.SalCompName = Convert.ToString(record["SalCompName"]);
company.SalCompAddress = Convert.ToString(record["SalCompAddress"]);
company.SalCompState = Convert.ToString(record["SalCompState"]);
company.SalCompCity = Convert.ToString(record["SalCompCity"]);
company.SalCompZip = Convert.ToString(record["SalCompZip"]);
company.SalCompPhone = Convert.ToString(record["SalCompPhone"]);
company.SalCompPhoneExt = Convert.ToString(record["SalCompPhoneExt"]);
company.SalCompFax = Convert.ToString(record["SalCompFax"]);
company.SalCompMobile = Convert.ToString(record["SalCompMobile"]);
company.SalCompEMail = Convert.ToString(record["SalCompEMail"]);
company.SalCompActiveFlag = Convert.ToBoolean(record["SalCompActiveFlag"]);
lstCompanies.Add(company);
}
return(lstCompanies);
}
public static DataTable SaveNewCompany(SAL01_Company modelCompany)
{
DataTable data = new DataTable();
try
{
var sqlParamsList = new List <SqlParameter>();
if (!string.IsNullOrWhiteSpace(modelCompany.SalCompId))
{
sqlParamsList.Add(new SqlParameter("@CompId", modelCompany.SalCompId));
}
sqlParamsList.Add(new SqlParameter("@Company", modelCompany.SalCompName));
sqlParamsList.Add(new SqlParameter("@Address", modelCompany.SalCompAddress));
sqlParamsList.Add(new SqlParameter("@City", modelCompany.SalCompCity));
sqlParamsList.Add(new SqlParameter("@State", modelCompany.SalCompState));
sqlParamsList.Add(new SqlParameter("@Zip", modelCompany.SalCompZip));
sqlParamsList.Add(new SqlParameter("@Phone", modelCompany.SalCompPhone));
sqlParamsList.Add(new SqlParameter("@Ext", modelCompany.SalCompPhoneExt));
sqlParamsList.Add(new SqlParameter("@Fax", modelCompany.SalCompFax));
sqlParamsList.Add(new SqlParameter("@Mobile", modelCompany.SalCompMobile));
sqlParamsList.Add(new SqlParameter("@EMail", modelCompany.SalCompEMail));
sqlParamsList.Add(new SqlParameter("@DateEntered", DateTime.Now));
sqlParamsList.Add(new SqlParameter("@ActiveFlag", modelCompany.SalCompActiveFlag.Value));
data = SqlHelper.ExecuteDataset(_myConnection, CommandType.StoredProcedure, "spATL_CRM_Comp_Ins", sqlParamsList.ToArray()).Tables[0];
}
catch (Exception e)
{
}
return(data);
}
public ActionResult getCompanyAddressDetails(string companyId)
{
SAL01_Company company = new SAL01_Company();
if (!string.IsNullOrWhiteSpace(companyId))
{
company = ProjectDAL.getCompanyAddressDetails(companyId);
}
return(Json(company));
}
public ActionResult Create(SAL01_Company modelCompany, string submitCompany)
{
try
{
if (!modelCompany.EmailExists)
{
modelCompany.SalCompEMail = BusinessConstants.NA;
ModelState.Remove("SalCompEMail");
}
if (ModelState.IsValid)
{
modelCompany.SalCompPhone = DataAccess.Entity.Common.FormatPhoneText(modelCompany.SalCompPhone);
modelCompany.SalCompMobile = DataAccess.Entity.Common.FormatPhoneText(modelCompany.SalCompMobile);
modelCompany.SalCompFax = DataAccess.Entity.Common.FormatPhoneText(modelCompany.SalCompFax);
DataTable data = CompanyDAL.SaveNewCompany(modelCompany);
if (data.Rows.Count > 0)
{
ViewBag.SavedCompID = data;
return(RedirectToAction("create", "customers", new { @compId = data.Rows[0]["CompanyId"] }));
}
else
{
LoadCompanyDetails();
ModelState.AddModelError(String.Empty, BusinessConstants.duplicateRecord);
return(View(modelCompany));
}
}
else
{
LoadCompanyDetails();
ModelState.AddModelError(String.Empty, BusinessConstants.contactAdmin);
return(View(modelCompany));
}
}
catch (Exception ex)
{
LoadCompanyDetails();
ModelState.AddModelError(String.Empty, BusinessConstants.contactAdmin);
return(View(modelCompany));
}
}