//public ActionResult Search(string ps_AllLoc, string ps_Location)
//{
// DALVoucherEntry objDal = new DALVoucherEntry();
// int li_AllLocation = -1;//, li_AllVoucherType = -1, li_AllDate = -1;
// try
// {
// if (ps_Location == null || ps_Location == "" || ps_Location == "0")
// {
// li_AllLocation = 1;
// }
// else
// {
// li_AllLocation = 0;
// }
// //if (ps_VoucherType == null || ps_VoucherType == "" || ps_VoucherType == "0")
// //{
// // li_AllVoucherType = 1;
// //}
// //else
// //{
// // li_AllVoucherType = 0;
// //}
// //if (ps_DateFrom == null || ps_DateFrom == "" || ps_DateTo == null || ps_DateTo == "")
// //{
// // li_AllDate = 1;
// //}
// //else
// //{
// // li_AllDate = 0;
// //}
// //objDal.GetVoucherEntryConsoleData(li_AllLocation, ps_Location, li_AllVoucherType, ps_VoucherType, li_AllDate, ps_DateFrom, ps_DateTo, false);
// objDal.GetVoucherEntryConsoleData(li_AllLocation, ps_Location, 1, "", 1, "", "", true);
// return PartialView("GridData");
// }
// catch
// {
// return PartialView("GridData");
// }
//}
public ActionResult DeleteRecordById(String ps_Id)
{
DALVoucherEntry objDal = new DALVoucherEntry();
String ls_Action = "Cancel", IsAuditTrail = "", ls_UserId = "";
String[] ls_Lable = new String[7], ls_Data = new String[7];
Int32 li_ReturnValue = 0;
try
{
GL_VchrMaster VoucherMasterRow = objDal.GetAllMasterRecords().Where(c => c.VchMas_Id.Equals(ps_Id)).SingleOrDefault();
List<GL_VchrDetail> VoucherDetailList = objDal.GetAllDetailRecords().Where(c => c.VchMas_Id.Equals(ps_Id)).ToList();
li_ReturnValue = objDal.DeleteRecordById(ps_Id);
ViewData["result"] = li_ReturnValue;
IsAuditTrail = System.Configuration.ConfigurationManager.AppSettings.GetValues("IsAuditTrail")[0];
// Delete 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] = "Voucher Type";
ls_Lable[4] = "Remarks";
ls_Lable[5] = "Status";
ls_Lable[6] = "Entered By";
ls_Data[0] = VoucherMasterRow.VchMas_Code;
ls_Data[1] = Convert.ToString(VoucherMasterRow.VchMas_Date);
ls_Data[2] = VoucherMasterRow.Loc_Id;
ls_Data[3] = VoucherMasterRow.VchrType_Id;
ls_Data[4] = VoucherMasterRow.VchMas_Remarks;
ls_Data[5] = VoucherMasterRow.VchMas_Status;
ls_Data[6] = VoucherMasterRow.VchMas_EnteredBy;
objAuditLog.SaveRecord(16, ls_UserId, ls_Action, ls_Lable, ls_Data);
}
// Audit Trail Section End
ViewData["ddl_Location"] = new SelectList(new DALLocation().PopulateData(), "Loc_Id", "Loc_Title");
ViewData["ddl_VoucherType"] = new SelectList(new DALVoucherType().PopulateData(), "VchrType_Id", "VchrType_Title");
ViewData["AllLoc"] = 1;
ViewData["LocationId"] = "";
ViewData["AllVchrType"] = 1;
ViewData["VoucherTypeId"] = "";
return PartialView("GridData");
}
catch
{
return PartialView("GridData");
}
}
public String GetLastRecordByVoucherTypeId(string LocationId, string VoucherTypeId)
{
var Voucher = new DALVoucherEntry().GetLastRecordByVchrType(LocationId, VoucherTypeId);
String LastVoucher = "";
if (Voucher != null && Voucher.Count > 0)
{
LastVoucher += "<div class='CustomCell' style='width: 800px; height: 30px; font-family: Tahoma;'>";
LastVoucher += "<b>Voucher # : </b>";
LastVoucher += Voucher.Last().VchMas_Code;
LastVoucher += "<b>, Date : </b>";
LastVoucher += Voucher.Last().VchMas_Date != null ? Convert.ToDateTime(Voucher.Last().VchMas_Date).ToShortDateString() : "";
LastVoucher += "<b>, Status : </b>";
LastVoucher += Voucher.Last().VchMas_Status;
LastVoucher += "</div>";
LastVoucher += "<div class='Clear' style='border-bottom: 1px solid #ccc; margin-bottom: 5px;'>";
LastVoucher += "</div>";
}
return LastVoucher;
}
public ActionResult VoucherEntry(String VoucherId)
{
DALVoucherEntry objDalVoucherEntry = new DALVoucherEntry();
var VoucherTypes = new DALVoucherType().GetAllData();
var Locations = new DALLocation().PopulateData();
var Voucher = new DALVoucherEntry().GetAllMasterRecords();
ViewData["ddl_VoucherType"] = new SelectList(VoucherTypes, "VchrType_Id", "VchrType_Title", Session["VoucherTypeForVoucherEntry"]);
var ChartOfAccounts = new DALChartOfAccount().GetChartOfAccountForDropDown(1, "''");
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;
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 DALVoucherTypeNarration().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["LocationIdForVoucherEntry"]);
if (!String.IsNullOrEmpty(VoucherId))
{
SetVoucherEntryToEdit(VoucherId);
}
else
{
ViewData["VoucherCode"] = "[Auto]";
ViewData["CurrentDate"] = DateTime.Now.ToString("MM/dd/yyyy");
}
Session.Remove("VoucherTypeForVoucherEntry");
Session.Remove("LocationIdForVoucherEntry");
return View();
}
public void SetVoucherEntryToEdit(String VoucherId)
{
var VoucherEntryRow = new DALVoucherEntry().GetAllMasterRecords().Where(c => c.VchMas_Id.Equals(VoucherId)).SingleOrDefault();
if (VoucherEntryRow != null)
{
ViewData["VoucherCode"] = VoucherEntryRow.VchMas_Code;
ViewData["VoucherId"] = VoucherEntryRow.VchMas_Id;
ViewData["CurrentDate"] = Convert.ToDateTime(VoucherEntryRow.VchMas_Date).ToString("MM/dd/yyyy");
ViewData["Status"] = VoucherEntryRow.VchMas_Status;
ViewData["VoucherType"] = VoucherEntryRow.VchrType_Id;
ViewData["LocationId"] = VoucherEntryRow.Loc_Id;
ViewData["Remarks"] = VoucherEntryRow.VchMas_Remarks;
var VoucherDetailRows = new DALVoucherEntry().GetAllDetailRecords().Where(c => c.VchMas_Id.Equals(VoucherId)).ToList().OrderBy(c => c.VchDet_Id).ToList();
ViewData["DetailRecords"] = VoucherDetailRows;
ViewData["Edit"] = "OK";
}
}
public string SaveVoucher(IEnumerable<string> VoucherDetailRows)
{
String[] MasterRow = VoucherDetailRows.Last().Split('║');
String VoucherMasterId = MasterRow[0];
String VoucherMasterCode = MasterRow[6].Replace("[Auto]", null);
DateTime VoucherDate = MasterRow[1] != null ? Convert.ToDateTime(MasterRow[1]) : DateTime.Now;
string Status = MasterRow[2];
String VoucherType = MasterRow[3];
String LocationId = MasterRow[4];
String Remarks = MasterRow[5];
string ls_VchrTypId = "", ls_YearPrefix = "";
Session["VoucherTypeForVoucherEntry"] = VoucherType;
Session["LocationIdForVoucherEntry"] = LocationId;
DALVoucherEntry objDalVoucherEntry = new DALVoucherEntry();
DALCalendar objDalCalendar = new DALCalendar();
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, Increment = 5;
try
{
GL_VchrMaster GL_Master = new GL_VchrMaster();
GL_VchrDetail GL_Detail = new GL_VchrDetail();
String Prefix = new DALVoucherType().GetAllData().Where(c => c.VchrType_Id.Equals(VoucherType)).SingleOrDefault().VchrType_Prefix;
ls_VchrTypId = Convert.ToString(Convert.ToInt32(VoucherType));
if (String.IsNullOrEmpty(VoucherMasterId))
{
if (DALCommon.AutoCodeGeneration("GL_VchrMaster") == 1)
{
ls_YearPrefix = objDalCalendar.GetCalendarPrefix_ByCurrentDate(VoucherDate);
if (ls_YearPrefix == null && ls_YearPrefix == "")
{
return "";
}
VoucherMasterId = DALCommon.GetMaxVoucherId(ls_YearPrefix);
VoucherMasterCode = DALCommon.GetMaxVoucherCode("GL_VchrMaster", VoucherType, Prefix, LocationId, ls_YearPrefix);
ls_Action = "Add";
}
}
else
{
flag = 1;
}
List<GL_VchrDetail> VoucherDetailList = new List<GL_VchrDetail>();
if (!String.IsNullOrEmpty(VoucherMasterId) && !String.IsNullOrEmpty(VoucherMasterCode))
{
GL_Master.VchMas_Id = VoucherMasterId;
ViewData["VoucherId"] = VoucherMasterId;
GL_Master.VchMas_Code = VoucherMasterCode;
ViewData["VoucherCode"] = VoucherMasterCode;
GL_Master.VchMas_Date = VoucherDate;
GL_Master.Loc_Id = LocationId;
GL_Master.VchrType_Id = VoucherType;
GL_Master.VchMas_Remarks = Remarks;
GL_Master.VchMas_Status = Status;
GL_Master.VchMas_EnteredBy = ((SECURITY_User)Session["user"]).User_Title;
GL_Master.VchMas_EnteredDate = DateTime.Now;
li_ReturnValue = objDalVoucherEntry.SaveVoucherMaster(GL_Master);
if (li_ReturnValue > 0)
{
if (flag == 1)
{
objDalVoucherEntry.DeleteDetailRecordByMasterId(VoucherMasterId);
}
for (int index = 0; index < VoucherDetailRows.ToList().Count - 1; index++)
{
string Row = VoucherDetailRows.ToList()[index];
String[] Columns = Row.Split('║');
String VoucherDetailCode = "";
if (String.IsNullOrEmpty(VoucherDetailCode))
{
if (DALCommon.AutoCodeGeneration("GL_VchrDetail") == 1)
{
VoucherDetailCode = DALCommon.GetMaximumCode("GL_VchrDetail");
//VoucherDetailCode = VoucherMasterCode;
}
}
if (!String.IsNullOrEmpty(VoucherDetailCode) && 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 = VoucherDetailCode;
GL_Detail.VchMas_Id = VoucherMasterId;
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
objDalVoucherEntry.SaveVoucherDetail(GL_Detail);
VoucherDetailList.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] = "Voucher Type";
ls_Lable[4] = "Remarks";
ls_Lable[5] = "Status";
ls_Data[0] = VoucherMasterCode;
ls_Data[1] = VoucherDate.ToString("dd/MM/yyyy");
ls_Data[2] = LocationId;
ls_Data[3] = VoucherType;
ls_Data[4] = Remarks;
ls_Data[5] = Status;
foreach (GL_VchrDetail voucherDetail in VoucherDetailList)
{
Increment++;
ls_Lable[Increment] = "Account Code";
ls_Data[Increment] = voucherDetail.ChrtAcc_Id;
Increment++;
ls_Lable[Increment] = "Debit";
ls_Data[Increment] = Convert.ToString(voucherDetail.VchMas_DrAmount);
Increment++;
ls_Lable[Increment] = "Credit";
ls_Data[Increment] = Convert.ToString(voucherDetail.VchMas_CrAmount);
Increment++;
ls_Lable[Increment] = "Narration";
ls_Data[Increment] = voucherDetail.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.VchrType_Id = GL_Master.VchrType_Id;
// systemAuditTrail.AdtTrl_Action = flag == 0 ? "Add" : "Edit";
// systemAuditTrail.AdtTrl_EntryId = VoucherMasterId;
// systemAuditTrail.AdtTrl_DataDump = "VchMas_Id = " + GL_Master.VchMas_Id + ";";
// systemAuditTrail.AdtTrl_DataDump += "VchMas_Code = " + GL_Master.VchMas_Code + ";";
// systemAuditTrail.AdtTrl_DataDump += "VchMas_Date = " + GL_Master.VchMas_Date + ";";
// systemAuditTrail.AdtTrl_DataDump += "Cmp_Id = " + GL_Master.Cmp_Id + ";";
// systemAuditTrail.AdtTrl_DataDump += "Loc_Id = " + GL_Master.Loc_Id + ";";
// systemAuditTrail.AdtTrl_DataDump += "VchrType_Id = " + GL_Master.VchrType_Id + ";";
// systemAuditTrail.AdtTrl_DataDump += "VchMas_Remarks = " + GL_Master.VchMas_Remarks + ";";
// systemAuditTrail.AdtTrl_DataDump += "VchMas_Status = " + GL_Master.VchMas_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 voucherDetail in VoucherDetailList)
// {
// systemAuditTrail.AdtTrl_DataDump += "║ VchDet_Id = " + voucherDetail.VchDet_Id + ";";
// systemAuditTrail.AdtTrl_DataDump += "VchMas_Id = " + voucherDetail.VchMas_Id + ";";
// systemAuditTrail.AdtTrl_DataDump += "ChrtAcc_Id = " + voucherDetail.ChrtAcc_Id + ";";
// systemAuditTrail.AdtTrl_DataDump += "VchMas_DrAmount = " + voucherDetail.VchMas_DrAmount + ";";
// systemAuditTrail.AdtTrl_DataDump += "VchMas_CrAmount = " + voucherDetail.VchMas_CrAmount + ";";
// systemAuditTrail.AdtTrl_DataDump += "VchDet_Remarks = " + voucherDetail.VchDet_Remarks + ";";
// }
// systemAuditTrail.AdtTrl_Date = DateTime.Now;
// objAuditTrail.SaveRecord(systemAuditTrail);
// }
//}
//// Audit Trail Section End
//return PartialView("GridData");
//string result = ViewData["VoucherId"].ToString(); //+ "|" + ViewData["VoucherCode"].ToString() + "|" + ViewData["SaveResult"].ToString();
string[] rList = new string[3];
rList[0] = ViewData["VoucherId"].ToString();
rList[1] = ViewData["VoucherCode"].ToString();
rList[2] = 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";
}
}