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);
}
}
