public bool UpdateWiseBal(Models.SBP_BlotterDTLDaysWiseBal blotterWiseBal)
{
EntityMapperBlotterDTLDB <Models.SBP_BlotterDTLDaysWiseBal, DataAccessLayer.SBP_BlotterDTLDaysWiseBal> mapObj =
new EntityMapperBlotterDTLDB <Models.SBP_BlotterDTLDaysWiseBal, DataAccessLayer.SBP_BlotterDTLDaysWiseBal>();
DataAccessLayer.SBP_BlotterDTLDaysWiseBal WiseBalObj = new DataAccessLayer.SBP_BlotterDTLDaysWiseBal();
WiseBalObj = mapObj.Translate(blotterWiseBal);
var status = DAL.UpdateWiseBal(WiseBalObj);
return(status);
}
public JsonResult <Models.SBP_BlotterDTLDaysWiseBal> GetBlotterDBList(String BrCode)
{
EntityMapperBlotterDTLDB <DataAccessLayer.SBP_BlotterDTLDaysWiseBal, Models.SBP_BlotterDTLDaysWiseBal> mapObj =
new EntityMapperBlotterDTLDB <DataAccessLayer.SBP_BlotterDTLDaysWiseBal, Models.SBP_BlotterDTLDaysWiseBal>();
DataAccessLayer.SBP_BlotterDTLDaysWiseBal blotterList = DAL.GetDTLDeskBoard(BrCode);
Models.SBP_BlotterDTLDaysWiseBal blotter = new Models.SBP_BlotterDTLDaysWiseBal();
blotter = mapObj.Translate(blotterList);
return(Json <Models.SBP_BlotterDTLDaysWiseBal>(blotter));
}
public bool UpdateRunningBal(String BranchCode) //,DateTime StartDate,DateTime Endate)
{
EntityMapperBlotterDTLDB <DataAccessLayer.SBP_BlotterDTLDaysWiseBal, Models.SBP_BlotterDTLDaysWiseBal> mapObj =
new EntityMapperBlotterDTLDB <DataAccessLayer.SBP_BlotterDTLDaysWiseBal, Models.SBP_BlotterDTLDaysWiseBal>();
DataAccessLayer.SBP_BlotterDTLDaysWiseBal blotter = DAL.GetDTLDeskBoard(BranchCode);
bool status = false;
if (blotter.Id > 0)
{
var StartDate = blotter.DTL_Date;
var Endate = blotter.NextDate;
status = DAL.UpdateRunningBal(BranchCode, StartDate, Endate);
}
return(status);
}
public static bool UpdateWiseBal(SBP_BlotterDTLDaysWiseBal WiseBalItem)
{
bool status;
try
{
SBP_BlotterDTLDaysWiseBal prodItem = DbContextB.SBP_BlotterDTLDaysWiseBal.Where(p => p.Id == WiseBalItem.Id).FirstOrDefault();
if (prodItem != null)
{
//prodItem.Id = WiseBalItem.Id;
prodItem.DTL_Days = WiseBalItem.DTL_Days;
prodItem.DTL_Date = WiseBalItem.DTL_Date;
prodItem.NextDate = WiseBalItem.NextDate;
prodItem.DTL_Amount = WiseBalItem.DTL_Amount;
prodItem.MinAmount_3P = WiseBalItem.MinAmount_3P;
prodItem.MaxAmount_5P = WiseBalItem.MaxAmount_5P;
prodItem.Friday_01 = WiseBalItem.Friday_01;
prodItem.Date_01 = WiseBalItem.Date_01;
prodItem.CashFlow_01 = WiseBalItem.CashFlow_01;
prodItem.CashOutFlow_01 = WiseBalItem.CashOutFlow_01;
prodItem.Saturday_02 = WiseBalItem.Saturday_02;
prodItem.Date_02 = WiseBalItem.Date_02;
prodItem.CashFlow_02 = WiseBalItem.CashFlow_02;
prodItem.CashOutFlow_02 = WiseBalItem.CashOutFlow_02;
prodItem.Sunday_03 = WiseBalItem.Sunday_03;
prodItem.Date_03 = WiseBalItem.Date_03;
prodItem.CashFlow_03 = WiseBalItem.CashFlow_03;
prodItem.CashOutFlow_03 = WiseBalItem.CashOutFlow_03;
prodItem.Monday_04 = WiseBalItem.Monday_04;
prodItem.Date_04 = WiseBalItem.Date_04;
prodItem.CashFlow_04 = WiseBalItem.CashFlow_04;
prodItem.CashOutFlow_04 = WiseBalItem.CashOutFlow_04;
prodItem.Tuesday_05 = WiseBalItem.Tuesday_05;
prodItem.Date_05 = WiseBalItem.Date_05;
prodItem.CashFlow_05 = WiseBalItem.CashFlow_05;
prodItem.CashOutFlow_05 = WiseBalItem.CashOutFlow_05;
prodItem.Wednesday_06 = WiseBalItem.Wednesday_06;
prodItem.Date_06 = WiseBalItem.Date_06;
prodItem.CashFlow_06 = WiseBalItem.CashFlow_06;
prodItem.CashOutFlow_06 = WiseBalItem.CashOutFlow_06;
prodItem.Thursday_07 = WiseBalItem.Thursday_07;
prodItem.Date_07 = WiseBalItem.Date_07;
prodItem.CashFlow_07 = WiseBalItem.CashFlow_07;
prodItem.CashOutFlow_07 = WiseBalItem.CashOutFlow_07;
prodItem.Friday_08 = WiseBalItem.Friday_08;
prodItem.Date_08 = WiseBalItem.Date_08;
prodItem.CashFlow_08 = WiseBalItem.CashFlow_08;
prodItem.CashOutFlow_08 = WiseBalItem.CashOutFlow_08;
prodItem.Saturday_09 = WiseBalItem.Saturday_09;
prodItem.Date_09 = WiseBalItem.Date_09;
prodItem.CashFlow_09 = WiseBalItem.CashFlow_09;
prodItem.CashOutFlow_09 = WiseBalItem.CashOutFlow_09;
prodItem.Sunday_10 = WiseBalItem.Sunday_10;
prodItem.Date_10 = WiseBalItem.Date_10;
prodItem.CashFlow_10 = WiseBalItem.CashFlow_10;
prodItem.CashOutFlow_10 = WiseBalItem.CashOutFlow_10;
prodItem.Monday_11 = WiseBalItem.Monday_11;
prodItem.Date_11 = WiseBalItem.Date_11;
prodItem.CashFlow_11 = WiseBalItem.CashFlow_11;
prodItem.CashOutFlow_11 = WiseBalItem.CashOutFlow_11;
prodItem.Tuesday_12 = WiseBalItem.Tuesday_12;
prodItem.Date_12 = WiseBalItem.Date_12;
prodItem.CashFlow_12 = WiseBalItem.CashFlow_12;
prodItem.CashOutFlow_12 = WiseBalItem.CashOutFlow_12;
prodItem.Wednesday_13 = WiseBalItem.Wednesday_13;
prodItem.Date_13 = WiseBalItem.Date_13;
prodItem.CashFlow_13 = WiseBalItem.CashFlow_13;
prodItem.CashOutFlow_13 = WiseBalItem.CashOutFlow_13;
prodItem.Thursday_14 = WiseBalItem.Thursday_14;
prodItem.Date_14 = WiseBalItem.Date_14;
prodItem.CashFlow_14 = WiseBalItem.CashFlow_14;
prodItem.CashOutFlow_14 = WiseBalItem.CashOutFlow_14;
prodItem.BR = WiseBalItem.BR;
DbContextB.SaveChanges();
}
status = true;
}
catch (Exception)
{
status = false;
}
return(status);
}
