public HttpResponseMessage TransferCashAdd(CashRegModel crm) { try { bool conn = false; conn = db.Database.Exists(); if (!conn) { ConnectionTools.changeToLocalDB(db); conn = db.Database.Exists(); } if (conn) { TBL_TRANSFER_CASH tc = new TBL_TRANSFER_CASH(); tc.COMPANY_ID = crm.COMPANY_ID; tc.BUSINESS_LOC_ID = crm.BUSINESS_LOCATION_ID; tc.BUSINESS_LOC = crm.BUSINESS_LOCATION; tc.CASH_TRANSFER_NUMBER = crm.TRANSFER_CODE; tc.FROM_CASH_REGISTER = crm.FROM_TRAN_CASH_REGISTER; tc.TO_CASH_REGISTER = crm.TO_TRAN_CASH_REGISTER; tc.TOTAL_TRANSFERED_AMOUNT = crm.CASH_TO_TRANSFER; tc.TRANSFER_DATE = crm.TRANSFER_DATE; tc.IS_TRANSFER_CASH_REGISTER = crm.IS_TRANSFER_CASH_REGISTER; tc.CASH_REGISTERID_FROM = crm.CASH_REGISTERID_FROM; tc.CASH_REGISTERID_TO = crm.CASH_REGISTERID_TO; tc.STATUS = "Approved"; tc.IS_DELETE = false; db.TBL_TRANSFER_CASH.Add(tc); db.SaveChanges(); var str = (from a in db.TBL_NEWCASHREGISTER where a.CASH_REGISTERID == crm.CASH_REGISTERID_FROM select a).FirstOrDefault(); str.CASH_AMOUNT = crm.CURRENT_CASH - crm.CASH_TO_TRANSFER; var str1 = (from a in db.TBL_NEWCASHREGISTER where a.CASH_REGISTERID == crm.CASH_REGISTERID_TO select a).FirstOrDefault(); str1.CASH_AMOUNT = str1.CASH_AMOUNT + crm.CASH_TO_TRANSFER; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "success")); } else { return(Request.CreateResponse(HttpStatusCode.ExpectationFailed)); } } catch (Exception ex) { throw; } finally { ConnectionTools.ChangeToRemoteDB(db); } }
public HttpResponseMessage CreateCashReg(CashRegModel _CashRegModel) { try { bool conn = false; conn = db.Database.Exists(); if (!conn) { ConnectionTools.changeToLocalDB(db); conn = db.Database.Exists(); } if (conn) { TBL_NEWCASHREGISTER _CashReg = new TBL_NEWCASHREGISTER(); _CashReg.COMPANY_ID = _CashRegModel.COMPANY_ID; _CashReg.BUSINESS_LOCATION = _CashRegModel.BUSINESS_LOCATION; _CashReg.CASH_REG_NAME = _CashRegModel.CASH_REG_NAME; _CashReg.CASH_REG_NO = _CashRegModel.CASH_REG_NO; _CashReg.CASH_REG_PREFIX = _CashRegModel.CASH_REG_PREFIX; _CashReg.CASH_REGISTERID = _CashRegModel.CASH_REGISTERID; _CashReg.IS_ADGUSTMENT = _CashRegModel.ISADGUSTMENT; _CashReg.LOGIN = _CashRegModel.LOGIN; _CashReg.IS_MAIN_CASH = _CashRegModel.IS_MAIN_CASH; _CashReg.IS_DELETE = false; _CashReg.CASH_AMOUNT = _CashRegModel.CASH_AMOUNT; db.TBL_NEWCASHREGISTER.Add(_CashReg); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "success")); } else { return(Request.CreateResponse(HttpStatusCode.ExpectationFailed)); } } catch (Exception ex) { throw; } finally { ConnectionTools.ChangeToRemoteDB(db); } }
public HttpResponseMessage CashRegUpdate(CashRegModel _CashRegModel) { try { bool conn = false; conn = db.Database.Exists(); if (!conn) { ConnectionTools.changeToLocalDB(db); conn = db.Database.Exists(); } if (conn) { var str = (from a in db.TBL_NEWCASHREGISTER where a.CASH_REGISTERID == _CashRegModel.CASH_REGISTERID select a).FirstOrDefault(); str.COMPANY_ID = _CashRegModel.COMPANY_ID; str.BUSINESS_LOCATION = _CashRegModel.BUSINESS_LOCATION; str.CASH_REG_NAME = _CashRegModel.CASH_REG_NAME; str.CASH_REG_NO = _CashRegModel.CASH_REG_NO; str.CASH_REG_PREFIX = _CashRegModel.CASH_REG_PREFIX; str.CASH_REGISTERID = _CashRegModel.CASH_REGISTERID; str.IS_ADGUSTMENT = _CashRegModel.ISADGUSTMENT; str.LOGIN = _CashRegModel.LOGIN; str.IS_MAIN_CASH = _CashRegModel.IS_MAIN_CASH; str.IS_DELETE = false; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "success")); } else { return(Request.CreateResponse(HttpStatusCode.ExpectationFailed)); } } catch (Exception ex) { throw; } finally { ConnectionTools.ChangeToRemoteDB(db); } }