public int AddCompany(tbl_CompanyMaster objCompanyMaster)
{
try
{
isExist = 0;
dtRecords = new DataTable();
objSKSEntities = new SKSEntities();
isExist = (from CompanyMaster in objSKSEntities.tbl_CompanyMaster where (CompanyMaster.Name == objCompanyMaster.Name && CompanyMaster.IsDeleted == false) select CompanyMaster.Id).SingleOrDefault();;
if (isExist > 0)
{
return(isExist);
}
else
{
objSKSEntities.tbl_CompanyMaster.Add(objCompanyMaster);
objSKSEntities.SaveChanges();
return(isExist);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dtRecords.Dispose();
}
}
public static string AddCompany(string CompanyName, string CompanyShortName, string CompanyContactPersonName, string CompanyContactPersonMobileNo, string ContactPersonEmailID, string CompanyWebsiteURL, bool Status)
{
// string result = "CompanyName=" + CompanyName + "CompanyShortName=" + CompanyShortName + "CompanyContactPersonName=" + CompanyContactPersonName + "CompanyContactPersonMobileNo=" + CompanyContactPersonMobileNo + "CompanyWebsiteURL=" + CompanyWebsiteURL + "Status=" + Status;
try
{
if (CompanyName.Trim() == "")
{
return("false|Enter Company Name");
}
objBusinessFacadLayer_Static = new BusinessFacadLayer();
objCompanyMaster_Static = new tbl_CompanyMaster();
objCompanyMaster_Static.Name = CompanyName;
objCompanyMaster_Static.CompanyShortKey = CompanyShortName;
objCompanyMaster_Static.ContactPersonName = CompanyContactPersonName;
objCompanyMaster_Static.BusinessWebsite = CompanyWebsiteURL;
objCompanyMaster_Static.MobileNo = CompanyContactPersonMobileNo;
objCompanyMaster_Static.Email = ContactPersonEmailID;
objCompanyMaster_Static.IsActive = Status;
objCompanyMaster_Static.IsDeleted = false;
objCompanyMaster_Static.CreatedBy = "Admin";
objCompanyMaster_Static.CreatedOn = Convert.ToDateTime(DateTime.Now.ToString());
isExist = objBusinessFacadLayer_Static.AddCompany(objCompanyMaster_Static);
if (isExist > 0)
{
return("failed|Company -" + CompanyName + ", already exist");
}
else
{
return("success|New Company -" + CompanyName + ", added successfully");
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
public void DeleteorEnableDisableCompany(int CompanyID, bool blnTrueFalse, bool blnDelete)
{
try
{
objSKSEntities = new SKSEntities();
objCompanyMaster = objSKSEntities.tbl_CompanyMaster.SingleOrDefault(x => x.Id == CompanyID); //returns a single item.
if (objCompanyMaster != null)
{
objCompanyMaster.IsActive = blnTrueFalse;
objCompanyMaster.IsDeleted = blnDelete;
objSKSEntities.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objSKSEntities = null;
}
}
