public HttpResponseMessage BankAdd(BankModel _BankModel) { try { bool conn = false; conn = db.Database.Exists(); if (!conn) { ConnectionTools.changeToLocalDB(db); conn = db.Database.Exists(); } if (conn) { if (_BankModel.BANK_ID == null || _BankModel.BANK_ID == 0) { TBL_BANK gd = new TBL_BANK(); gd.ADDRESS_1 = _BankModel.ADDRESS_1; gd.ADDRESS_2 = _BankModel.ADDRESS_2; gd.BANK_CODE = _BankModel.BANK_CODE; gd.BANK_ID = _BankModel.BANK_ID; gd.BANK_NAME = _BankModel.BANK_NAME; gd.CITY = _BankModel.CITY; gd.COMPANY_ID = _BankModel.COMPANY_ID; gd.COUNTRY = _BankModel.COUNTRY; gd.EMAIL = _BankModel.EMAIL; gd.FAX_NUMBER = _BankModel.FAX_NUMBER; gd.IFSC_CODE = _BankModel.IFSC_CODE; gd.IS_DELETED = false; gd.MOBILE_NUMBER = _BankModel.MOBILE_NUMBER; gd.PHONE_NUMBER = _BankModel.PHONE_NUMBER; gd.PIN_CODE = _BankModel.PIN_CODE; gd.STATE = _BankModel.STATE; gd.WEBSITE = _BankModel.WEBSITE; db.TBL_BANK.Add(gd); db.SaveChanges(); } return(Request.CreateResponse(HttpStatusCode.OK, "ok")); } else { return(Request.CreateResponse(HttpStatusCode.ExpectationFailed)); } } catch (Exception ex) { throw; } finally { ConnectionTools.ChangeToRemoteDB(db); } }
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); } }