public ActionResult SaveCompany(TBL_COMPANY company)
{
if (ModelState.IsValid)
{
try
{
if (!companyService.IsCompanyExist(company))
{
company.CREATED_DATE = DateTime.Now;
company.UPDATE_USER = User.Identity.GetUserId();
companyService.CreateCompany(company);
companyService.SaveCompany();
}
else
{
ViewData["EditableProduct"] = company;
ViewData["EditError"] = "Name is already taken";
}
}
catch (Exception e)
{
ViewData["EditError"] = e.Message;
}
}
else
{
ViewData["EditError"] = "Please, correct all errors.";
ViewData["EditableProduct"] = company;
}
return(PartialView("GridCompanyPartial"));
}
public void DeleteCompany(int companyId, string userId)
{
TBL_COMPANY comp = companyRepository.GetById(companyId);
comp.UPDATE_USER = userId;
comp.IS_DELETED = true;
companyRepository.Update(comp);
}
public ActionResult UpdateCompany(TBL_COMPANY company)
{
if (ModelState.IsValid)
{
if (!companyService.IsCompanyExist(company))
{
companyService.UpdateCompany(company);
company.UPDATE_USER = User.Identity.GetUserId();
companyService.SaveCompany();
}
else
{
ViewData["EditableProduct"] = company;
ViewData["EditError"] = "Name is already taken";
}
}
else
{
ViewData["EditError"] = "Please, correct all errors.";
ViewData["EditableProduct"] = company;
}
return(PartialView("GridCompanyPartial"));
}
public void CreateCompany(TBL_COMPANY company)
{
companyRepository.Add(company);
}
public void UpdateCompany(TBL_COMPANY company)
{
companyRepository.Update(company);
}
public bool IsCompanyExist(TBL_COMPANY company)
{
return(companyRepository.Get(x => x.IS_DELETED == false && x.ID != company.ID && x.NAME.ToUpper() == company.NAME.ToUpper()) == null ? false : true);
}
public HttpResponseMessage CreateCompany(CompanyModel _CompanyModel)
{
int iUploadedCnt = 0;
try
{
bool conn = false;
conn = db.Database.Exists();
if (!conn)
{
ConnectionTools.changeToLocalDB(db);
conn = db.Database.Exists();
}
if (conn)
{
// DEFINE THE PATH WHERE WE WANT TO SAVE THE FILES.
string sPath = "";
sPath = System.Web.Hosting.HostingEnvironment.MapPath("~/Upload/");
System.Web.HttpFileCollection hfc = System.Web.HttpContext.Current.Request.Files;
// CHECK THE FILE COUNT.
for (int iCnt = 0; iCnt <= hfc.Count - 1; iCnt++)
{
System.Web.HttpPostedFile hpf = hfc[iCnt];
if (hpf.ContentLength > 0)
{
// CHECK IF THE SELECTED FILE(S) ALREADY EXISTS IN FOLDER. (AVOID DUPLICATE)
if (!File.Exists(sPath + Path.GetFileName(hpf.FileName)))
{
// SAVE THE FILES IN THE FOLDER.
hpf.SaveAs(sPath + Path.GetFileName(hpf.FileName));
iUploadedCnt = iUploadedCnt + 1;
}
}
}
TBL_COMPANY com = new TBL_COMPANY();
com.COMPANY_NAME = _CompanyModel.NAME;
com.SHOPNAME = _CompanyModel.SHOPNAME;
com.PREFIX = _CompanyModel.PREFIX;
com.PREFIX_NUM = _CompanyModel.PREFIX_NUM;
com.TIN_NUMBER = _CompanyModel.TIN_NUMBER;
com.ADDRESS_1 = _CompanyModel.ADDRESS_1;
com.ADDRESS_2 = _CompanyModel.ADDRESS_2;
com.CITY = _CompanyModel.CITY;
com.STATE = _CompanyModel.STATE;
com.COUNTRY = _CompanyModel.COUNTRY;
com.PIN = _CompanyModel.PIN;
com.PHONE_NUMBER = _CompanyModel.PHONE_NUMBER;
com.MOBILE_NUMBER = _CompanyModel.MOBILE_NUMBER;
com.EMAIL = _CompanyModel.EMAIL;
com.WEBSITE = _CompanyModel.WEBSITE;
com.DEFAULT_TAX_RATE = _CompanyModel.DEFAULT_TAX_RATE;
com.IS_WARNED_FOR_NEGATIVE_STOCK = _CompanyModel.IS_WARNED_FOR_NEGATIVE_STOCK;
com.IS_WARNED_FOR_LESS_SALES_PRICE = _CompanyModel.IS_WARNED_FOR_LESS_SALES_PRICE;
com.TAX_PRINTED_DESCRIPTION = _CompanyModel.TAX_PRINTED_DESCRIPTION;
com.FIRST_DAY_OF_FINANCIAL_YEAR = _CompanyModel.FIRST_DAY_OF_FINANCIAL_YEAR;
com.FIRST_MONTH_OF_FINANCIAL_YEAR = _CompanyModel.FIRST_MONTH_OF_FINANCIAL_YEAR;
com.IMAGE_PATH = _CompanyModel.IMAGE_PATH;
db.TBL_COMPANY.Add(com);
db.SaveChanges();
int ID = com.COMAPNY_ID;
TBL_BANK Bank = new TBL_BANK();
Bank.ADDRESS_1 = _CompanyModel.BANK_ADDRESS_1;
Bank.ADDRESS_2 = _CompanyModel.BANK_ADDRESS_2;
Bank.BANK_NAME = _CompanyModel.BANK_NAME;
Bank.CITY = _CompanyModel.BANK_CITY;
Bank.COMPANY_ID = ID;
Bank.BANK_CODE = _CompanyModel.BANK_CODE;
Bank.PIN_CODE = _CompanyModel.BANK_PIN_CODE;
Bank.PHONE_NUMBER = _CompanyModel.BANK_PHONE_NUMBER;
Bank.STATE = _CompanyModel.BANK_STATE;
db.TBL_BANK.Add(Bank);
db.SaveChanges();
long ba = Bank.BANK_ID;
TBL_BANK_ACCOUNT ac = new TBL_BANK_ACCOUNT();
ac.ACCOUNT_NUMBER = _CompanyModel.ACCOUNT_NUMBER;
ac.BRANCH_NAME = _CompanyModel.BRANCH_NAME;
ac.COMPANY_ID = ID;
ac.BANK_ID = ba;
ac.BRANCH_NAME = _CompanyModel.BRANCH_NAME;
db.TBL_BANK_ACCOUNT.Add(ac);
db.SaveChanges();
TBL_GODOWN gd = new TBL_GODOWN();
gd.COMPANY_ID = ID;
gd.GODOWN_NAME = _CompanyModel.NAME;
gd.GOSOWN_DESCRIPTION = "Default Godown";
gd.IS_ACTIVE = true;
gd.IS_DELETE = false;
gd.IS_DEFAULT_GODOWN = true;
return(Request.CreateResponse(HttpStatusCode.OK, com));
}
else
{
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed));
}
}
catch (Exception ex)
{
throw;
}
finally
{
ConnectionTools.ChangeToRemoteDB(db);
}
}
