public HttpResponseMessage BankAddAC(BankAccountModel _BankAccountModel)
{
try
{
bool conn = false;
conn = db.Database.Exists();
if (!conn)
{
ConnectionTools.changeToLocalDB(db);
conn = db.Database.Exists();
}
if (conn)
{
if (_BankAccountModel.BANK_ACCOUNT_ID == null || _BankAccountModel.BANK_ACCOUNT_ID == 0)
{
TBL_BANK_ACCOUNT gd = new TBL_BANK_ACCOUNT();
gd.ACCOUNT_DESCRIPTION = _BankAccountModel.ACCOUNT_DESCRIPTION;
gd.ACCOUNT_NUMBER = _BankAccountModel.ACCOUNT_NUMBER;
gd.ACCOUNT_SEARCH_CODE = _BankAccountModel.ACCOUNT_SEARCH_CODE;
gd.BANK_ID = _BankAccountModel.BANK_ID;
gd.BRANCH_NAME = _BankAccountModel.BRANCH_NAME;
gd.COMPANY_ID = _BankAccountModel.COMPANY_ID;
gd.IS_DELETE = _BankAccountModel.IS_DELETE;
gd.PRINTING_FORMAT = _BankAccountModel.PRINTING_FORMAT;
db.TBL_BANK_ACCOUNT.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);
}
}
