//
// GET: /Budget/
public ActionResult Index(string p_BudgetId)
{
//DALBudgetEntry objDalBudgetEntry = new DALBudgetEntry();
var lst_BudgetTypes = new DALBudgetType().PopulateData();
var lst_Years = new DALCalendar().GetAllRecords();
var lst_Locations = new DALLocation().PopulateData();
var lst_ChartOfAccounts = new DALChartOfAccount().GetChartOfAccountForDropDown(1,"''");
ViewData["ddl_BudgetType"] = new SelectList(lst_BudgetTypes, "BgdtType_Id", "BgdtType_Title", "");
ViewData["ddl_Year"] = new SelectList(lst_Years, "Cldr_Id", "Cldr_Title", "");
ViewData["ddl_Location"] = new SelectList(lst_Locations, "Loc_Id", "Loc_Title", "");
ViewData["ddl_Account"] = new SelectList(lst_ChartOfAccounts, "ChrtAcc_Id", "ChrtAcc_Title", "");
//string ChartOfAccountCodes = "";
//foreach (SETUP_ChartOfAccount COA in ChartOfAccounts)
//{
// if (ChartOfAccountCodes.Length > 0)
// {
// ChartOfAccountCodes += "," + COA.ChrtAcc_Id + ":" + COA.ChrtAcc_Title;
// }
// {
// ChartOfAccountCodes += COA.ChrtAcc_Id + ":" + COA.ChrtAcc_Title;
// }
//}
//ViewData["ChartOfAccountCodesWithTitles"] = ChartOfAccountCodes;
//SETUP_ChartOfAccount SelectChartOfAccount = new SETUP_ChartOfAccount();
//SelectChartOfAccount.ChrtAcc_Id = "0";
//SelectChartOfAccount.ChrtAcc_Code = "";
//ChartOfAccounts.Insert(0, SelectChartOfAccount);
//ViewData["ChartOfAccounts"] = ChartOfAccounts;
//ViewData["ddl_Account"] = new SelectList(ChartOfAccounts, "ChrtAcc_Id", "ChrtAcc_Title", "");
////var NarrationList = new DALBudgetTypeNarration().GetAllData().ToList();
////string[] nList = new string[NarrationList.Count];
////if (NarrationList != null && NarrationList.Count > 0)
////{
//// for (int index = 0; index < NarrationList.Count; index++)
//// {
//// nList[index] = NarrationList[index].VchrTypeNarr_Title;
//// }
//// System.Web.Script.Serialization.JavaScriptSerializer se = new System.Web.Script.Serialization.JavaScriptSerializer();
//// ViewData["Narrations"] = se.Serialize(nList);
////}
//ViewData["ddl_Location"] = new SelectList(Locations, "Loc_Id", "Loc_Title", Session["LocationIdForBudgetEntry"]);
if (!String.IsNullOrEmpty(p_BudgetId))
{
EditBudget(p_BudgetId);
}
else
{
ViewData["BudgetCode"] = "[Auto]";
ViewData["CurrentDate"] = DateTime.Now.ToString("MM/dd/yyyy");
}
//Session.Remove("BudgetTypeForBudgetEntry");
//Session.Remove("LocationIdForBudgetEntry");
return View("Budget");
}
//public String GetLastRecordByBudgetTypeId(string LocationId, string BudgetTypeId)
//{
// var Budget = new DALBudgetEntry().GetLastRecordByVchrType(LocationId, BudgetTypeId);
// String LastBudget = "";
// if (Budget != null && Budget.Count > 0)
// {
// LastBudget += "<div class='CustomCell' style='width: 800px; height: 30px; font-family: Tahoma;'>";
// LastBudget += "<b>Budget # : </b>";
// LastBudget += Budget.Last().BgdtMas_Code;
// LastBudget += "<b>, Date : </b>";
// LastBudget += Budget.Last().BgdtMas_Date != null ? Convert.ToDateTime(Budget.Last().BgdtMas_Date).ToShortDateString() : "";
// LastBudget += "<b>, Status : </b>";
// LastBudget += Budget.Last().BgdtMas_Status;
// LastBudget += "</div>";
// LastBudget += "<div class='Clear' style='border-bottom: 1px solid #ccc; margin-bottom: 5px;'>";
// LastBudget += "</div>";
// }
// return LastBudget;
//}
//public ActionResult SaveBudget(String BudgetMasterCode, DateTime BudgetDate, string Status, String BudgetType, String LocationId, String Remarks, String[] BudgetDetailRows)
//[HttpPost]
//[AcceptVerbs(HttpVerbs.Post)]
public string SaveBudget(IEnumerable<string> BudgetRow)
{
//Session["BudgetTypeForBudgetEntry"] = BudgetType;
//Session["LocationIdForBudgetEntry"] = LocationId;
DALBudgetEntry objDalBudgetEntry = new DALBudgetEntry();
DALCalendar objDalCalendar = new DALCalendar();
GL_BgdtMaster GLBgdtMaster = new GL_BgdtMaster();
//int flag = 0;
//String ls_Action = "Edit", IsAuditTrail = "", ls_UserId = "";
//String[] ls_Lable = new String[7], ls_Data = new String[7];
Int32 li_ReturnValue = 0;
try
{
// GL_VchrDetail GL_Detail = new GL_VchrDetail();
// String Prefix = new DALBudgetType().GetAllData().Where(c => c.BgdtType_Id.Equals(BudgetType)).SingleOrDefault().VchrType_Prefix;
// ls_VchrTypId = Convert.ToString(Convert.ToInt32(BudgetType));
String[] MasterRow = BudgetRow.Last().Split('║');
String BudgetMasterId = MasterRow[0];
String BudgetMasterCode = MasterRow[1].Replace("[Auto]", null);
DateTime BudgetDate = MasterRow[2] != null ? Convert.ToDateTime(MasterRow[2]) : DateTime.Now;
String Status = MasterRow[3];
String BudgetType = MasterRow[4];
String Year = MasterRow[5];
String LocationId = MasterRow[6];
String Remarks = MasterRow[7];
string ls_YearPrefix = "";
//if (String.IsNullOrEmpty(BudgetMasterId))
if (String.IsNullOrEmpty(BudgetMasterCode))
{
if (DALCommon.AutoCodeGeneration("GL_BgdtMaster") == 1)
{
ls_YearPrefix = objDalCalendar.GetCalendarPrefix_ByCurrentDate(BudgetDate);
if (ls_YearPrefix == null && ls_YearPrefix == "")
{
return "";
}
BudgetMasterId = DALCommon.GetMaxBudgetMasId(ls_YearPrefix);
BudgetMasterCode = BudgetMasterId;
//BudgetMasterCode = DALCommon.GetMaxBudgetCode("GL_VchrMaster", BudgetType, Prefix, LocationId, ls_YearPrefix);
//ls_Action = "Add";
}
}
// List<GL_VchrDetail> BudgetDetailList = new List<GL_VchrDetail>();
if (!String.IsNullOrEmpty(BudgetMasterCode))
{
//ViewData["BudgetId"] = BudgetMasterId;
//ViewData["BudgetCode"] = BudgetMasterCode;
GLBgdtMaster.BgdtMas_Id = BudgetMasterId;
GLBgdtMaster.BgdtMas_Code = BudgetMasterCode;
GLBgdtMaster.BgdtMas_Date = BudgetDate;
GLBgdtMaster.BgdtMas_Status = Status;
GLBgdtMaster.BgdtType_Id = BudgetType;
GLBgdtMaster.Cldr_Id = Year;
GLBgdtMaster.Loc_Id = LocationId;
GLBgdtMaster.BgdtMas_Remarks = Remarks;
GLBgdtMaster.BgdtMas_EnteredDate = DateTime.Now;
GLBgdtMaster.BgdtMas_EnteredBy = ((SECURITY_User)Session["user"]).User_Title;
li_ReturnValue = objDalBudgetEntry.SaveBudgetMaster(GLBgdtMaster);
// if (li_ReturnValue > 0)
// {
// if (flag == 1)
// {
// objDalBudgetEntry.DeleteDetailRecordByMasterId(BudgetMasterId);
// }
// for (int index = 0; index < BudgetDetailRows.ToList().Count - 1; index++)
// {
// string Row = BudgetDetailRows.ToList()[index];
// String[] Columns = Row.Split('║');
// String BudgetDetailCode = "";
// if (String.IsNullOrEmpty(BudgetDetailCode))
// {
// if (DALCommon.AutoCodeGeneration("GL_VchrDetail") == 1)
// {
// BudgetDetailCode = DALCommon.GetMaximumCode("GL_VchrDetail");
// //BudgetDetailCode = BudgetMasterCode;
// }
// }
// if (!String.IsNullOrEmpty(BudgetDetailCode) && Columns[0] != null && Columns[0] != "" && Columns[0] != "0" && ((Columns[1] != null && Columns[1] != "") || (Columns[2] != null && Columns[2] != "")))
// {
// GL_Detail = new GL_VchrDetail();
// GL_Detail.VchDet_Id = BudgetDetailCode;
// GL_Detail.BgdtMas_Id = BudgetMasterId;
// GL_Detail.ChrtAcc_Id = Columns[0].ToString(); //Columns[0] has AccountId from Account Title drop down;
// GL_Detail.VchMas_DrAmount = (Columns[1] != null && Columns[1] != "") ? Convert.ToDecimal(Columns[1].Replace(",", "")) : 0; // Columns[1] has Debit Amount
// GL_Detail.VchMas_CrAmount = (Columns[2] != null && Columns[2] != "") ? Convert.ToDecimal(Columns[2].Replace(",", "")) : 0; // Columns[2] has Debit Amount
// GL_Detail.VchDet_Remarks = (Columns[3] != null && Columns[3] != "") ? Columns[3].ToString() : ""; // Columns[3] has Remarks
// objDalBudgetEntry.SaveBudgetDetail(GL_Detail);
// BudgetDetailList.Add(GL_Detail);
// }
// }
// }
}
//ViewData["SaveResult"] = li_ReturnValue;
// IsAuditTrail = System.Configuration.ConfigurationManager.AppSettings.GetValues("IsAuditTrail")[0];
// // Save Audit Log
// if (li_ReturnValue > 0 && IsAuditTrail == "1")
// {
// DALAuditLog objAuditLog = new DALAuditLog();
// ls_UserId = ((SECURITY_User)Session["user"]).User_Id;
// ls_Lable[0] = "Code";
// ls_Lable[1] = "Date";
// ls_Lable[2] = "Location";
// ls_Lable[3] = "Budget Type";
// ls_Lable[4] = "Remarks";
// ls_Lable[5] = "Status";
// ls_Data[0] = BudgetMasterCode;
// ls_Data[1] = BudgetDate.ToString("dd/MM/yyyy");
// ls_Data[2] = LocationId;
// ls_Data[3] = BudgetType;
// ls_Data[4] = Remarks;
// ls_Data[5] = Status;
// foreach (GL_VchrDetail BudgetDetail in BudgetDetailList)
// {
// Increment++;
// ls_Lable[Increment] = "Account Code";
// ls_Data[Increment] = BudgetDetail.ChrtAcc_Id;
// Increment++;
// ls_Lable[Increment] = "Debit";
// ls_Data[Increment] = Convert.ToString(BudgetDetail.VchMas_DrAmount);
// Increment++;
// ls_Lable[Increment] = "Credit";
// ls_Data[Increment] = Convert.ToString(BudgetDetail.VchMas_CrAmount);
// Increment++;
// ls_Lable[Increment] = "Narration";
// ls_Data[Increment] = BudgetDetail.VchDet_Remarks;
// }
// objAuditLog.SaveRecord(7, ls_UserId, ls_Action, ls_Lable, ls_Data);
// }
// //// Audit Trail Entry Section
// //if (li_ReturnValue > 0)
// //{
// // string IsAuditTrail = System.Configuration.ConfigurationManager.AppSettings.GetValues(3)[0];
// // if (IsAuditTrail == "1")
// // {
// // SYSTEM_AuditTrail systemAuditTrail = new SYSTEM_AuditTrail();
// // DALAuditLog objAuditTrail = new DALAuditLog();
// // systemAuditTrail.Scr_Id = flag == 0 ? 17 : 16;
// // systemAuditTrail.User_Id = ((SECURITY_User)Session["user"]).User_Id;
// // systemAuditTrail.Loc_Id = GL_Master.Loc_Id;
// // systemAuditTrail.BgdtType_Id = GL_Master.BgdtType_Id;
// // systemAuditTrail.AdtTrl_Action = flag == 0 ? "Add" : "Edit";
// // systemAuditTrail.AdtTrl_EntryId = BudgetMasterId;
// // systemAuditTrail.AdtTrl_DataDump = "BgdtMas_Id = " + GL_Master.BgdtMas_Id + ";";
// // systemAuditTrail.AdtTrl_DataDump += "BgdtMas_Code = " + GL_Master.BgdtMas_Code + ";";
// // systemAuditTrail.AdtTrl_DataDump += "BgdtMas_Date = " + GL_Master.BgdtMas_Date + ";";
// // systemAuditTrail.AdtTrl_DataDump += "Cmp_Id = " + GL_Master.Cmp_Id + ";";
// // systemAuditTrail.AdtTrl_DataDump += "Loc_Id = " + GL_Master.Loc_Id + ";";
// // systemAuditTrail.AdtTrl_DataDump += "BgdtType_Id = " + GL_Master.BgdtType_Id + ";";
// // systemAuditTrail.AdtTrl_DataDump += "BgdtMas_Remarks = " + GL_Master.BgdtMas_Remarks + ";";
// // systemAuditTrail.AdtTrl_DataDump += "BgdtMas_Status = " + GL_Master.BgdtMas_Status + ";";
// // systemAuditTrail.AdtTrl_DataDump += "VchMas_EnteredBy = " + GL_Master.VchMas_EnteredBy + ";";
// // systemAuditTrail.AdtTrl_DataDump += "VchMas_EnteredDate = " + GL_Master.VchMas_EnteredDate + ";";
// // systemAuditTrail.AdtTrl_DataDump += "VchMas_ApprovedBy = " + GL_Master.VchMas_ApprovedBy + ";";
// // systemAuditTrail.AdtTrl_DataDump += "VchMas_ApprovedDate = " + GL_Master.VchMas_ApprovedDate + ";";
// // systemAuditTrail.AdtTrl_DataDump += "SyncStatus = " + GL_Master.SyncStatus + ";";
// // foreach (GL_VchrDetail BudgetDetail in BudgetDetailList)
// // {
// // systemAuditTrail.AdtTrl_DataDump += "║ VchDet_Id = " + BudgetDetail.VchDet_Id + ";";
// // systemAuditTrail.AdtTrl_DataDump += "BgdtMas_Id = " + BudgetDetail.BgdtMas_Id + ";";
// // systemAuditTrail.AdtTrl_DataDump += "ChrtAcc_Id = " + BudgetDetail.ChrtAcc_Id + ";";
// // systemAuditTrail.AdtTrl_DataDump += "VchMas_DrAmount = " + BudgetDetail.VchMas_DrAmount + ";";
// // systemAuditTrail.AdtTrl_DataDump += "VchMas_CrAmount = " + BudgetDetail.VchMas_CrAmount + ";";
// // systemAuditTrail.AdtTrl_DataDump += "VchDet_Remarks = " + BudgetDetail.VchDet_Remarks + ";";
// // }
// // systemAuditTrail.AdtTrl_Date = DateTime.Now;
// // objAuditTrail.SaveRecord(systemAuditTrail);
// // }
// //}
// //// Audit Trail Section End
// //return PartialView("GridData");
// //string result = ViewData["BudgetId"].ToString(); //+ "|" + ViewData["BudgetCode"].ToString() + "|" + ViewData["SaveResult"].ToString();
string[] rList = new string[3];
rList[0] = BudgetMasterId;// ViewData["BudgetId"].ToString();
rList[1] = BudgetMasterCode;// ViewData["BudgetCode"].ToString();
rList[2] = li_ReturnValue.ToString();// ViewData["SaveResult"].ToString();
System.Web.Script.Serialization.JavaScriptSerializer se = new System.Web.Script.Serialization.JavaScriptSerializer();
string result = se.Serialize(rList);
return result;
}
catch
{
ViewData["SaveResult"] = 0;
//return PartialView("GridData");
return "0";
}
//return li_ReturnValue.ToString();
}
public ActionResult Temp_CopyBudget(FormCollection frm)
{
DALBudgetEntry dal_BudgetEntry = new DALBudgetEntry();
DALCalendar dal_Calendar = new DALCalendar();
GL_BgdtMaster ds_ExistingBudgetMaster;
Int64 li_BudgetTotalAmount = 0;
string ls_YearPrefix = "", ls_NewMasterId = "", ls_CurrentMasterId = "", ls_ApplicableOn = "", ls_InflateDeflate = "";
Int64 li_ApplicablePercent = 0;
try
{
ls_CurrentMasterId = frm["MasterId"];
ls_ApplicableOn = frm["rdo_BudgetActual"];
li_ApplicablePercent = Convert.ToInt32(frm["percentage"]);
ls_InflateDeflate = frm["rdo_InflateDeflate"];
if (DALCommon.AutoCodeGeneration("GL_BgdtMaster") == 1)
{
ls_YearPrefix = dal_Calendar.GetCalendarPrefix_ByCurrentDate(DateTime.Now);
ls_NewMasterId = DALCommon.GetMaxBudgetMasId(ls_YearPrefix);
}
ds_ExistingBudgetMaster = dal_BudgetEntry.GetAllMasterRecords().Where(c => c.BgdtMas_Id.Equals(ls_CurrentMasterId)).SingleOrDefault();
List<GL_BgdtDetail> SelectedBudgetDetail = new DALBudgetEntry().GetAllDetailRecords().Where(c => c.BgdtMas_Id.Equals(ls_CurrentMasterId)).ToList();
System.Data.DataSet dsBudget = new DALReports().BudgetSummary(ds_ExistingBudgetMaster.Loc_Id, 0, ds_ExistingBudgetMaster.Cldr_Id);
if (ls_ApplicableOn == "Budget")
{
li_BudgetTotalAmount = 5000;//dsBudget.Tables[0].Rows[0]["ActualBudget"] == null ? 0 : Convert.ToInt32(dsBudget.Tables[0].Rows[0]["ActualBudget"]);//Convert.ToInt32(SelectedBudgetDetail.Sum(c => c.BgdtDet_TotalAmount));
}
else
{
li_BudgetTotalAmount = 7000;//dsBudget.Tables[0].Rows[0]["ActualExpense"] == null ? 0 : Convert.ToInt32(dsBudget.Tables[0].Rows[0]["ActualExpense"]);
}
if (ls_InflateDeflate == "Inflate")
{
li_BudgetTotalAmount = li_BudgetTotalAmount + ((li_BudgetTotalAmount * li_ApplicablePercent) / 100);
}
else
{
li_BudgetTotalAmount = li_BudgetTotalAmount - ((li_BudgetTotalAmount * li_ApplicablePercent) / 100);
}
int BudgetPerMonth = Convert.ToInt32(li_BudgetTotalAmount / 12);
GL_BgdtMaster NewBudgetMaster = new GL_BgdtMaster();
NewBudgetMaster.BgdtMas_Id = ls_NewMasterId;
NewBudgetMaster.BgdtMas_Code = ls_NewMasterId;
NewBudgetMaster.BgdtMas_Date = DateTime.Now;
NewBudgetMaster.BgdtMas_Status = "Pending";
NewBudgetMaster.BgdtType_Id = ds_ExistingBudgetMaster.BgdtType_Id;
NewBudgetMaster.Cldr_Id = ds_ExistingBudgetMaster.Cldr_Id;
NewBudgetMaster.Loc_Id = ds_ExistingBudgetMaster.Loc_Id;
NewBudgetMaster.BgdtMas_Remarks = "Copy of " + ds_ExistingBudgetMaster.BgdtMas_Code + " - " + ds_ExistingBudgetMaster.BgdtMas_Remarks;
NewBudgetMaster.BgdtMas_EnteredDate = DateTime.Now;
NewBudgetMaster.BgdtMas_EnteredBy = ((SECURITY_User)Session["user"]).User_Title;
Int32 li_ReturnValue = dal_BudgetEntry.SaveBudgetMaster(NewBudgetMaster);
if (li_ReturnValue > 0)
{
foreach (GL_BgdtDetail detail in SelectedBudgetDetail)
{
String BudgetDetailCode = "";
if (String.IsNullOrEmpty(BudgetDetailCode))
{
if (DALCommon.AutoCodeGeneration("GL_BgdtDetail") == 1)
{
BudgetDetailCode = DALCommon.GetMaximumCode("GL_BgdtDetail");
}
}
GL_BgdtDetail dbDetail = new GL_BgdtDetail();
dbDetail.BgdtDet_Id = BudgetDetailCode;
dbDetail.BgdtMas_Id = ls_NewMasterId;
dbDetail.BgdtDet_Month1 = BudgetPerMonth;
dbDetail.BgdtDet_Month2 = BudgetPerMonth;
dbDetail.BgdtDet_Month3 = BudgetPerMonth;
dbDetail.BgdtDet_Month4 = BudgetPerMonth;
dbDetail.BgdtDet_Month5 = BudgetPerMonth;
dbDetail.BgdtDet_Month6 = BudgetPerMonth;
dbDetail.BgdtDet_Month7 = BudgetPerMonth;
dbDetail.BgdtDet_Month8 = BudgetPerMonth;
dbDetail.BgdtDet_Month9 = BudgetPerMonth;
dbDetail.BgdtDet_Month10 = BudgetPerMonth;
dbDetail.BgdtDet_Month11 = BudgetPerMonth;
dbDetail.BgdtDet_Month12 = BudgetPerMonth;
dbDetail.BgdtDet_TotalAmount = li_BudgetTotalAmount;
dbDetail.BgdtDet_Remarks = detail.BgdtDet_Remarks;
dbDetail.ChrtAcc_Id = detail.ChrtAcc_Id;
dal_BudgetEntry.SaveBudgetDetail(dbDetail);
}
}
return RedirectToAction("Index", "BudgetConsole", new { });
}
catch (Exception ex)
{
return null;
}
}
public string SaveBudget(SCMS.Models.BudgetMaster BudgetModel)
{
DALBudgetEntry objDalBudgetEntry = new DALBudgetEntry();
DALCalendar objDalCalendar = new DALCalendar();
GL_BgdtMaster GLBgdtMaster = new GL_BgdtMaster();
string ls_YearPrefix = "";
Int32 li_ReturnValue = 0;
String ls_BudgetMasterId = "", ls_BudgetMasterCode = "", ls_Status = "", ls_BudgetType = "", ls_Year = "", ls_LocationId = "", ls_Remarks = "",
ls_BudgetDetailId = "";
DateTime ldt_BudgetDate;
try
{
ls_BudgetMasterId = BudgetModel.MasterId;
ls_BudgetMasterCode = BudgetModel.Code.Replace("[Auto]", null);
ldt_BudgetDate = !String.IsNullOrEmpty(BudgetModel.Date) ? Convert.ToDateTime(BudgetModel.Date) : DateTime.Now;
ls_Status = BudgetModel.Status;
ls_BudgetType = BudgetModel.BudgetType;
ls_Year = BudgetModel.CalendarYear;
ls_LocationId = BudgetModel.Location;
ls_Remarks = BudgetModel.Remarks;
//ls_YearPrefix = objDalCalendar.GetCalendarPrefix_ByCurrentDate(ldt_BudgetDate);
ls_YearPrefix = objDalCalendar.GetCalendarPrefix_ByCldrId(ls_Year);
if (String.IsNullOrEmpty(ls_BudgetMasterId))
{
if (DALCommon.AutoCodeGeneration("GL_BgdtMaster") == 1)
{
if (ls_YearPrefix == null && ls_YearPrefix == "")
{
return "";
}
ls_BudgetMasterId = DALCommon.GetMaxBudgetMasId(ls_YearPrefix);
ls_BudgetMasterCode = ls_BudgetMasterId;
}
}
else
{
objDalBudgetEntry.DeleteBudgetDetail_ByBgdtMasId(ls_BudgetMasterId);
}
if (!String.IsNullOrEmpty(ls_BudgetMasterCode))
{
GLBgdtMaster.BgdtMas_Id = ls_BudgetMasterId;
GLBgdtMaster.BgdtMas_Code = ls_BudgetMasterCode;
GLBgdtMaster.BgdtMas_Date = ldt_BudgetDate;
GLBgdtMaster.BgdtMas_Status = ls_Status;
GLBgdtMaster.BgdtType_Id = ls_BudgetType;
GLBgdtMaster.Cldr_Id = ls_Year;
GLBgdtMaster.Loc_Id = ls_LocationId;
GLBgdtMaster.BgdtMas_Remarks = ls_Remarks;
GLBgdtMaster.BgdtMas_EnteredDate = DateTime.Now;
GLBgdtMaster.BgdtMas_EnteredBy = ((SECURITY_User)Session["user"]).User_Title;
li_ReturnValue = objDalBudgetEntry.SaveBudgetMaster(GLBgdtMaster);
if (li_ReturnValue > 0)
{
foreach (SCMS.Models.BudgetDetail detail in BudgetModel.ListBudgetDetail)
{
ls_BudgetDetailId = DALCommon.GetMaxBudgetDetId(ls_YearPrefix);
GL_BgdtDetail dbDetail = new GL_BgdtDetail();
dbDetail.BgdtDet_Id = ls_BudgetDetailId;
dbDetail.BgdtMas_Id = ls_BudgetMasterId;
dbDetail.ChrtAcc_Id = detail.Account;
dbDetail.BgdtDet_Month1 = detail.Month1;
dbDetail.BgdtDet_Month2 = detail.Month2;
dbDetail.BgdtDet_Month3 = detail.Month3;
dbDetail.BgdtDet_Month4 = detail.Month4;
dbDetail.BgdtDet_Month5 = detail.Month5;
dbDetail.BgdtDet_Month6 = detail.Month6;
dbDetail.BgdtDet_Month7 = detail.Month7;
dbDetail.BgdtDet_Month8 = detail.Month8;
dbDetail.BgdtDet_Month9 = detail.Month9;
dbDetail.BgdtDet_Month10 = detail.Month10;
dbDetail.BgdtDet_Month11 = detail.Month11;
dbDetail.BgdtDet_Month12 = detail.Month12;
dbDetail.BgdtDet_TotalAmount = detail.TotalAmount;
dbDetail.BgdtDet_Remarks = detail.Remarks;
objDalBudgetEntry.SaveBudgetDetail(dbDetail);
}
}
}
return ls_BudgetMasterId + ":" + ls_BudgetMasterCode;
}
catch
{
return "0";
}
}
public ActionResult CopyBudget(FormCollection frm)
{
DALBudgetEntry dal_BudgetEntry = new DALBudgetEntry();
DALCalendar dal_Calendar = new DALCalendar();
GL_BgdtMaster lst_ExistingBudgetMaster = new GL_BgdtMaster();
GL_BgdtMaster lst_NewBudgetMaster = new GL_BgdtMaster();
string ls_YearPrefix = "", ls_NewMasterId = "", ls_CurrentMasterId = "", ls_NewDetailId = "", ls_ApplicableOn = "", ls_InflateDeflate = "";
Int64 li_ReturnValue = 0, li_ApplicablePercent = 0;
decimal ldec_BudgetTotalAmount = 0, ldec_BudgetMonthlyAmount = 0;
try
{
ls_CurrentMasterId = frm["MasterId"];
ls_ApplicableOn = frm["rdo_BudgetActual"];
li_ApplicablePercent = Convert.ToInt32(frm["percentage"]);
ls_InflateDeflate = frm["rdo_InflateDeflate"];
// Getting year prefix
ls_YearPrefix = dal_Calendar.GetCalendarPrefix_ByCurrentDate(DateTime.Now);
if (DALCommon.AutoCodeGeneration("GL_BgdtMaster") == 1)
{
ls_NewMasterId = DALCommon.GetMaxBudgetMasId(ls_YearPrefix);
}
// Retrieving existing master and detail records
lst_ExistingBudgetMaster = dal_BudgetEntry.GetAllMasterRecords().Where(c => c.BgdtMas_Id.Equals(ls_CurrentMasterId)).SingleOrDefault();
List<GL_BgdtDetail> lst_ExistingBudgetDetail = dal_BudgetEntry.GetAllDetailRecords().Where(c => c.BgdtMas_Id.Equals(ls_CurrentMasterId)).ToList();
// Setting and saving of new budget master record
lst_NewBudgetMaster.BgdtMas_Id = ls_NewMasterId;
lst_NewBudgetMaster.BgdtMas_Code = ls_NewMasterId;
lst_NewBudgetMaster.BgdtMas_Date = DateTime.Now;
lst_NewBudgetMaster.BgdtMas_Status = "Pending";
lst_NewBudgetMaster.BgdtType_Id = lst_ExistingBudgetMaster.BgdtType_Id;
lst_NewBudgetMaster.Cldr_Id = lst_ExistingBudgetMaster.Cldr_Id;
lst_NewBudgetMaster.Loc_Id = lst_ExistingBudgetMaster.Loc_Id;
lst_NewBudgetMaster.BgdtMas_Remarks = "Copy of " + lst_ExistingBudgetMaster.BgdtMas_Code + " - " + lst_ExistingBudgetMaster.BgdtMas_Remarks;
lst_NewBudgetMaster.BgdtMas_EnteredDate = DateTime.Now;
lst_NewBudgetMaster.BgdtMas_EnteredBy = ((SECURITY_User)Session["user"]).User_Title;
li_ReturnValue = dal_BudgetEntry.SaveBudgetMaster(lst_NewBudgetMaster);
if (li_ReturnValue > 0)
{
foreach (GL_BgdtDetail detail in lst_ExistingBudgetDetail)
{
GL_BgdtDetail lst_NewBudgetDetail = new GL_BgdtDetail();
if (DALCommon.AutoCodeGeneration("GL_BgdtDetail") == 1)
{
ls_NewDetailId = DALCommon.GetMaxBudgetDetId(ls_YearPrefix);
}
lst_NewBudgetDetail.BgdtDet_Id = ls_NewDetailId;
lst_NewBudgetDetail.BgdtMas_Id = ls_NewMasterId;
lst_NewBudgetDetail.ChrtAcc_Id = detail.ChrtAcc_Id;
ldec_BudgetTotalAmount = 0;
if (ls_ApplicableOn == "Budget")
{
ldec_BudgetTotalAmount = Convert.ToDecimal(detail.BgdtDet_TotalAmount.ToString());
}
else
{
//li_BudgetTotalAmount = 7000;
}
if (ls_InflateDeflate == "Inflate")
{
ldec_BudgetTotalAmount = ldec_BudgetTotalAmount + ((ldec_BudgetTotalAmount * li_ApplicablePercent) / 100);
}
else
{
ldec_BudgetTotalAmount = ldec_BudgetTotalAmount - ((ldec_BudgetTotalAmount * li_ApplicablePercent) / 100);
}
ldec_BudgetMonthlyAmount = 0;
ldec_BudgetMonthlyAmount = ldec_BudgetTotalAmount / 12;
lst_NewBudgetDetail.BgdtDet_TotalAmount = ldec_BudgetTotalAmount;
lst_NewBudgetDetail.BgdtDet_Month1 = ldec_BudgetMonthlyAmount;
lst_NewBudgetDetail.BgdtDet_Month2 = ldec_BudgetMonthlyAmount;
lst_NewBudgetDetail.BgdtDet_Month3 = ldec_BudgetMonthlyAmount;
lst_NewBudgetDetail.BgdtDet_Month4 = ldec_BudgetMonthlyAmount;
lst_NewBudgetDetail.BgdtDet_Month5 = ldec_BudgetMonthlyAmount;
lst_NewBudgetDetail.BgdtDet_Month6 = ldec_BudgetMonthlyAmount;
lst_NewBudgetDetail.BgdtDet_Month7 = ldec_BudgetMonthlyAmount;
lst_NewBudgetDetail.BgdtDet_Month8 = ldec_BudgetMonthlyAmount;
lst_NewBudgetDetail.BgdtDet_Month9 = ldec_BudgetMonthlyAmount;
lst_NewBudgetDetail.BgdtDet_Month10 = ldec_BudgetMonthlyAmount;
lst_NewBudgetDetail.BgdtDet_Month11 = ldec_BudgetMonthlyAmount;
lst_NewBudgetDetail.BgdtDet_Month12 = ldec_BudgetTotalAmount - (ldec_BudgetMonthlyAmount * 11);
lst_NewBudgetDetail.BgdtDet_Remarks = detail.BgdtDet_Remarks;
dal_BudgetEntry.SaveBudgetDetail(lst_NewBudgetDetail);
}
}
return RedirectToAction("Index", "BudgetConsole", new { });
}
catch (Exception ex)
{
return null;
}
}
public ActionResult Index(string p_BudgetId)
{
string ls_Nature = "'Expense', 'Assets'";
var lst_BudgetTypes = new DALBudgetType().PopulateData();
var lst_Years = new DALCalendar().GetAllRecords();
var lst_Locations = new DALLocation().PopulateData();
var ChartOfAccounts = new DALChartOfAccount().GetChartOfAccountForDropDown(0, ls_Nature);
string ChartOfAccountCodes = "";
foreach (SETUP_ChartOfAccount COA in ChartOfAccounts)
{
if (ChartOfAccountCodes.Length > 0)
{
ChartOfAccountCodes += "|" + COA.ChrtAcc_Id + ":" + COA.ChrtAcc_Title;
}
else
{
ChartOfAccountCodes += COA.ChrtAcc_Id + ":" + COA.ChrtAcc_Title;
}
}
ViewData["ChartOfAccountCodesWithTitles"] = ChartOfAccountCodes;
SCMS.Models.BudgetMaster modelBudget = new SCMS.Models.BudgetMaster();
modelBudget.ListBudgetDetail = new List<SCMS.Models.BudgetDetail>();
if (!string.IsNullOrEmpty(p_BudgetId))
{
GL_BgdtMaster budget = new SCMSDataLayer.DALBudgetEntry().GetAllMasterRecords().Where(c => c.BgdtMas_Id.Equals(p_BudgetId)).SingleOrDefault();
modelBudget.MasterId = budget.BgdtMas_Id;
modelBudget.Code = budget.BgdtMas_Code;
modelBudget.Date = Convert.ToDateTime(budget.BgdtMas_Date).ToString("MM/dd/yyyy");
modelBudget.Status = budget.BgdtMas_Status;
modelBudget.Remarks = budget.BgdtMas_Remarks;
modelBudget.BudgetType = budget.BgdtType_Id;
modelBudget.Location = budget.Loc_Id;
modelBudget.CalendarYear = budget.Cldr_Id;
List<GL_BgdtDetail> budgetDetailList = new DALBudgetEntry().GetAllDetailRecords().Where(c => c.BgdtMas_Id.Equals(p_BudgetId)).ToList();
foreach (GL_BgdtDetail dbBudgetDetail in budgetDetailList)
{
SCMS.Models.BudgetDetail budgetDetailRow = new SCMS.Models.BudgetDetail();
budgetDetailRow.MasterId = dbBudgetDetail.BgdtMas_Id;
budgetDetailRow.DetailId = dbBudgetDetail.BgdtDet_Id;
budgetDetailRow.Month1 = dbBudgetDetail.BgdtDet_Month1;
budgetDetailRow.Month2 = dbBudgetDetail.BgdtDet_Month2;
budgetDetailRow.Month3 = dbBudgetDetail.BgdtDet_Month3;
budgetDetailRow.Month4 = dbBudgetDetail.BgdtDet_Month4;
budgetDetailRow.Month5 = dbBudgetDetail.BgdtDet_Month5;
budgetDetailRow.Month6 = dbBudgetDetail.BgdtDet_Month6;
budgetDetailRow.Month7 = dbBudgetDetail.BgdtDet_Month7;
budgetDetailRow.Month8 = dbBudgetDetail.BgdtDet_Month8;
budgetDetailRow.Month9 = dbBudgetDetail.BgdtDet_Month9;
budgetDetailRow.Month10 = dbBudgetDetail.BgdtDet_Month10;
budgetDetailRow.Month11 = dbBudgetDetail.BgdtDet_Month11;
budgetDetailRow.Month12 = dbBudgetDetail.BgdtDet_Month12;
budgetDetailRow.TotalAmount = dbBudgetDetail.BgdtDet_TotalAmount;
budgetDetailRow.Account = dbBudgetDetail.ChrtAcc_Id;
modelBudget.ListBudgetDetail.Add(budgetDetailRow);
}
}
else
{
modelBudget.Date = DateTime.Now.ToString("MM/dd/yyyy");
modelBudget.Code = "[Auto]";
SCMS.Models.BudgetDetail detail = new SCMS.Models.BudgetDetail();
modelBudget.ListBudgetDetail.Add(detail);
}
ViewData["BudgetType"] = new SelectList(lst_BudgetTypes, "BgdtType_Id", "BgdtType_Title", modelBudget.BudgetType);
ViewData["CalendarYear"] = new SelectList(lst_Years, "Cldr_Id", "Cldr_Title", modelBudget.CalendarYear);
ViewData["Location"] = new SelectList(lst_Locations, "Loc_Id", "Loc_Title", modelBudget.Location);
ViewData["ddl_Account"] = ChartOfAccounts;
return View("Budget", modelBudget);
}
