protected override MPRBalanceSheetAdjustment UpdateEntity(MPRContext entityContext, MPRBalanceSheetAdjustment entity)
{
return((from e in entityContext.Set <MPRBalanceSheetAdjustment>()
where e.BalancesheetAdjustmentId == entity.BalancesheetAdjustmentId
select e).FirstOrDefault());
}
protected override Customermis UpdateEntity(MPRContext entityContext, Customermis entity)
{
return((from e in entityContext.Set <Customermis>()
where e.CustomermisId == entity.CustomermisId
select e).FirstOrDefault());
}
protected override BranchDefaultMIS AddEntity(MPRContext entityContext, BranchDefaultMIS entity)
{
return(entityContext.Set <BranchDefaultMIS>().Add(entity));
}
protected override ManagementTree AddEntity(MPRContext entityContext, ManagementTree entity)
{
return(entityContext.Set <ManagementTree>().Add(entity));
}
protected override IEnumerable <ManagementTree> GetEntities(MPRContext entityContext)
{
return(from e in entityContext.Set <ManagementTree>()
select e);
}
public List <RevenueBudgetOfficer> GetBalanceSheetBySearch(string searchValue)
{
//var connectionString = ConfigurationManager.ConnectionStrings["FintrakDBConnection"].ConnectionString;
var connectionString = MPRContext.GetDataConnection();
var balSheets = new List <RevenueBudgetOfficer>();
using (var con = new SqlConnection(connectionString))
{
var cmd = new SqlCommand("spp_mpr_revenuebudgetofficer", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "SearchValue",
Value = searchValue,
});
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var balSheet = new RevenueBudgetOfficer();
if (reader["RevenueBudgetOffId"] != DBNull.Value)
{
balSheet.BudgetId = int.Parse(reader["RevenueBudgetOffId"].ToString());
}
if (reader["CompanyCode"] != DBNull.Value)
{
balSheet.CompanyCode = reader["CompanyCode"].ToString();
}
if (reader["AccountOfficerCode"] != DBNull.Value)
{
balSheet.MisCode = reader["AccountOfficerCode"].ToString();
}
if (reader["Year"] != DBNull.Value)
{
balSheet.Year = reader["Year"].ToString();
}
if (reader["CaptionName"] != DBNull.Value)
{
balSheet.CaptionName = reader["CaptionName"].ToString();
}
if (reader["Mth1"] != DBNull.Value)
{
balSheet.Mth1 = decimal.Parse(reader["Mth1"].ToString());
}
if (reader["Mth2"] != DBNull.Value)
{
balSheet.Mth2 = decimal.Parse(reader["Mth2"].ToString());
}
if (reader["Mth3"] != DBNull.Value)
{
balSheet.Mth3 = decimal.Parse(reader["Mth3"].ToString());
}
if (reader["Mth4"] != DBNull.Value)
{
balSheet.Mth4 = decimal.Parse(reader["Mth4"].ToString());
}
if (reader["Mth5"] != DBNull.Value)
{
balSheet.Mth5 = decimal.Parse(reader["Mth5"].ToString());
}
if (reader["Mth6"] != DBNull.Value)
{
balSheet.Mth6 = decimal.Parse(reader["Mth6"].ToString());
}
if (reader["Mth7"] != DBNull.Value)
{
balSheet.Mth7 = decimal.Parse(reader["Mth7"].ToString());
}
if (reader["Mth8"] != DBNull.Value)
{
balSheet.Mth8 = decimal.Parse(reader["Mth8"].ToString());
}
if (reader["Mth9"] != DBNull.Value)
{
balSheet.Mth9 = decimal.Parse(reader["Mth9"].ToString());
}
if (reader["Mth10"] != DBNull.Value)
{
balSheet.Mth10 = decimal.Parse(reader["Mth10"].ToString());
}
if (reader["Mth11"] != DBNull.Value)
{
balSheet.Mth11 = decimal.Parse(reader["Mth11"].ToString());
}
if (reader["Mth12"] != DBNull.Value)
{
balSheet.Mth12 = decimal.Parse(reader["Mth12"].ToString());
}
balSheets.Add(balSheet);
}
con.Close();
}
return(balSheets);
}
protected override SbuType UpdateEntity(MPRContext entityContext, SbuType entity)
{
return((from e in entityContext.Set <SbuType>()
where e.SbuTypeId == entity.SbuTypeId
select e).FirstOrDefault());
}
protected override CorporateAdjustment AddEntity(MPRContext entityContext, CorporateAdjustment entity)
{
return(entityContext.Set <CorporateAdjustment>().Add(entity));
}
protected override CorporateAdjustment UpdateEntity(MPRContext entityContext, CorporateAdjustment entity)
{
return((from e in entityContext.Set <CorporateAdjustment>()
where e.CorporateAdjustmentId == entity.CorporateAdjustmentId
select e).FirstOrDefault());
}
protected override OpexUpdate AddEntity(MPRContext entityContext, OpexUpdate entity)
{
return(entityContext.Set <OpexUpdate>().Add(entity));
}
protected override OpexUpdate UpdateEntity(MPRContext entityContext, OpexUpdate entity)
{
return((from e in entityContext.Set <OpexUpdate>()
where e.ID == entity.ID
select e).FirstOrDefault());
}
protected override IEnumerable <IncomeProductShare> GetEntities(MPRContext entityContext)
{
return(from e in entityContext.Set <IncomeProductShare>()
select e);
}
protected override IncomeProductShare UpdateEntity(MPRContext entityContext, IncomeProductShare entity)
{
return((from e in entityContext.Set <IncomeProductShare>()
where e.ID == entity.ID
select e).FirstOrDefault());
}
protected override IncomeProductShare AddEntity(MPRContext entityContext, IncomeProductShare entity)
{
return(entityContext.Set <IncomeProductShare>().Add(entity));
}
protected override RevenueBudgetOfficer UpdateEntity(MPRContext entityContext, RevenueBudgetOfficer entity)
{
return((from e in entityContext.Set <RevenueBudgetOfficer>()
where e.BudgetId == entity.BudgetId
select e).FirstOrDefault());
}
protected override IEnumerable <CorporateAdjustment> GetEntities(MPRContext entityContext)
{
return(from e in entityContext.Set <CorporateAdjustment>()
select e);
}
protected override IEnumerable <RevenueBudgetOfficer> GetEntities(MPRContext entityContext)
{
return(from e in entityContext.Set <RevenueBudgetOfficer>()
select e);
}
protected override MemoUnits AddEntity(MPRContext entityContext, MemoUnits entity)
{
return(entityContext.Set <MemoUnits>().Add(entity));
}
protected override SbuType AddEntity(MPRContext entityContext, SbuType entity)
{
return(entityContext.Set <SbuType>().Add(entity));
}
protected override MemoUnits UpdateEntity(MPRContext entityContext, MemoUnits entity)
{
return((from e in entityContext.Set <MemoUnits>()
where e.MemoUnitsId == entity.MemoUnitsId
select e).FirstOrDefault());
}
protected override IEnumerable <SbuType> GetEntities(MPRContext entityContext)
{
return(from e in entityContext.Set <SbuType>()
select e);
}
protected override ExpenseGLMapping AddEntity(MPRContext entityContext, ExpenseGLMapping entity)
{
return(entityContext.Set <ExpenseGLMapping>().Add(entity));
}
protected override ManagementTree UpdateEntity(MPRContext entityContext, ManagementTree entity)
{
return((from e in entityContext.Set <ManagementTree>()
where e.ManagementTreeId == entity.ManagementTreeId
select e).FirstOrDefault());
}
protected override ExpenseGLMapping UpdateEntity(MPRContext entityContext, ExpenseGLMapping entity)
{
return((from e in entityContext.Set <ExpenseGLMapping>()
where e.ExpenseGLId == entity.ExpenseGLId
select e).FirstOrDefault());
}
protected override Customermis AddEntity(MPRContext entityContext, Customermis entity)
{
return(entityContext.Set <Customermis>().Add(entity));
}
protected override IEnumerable <ExpenseGLMapping> GetEntities(MPRContext entityContext)
{
return(from e in entityContext.Set <ExpenseGLMapping>()
select e);
}
protected override IEnumerable <Customermis> GetEntities(MPRContext entityContext)
{
return(from e in entityContext.Set <Customermis>()
select e);
}
protected override RevenueBudgetOfficer AddEntity(MPRContext entityContext, RevenueBudgetOfficer entity)
{
return(entityContext.Set <RevenueBudgetOfficer>().Add(entity));
}
protected override BranchDefaultMIS UpdateEntity(MPRContext entityContext, BranchDefaultMIS entity)
{
return((from e in entityContext.Set <BranchDefaultMIS>()
where e.BranchDefaultMISId == entity.BranchDefaultMISId
select e).FirstOrDefault());
}
public List <MPRBalanceSheetAdjustment> GetBalanceSheetAdjustmentByCode(string code, string userName)
{
var connectionString = MPRContext.GetDataConnection();
var balSheetAdjs = new List <MPRBalanceSheetAdjustment>();
using (var con = new SqlConnection(connectionString))
{
var cmd = new SqlCommand("spp_getmprbalancesheetadjustmentbyCode", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "code",
Value = code,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "username",
Value = userName,
});
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var balSheetAdj = new MPRBalanceSheetAdjustment();
if (reader["BalancesheetAdjustmentId"] != DBNull.Value)
{
balSheetAdj.BalancesheetAdjustmentId = int.Parse(reader["BalancesheetAdjustmentId"].ToString());
}
if (reader["AccountNo"] != DBNull.Value)
{
balSheetAdj.AccountNo = reader["AccountNo"].ToString();
}
if (reader["AccountName"] != DBNull.Value)
{
balSheetAdj.AccountName = reader["AccountName"].ToString();
}
if (reader["TeamCode"] != DBNull.Value)
{
balSheetAdj.TeamCode = reader["TeamCode"].ToString();
}
if (reader["AccountOfficerCode"] != DBNull.Value)
{
balSheetAdj.AccountOfficerCode = reader["AccountOfficerCode"].ToString();
}
if (reader["ProductCode"] != DBNull.Value)
{
balSheetAdj.ProductCode = reader["ProductCode"].ToString();
}
if (reader["Category"] != DBNull.Value)
{
balSheetAdj.Category = reader["Category"].ToString();
}
if (reader["CurrencyType"] != DBNull.Value)
{
balSheetAdj.CurrencyType = reader["CurrencyType"].ToString();
}
if (reader["ActualBal"] != DBNull.Value)
{
balSheetAdj.ActualBal = double.Parse(reader["ActualBal"].ToString());
}
if (reader["AverageBal"] != DBNull.Value)
{
balSheetAdj.AverageBal = double.Parse(reader["AverageBal"].ToString());
}
if (reader["Interest"] != DBNull.Value)
{
balSheetAdj.Interest = decimal.Parse(reader["Interest"].ToString());
}
if (reader["CompanyCode"] != DBNull.Value)
{
balSheetAdj.CompanyCode = reader["CompanyCode"].ToString();
}
if (reader["Code"] != DBNull.Value)
{
balSheetAdj.Code = reader["Code"].ToString();
}
if (reader["RunDate"] != DBNull.Value)
{
balSheetAdj.Rundate = DateTime.Parse(reader["RunDate"].ToString());
}
balSheetAdjs.Add(balSheetAdj);
}
con.Close();
}
return(balSheetAdjs);
}
