private string SaveItemSSGrp(VMMasterForm MstrInf)
{
var DesigCode = _designationService.All().ToList().FirstOrDefault(x => x.DesigCode == MstrInf.Code);
if (DesigCode == null)
{
Designation _desig = new Designation();
_desig.DesigCode = MstrInf.Code;
_desig.DesigName = MstrInf.Name;
_desig.DesigLocalName = MstrInf.LocalName;
_desig.DesigDesc = MstrInf.Descr;
_designationService.Add(_desig);
_designationService.Save();
var DesigID = _desig.DesigID;
TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "SaveDesignationInfo",
DesigID.ToString(), Session["UserName"].ToString());
return("1");
}
else
{
return("2");
}
}
private string SaveBranchInfo(VMMasterForm MstrInf)
{
var BrCode = _brInfoService.All().ToList().FirstOrDefault(x => x.BranchCode == MstrInf.Code);
if (BrCode == null)
{
Branch _brInfo = new Branch();
_brInfo.BranchCode = MstrInf.Code;
_brInfo.BranchName = MstrInf.Name;
_brInfo.BrLocalName = MstrInf.LocalName;
_brInfo.BrAddress = MstrInf.Descr;
_brInfoService.Add(_brInfo);
_brInfoService.Save();
var BrID = _brInfo.BrID;
TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "SaveBranchInfo",
BrID.ToString(), Session["UserName"].ToString());
return("1");
}
else
{
return("2");
}
}
private string SaveUnitInfo(VMMasterForm MstrInf)
{
var UnitCode = _unitInfoService.All().ToList().FirstOrDefault(x => x.UnitCode == MstrInf.Code);
if (UnitCode == null)
{
UnitInfo _unit = new UnitInfo();
_unit.UnitCode = MstrInf.Code;
_unit.UnitName = MstrInf.Name;
_unit.UnitLocalName = MstrInf.LocalName;
_unit.UnitDesc = MstrInf.Descr;
_unitInfoService.Add(_unit);
_unitInfoService.Save();
var UnitID = _unit.UnitID;
TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "SaveUnitInfo",
UnitID.ToString(), Session["UserName"].ToString());
return("1");
}
else
{
return("2");
}
}
private string UpdateLocationInfo(VMMasterForm MstrInf)
{
var LocInfo = _LocationService.All().ToList().FirstOrDefault(x => x.LocId == MstrInf.ID);
if (LocInfo != null)
{
var DsgInfList = _LocationService.All().ToList().Where(c => c.LocId != MstrInf.ID).ToList();
var IsCodExst = DsgInfList.FirstOrDefault(x => x.LocCode == MstrInf.Code);
if (IsCodExst == null)
{
LocInfo.LocName = MstrInf.Name;
_LocationService.Update(LocInfo);
_LocationService.Save();
var DesigID = LocInfo.LocCode;
TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "UpdateDesignationInfo",
DesigID, Session["UserName"].ToString());
return("1");
}
else
{
return("3");
}
}
else
{
return("2");
}
}
private string SaveProjectInfo(VMMasterForm MstrInf)
{
var ProjCode = _projInfoService.All().ToList().FirstOrDefault(x => x.ProjCode == MstrInf.Code);
if (ProjCode == null)
{
ProjInfo _proj = new ProjInfo();
_proj.ProjCode = MstrInf.Code;
_proj.ProjName = MstrInf.Name;
_proj.ProjLocalName = MstrInf.LocalName;
_proj.ProjDescrip = MstrInf.Descr;
_projInfoService.Add(_proj);
_projInfoService.Save();
var ProjID = _proj.ProjID;
TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "SaveProjectInfo",
ProjID.ToString(), Session["UserName"].ToString());
return("1");
}
else
{
return("2");
}
}
public ActionResult UpdateOpenBalance(OpenBal OpnBal)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("GL_OpenBal_Update"))
{
return(Json("U", JsonRequestBehavior.AllowGet));
}
var defAc = LoadDropDown.GetDefAc();
string eCode = "";
string isAsset = OpnBal.Accode.Substring(0, 1);
if (isAsset == defAc.AssAc)
{
OpnBal.OpenBalance = OpnBal.OpenBalance;
}
else if (isAsset == defAc.LiaAc)
{
OpnBal.OpenBalance = OpnBal.OpenBalance * (-1);
}
using (var transaction = new TransactionScope())
{
try
{
OpenBal UpOpnBal = new OpenBal();
UpOpnBal = _pR_OpenBalanceService.All().ToList().FirstOrDefault(x => x.Id == OpnBal.Id);
if (UpOpnBal != null)
{
OpnBal.FinYear = Session["FinYear"].ToString();
Misclns.CopyPropertiesTo(OpnBal, UpOpnBal);
_pR_OpenBalanceService.Update(UpOpnBal);
_pR_OpenBalanceService.Save();
var THolidayID = UpOpnBal.Id;
TransactionLogService.SaveTransactionLog(_transactionLogService, "OpenBal", "Update",
THolidayID.ToString(), Session["UserName"].ToString());
eCode = "1";
}
else
{
eCode = "2";
}
transaction.Complete();
return(Json(eCode, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult SaveVM_Adjustment(VM_Adjustment VM_Adjustment)
{
try
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("VMAdjustment_Insert"))
{
return(Json("X", JsonRequestBehavior.AllowGet));
}
string content = "An error occured during the save.";
var serSettings = new JsonSerializerSettings {
PreserveReferencesHandling = PreserveReferencesHandling.Objects
};
string jsonCov = JsonConvert.SerializeObject(VM_Adjustment, Formatting.Indented, serSettings);
HttpResponseMessage response = GlobalVariabls.VatApiClient.PostAsJsonAsync("VM_Adjustment/PostVM_Adjustment", VM_Adjustment).Result;
content = response.StatusCode.ToString();
if (content == "OK")
{
TransactionLogService.SaveTransactionLog(_transactionLogService, "VDS Payment", "Save", VM_Adjustment.AdjNo, Session["UserName"].ToString());
return(Json("1", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(ex.ToString(), JsonRequestBehavior.AllowGet));
}
}
public ActionResult UpdateVM_TrDep(VM_TrDep VM_TrDep)
{
try
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("TreasuryChallan_Update"))
{
return(Json("U", JsonRequestBehavior.AllowGet));
}
string content = "An error occured during the update.";
var serializerSettings = new JsonSerializerSettings {
PreserveReferencesHandling = PreserveReferencesHandling.Objects
};
string json = JsonConvert.SerializeObject(VM_TrDep, Formatting.Indented, serializerSettings);
HttpResponseMessage response = GlobalVariabls.VatApiClient.PutAsJsonAsync("VM_TrDep/PutVM_TrDep", VM_TrDep).Result;
content = response.StatusCode.ToString();
if (content == "OK")
{
TransactionLogService.SaveTransactionLog(_transactionLogService, "VM Treasury Challan", "Update", VM_TrDep.TrDepNo, Session["UserName"].ToString());
return(Json("1", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(ex.ToString(), JsonRequestBehavior.AllowGet));
}
}
public ActionResult PostCancel(string InvoiceNo, string CancelType)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("MRCancel"))
{
return(Json("C", JsonRequestBehavior.AllowGet));
}
string ReturnSTR = "";
using (AcclineERPContext dbContext = new AcclineERPContext())
{
var resultParameter = new SqlParameter("@ReturnMSG", SqlDbType.VarChar, 300)
{
Direction = ParameterDirection.Output
};
dbContext.Database.ExecuteSqlCommand("MRCancel @MRNo, @ReturnMSG out",
new SqlParameter("@MRNo", InvoiceNo),
resultParameter);
ReturnSTR = (string)resultParameter.Value;
TransactionLogService.SaveTransactionLog(_transactionLogService, "Cancel", "MRCancel",
InvoiceNo, Session["UserName"].ToString());
}
return(Json(ReturnSTR, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteRateChart(int Id)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("GL_OpenBal_Delete"))
{
return(Json("D", JsonRequestBehavior.AllowGet));
}
using (var transaction = new TransactionScope())
{
try
{
var IsExist = _RateChartService.All().ToList().FirstOrDefault(x => x.RateChartId == Id);
if (IsExist != null)
{
_RateChartService.Delete(IsExist);
_RateChartService.Save();
TransactionLogService.SaveTransactionLog(_transactionLogService, "RateChart", "Delete",
Session["UserName"].ToString(), Session["FinYear"].ToString());
}
else
{
return(Json("2", JsonRequestBehavior.AllowGet));
}
transaction.Complete();
return(Json("1", JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
private string SaveDepartmentInfo(VMMasterForm MstrInf)
{
var DeptCode = _departmentService.All().ToList().FirstOrDefault(x => x.DeptCode == MstrInf.Code);
if (DeptCode == null)
{
Department _dept = new Department();
_dept.DeptCode = MstrInf.Code;
_dept.DeptName = MstrInf.Name;
_dept.DeptLocalName = MstrInf.LocalName;
_dept.DeptDesc = MstrInf.Descr;
_departmentService.Add(_dept);
_departmentService.Save();
var DeptID = _dept.DeptID;
TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "SaveDepartmentInfo",
DeptID.ToString(), Session["UserName"].ToString());
return("1");
}
else
{
return("2");
}
}
public ActionResult SaveItem(ItemInfo item)
{
//if (ModelState.IsValid)
//{
using (var transaction = new TransactionScope())
{
try
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("Item_Insert"))
{
return(Json("X", JsonRequestBehavior.AllowGet));
}
var items = _ItemInfoService.All().ToList().FirstOrDefault(x => x.ItemCode == item.ItemCode && x.ItemName == item.ItemName);
if (items == null)
{
_ItemInfoService.Add(item);
ItemMap iM = new ItemMap();
iM.ItemTypeCode = (int)item.ItemType;
iM.GroupID = item.GroupID;
iM.SGroupID = item.SGroupID;
iM.SSGroupID = item.SSGroupID;
iM.ItemCode = item.ItemCode;
var serializerSettings = new JsonSerializerSettings {
PreserveReferencesHandling = PreserveReferencesHandling.Objects
};
string json = JsonConvert.SerializeObject(iM, Formatting.Indented, serializerSettings);
HttpResponseMessage response = GlobalVariabls.WebApiClient.PostAsJsonAsync("ItemMaps/PostItemMap", iM).Result;
_ItemInfoService.Save();
TransactionLogService.SaveTransactionLog(_transactionLogService, "Item", "Save", item.ItemCode, Session["UserName"].ToString());
transaction.Complete();
return(Json("1", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("Item already exists!!!", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
//}
//else
//{
// return Json("0", JsonRequestBehavior.AllowGet);
//}
}
}
public ActionResult UpdateBankReceipt(BankReceipt bankReceipt)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("BankReceipt_Update"))
{
return(Json("U", JsonRequestBehavior.AllowGet));
}
List <BankOperationVModel> CashOPVM = new List <BankOperationVModel>();
var gset = _gsetService.All().LastOrDefault();
try
{
bankReceipt.BranchCode = Session["BranchCode"].ToString();
bankReceipt.FinYear = Session["FinYear"].ToString();
bankReceipt.bankAccode = Session["BankAccode"].ToString();
bankReceipt.NewChart = _NewChartService.All().ToList().FirstOrDefault(x => x.Accode == bankReceipt.purAccode.Trim());
bankReceipt.bankNewChart = _NewChartService.All().ToList().FirstOrDefault(x => x.Accode == bankReceipt.bankAccode.Trim());
using (var transaction = new TransactionScope())
{
try
{
_BankReceiptAppService.Update(bankReceipt);
_BankReceiptAppService.Save();
//delete to provision
//var entryNo = Convert.ToInt64(bankReceipt.VoucherNo.Substring(2, 8)).ToString().PadLeft(8, '0');
var entryNo = bankReceipt.BReceiptNo;
LoadDropDown.journalVoucherRemoval("BR", entryNo, bankReceipt.VoucherNo, bankReceipt.FinYear);
var sysSet = _sysSetService.All().FirstOrDefault();
if (sysSet.CashRule == "O")
{
LoadDropDown.journalVoucherSave("BR", "I", bankReceipt.BReceiptNo, bankReceipt.VoucherNo, bankReceipt.FinYear, "01", bankReceipt.BranchCode, bankReceipt.BReceiptDate, bankReceipt.bankAccode, Session["UserName"].ToString());
}
//insert to provision
LoadDropDown.journalVoucherSave("BR", "I", bankReceipt.BReceiptNo, bankReceipt.VoucherNo, bankReceipt.FinYear, "01", bankReceipt.BranchCode, bankReceipt.BReceiptDate, bankReceipt.bankAccode, Session["UserName"].ToString());
TransactionLogService.SaveTransactionLog(_transactionLogService, "Bank Receipt", "Update", bankReceipt.BReceiptNo, User.Identity.Name);
CashOPVM = GetAllRemittances(bankReceipt.BReceiptDate, bankReceipt.BranchCode, bankReceipt.bankAccode);
transaction.Complete();
}
catch (Exception)
{
transaction.Dispose();
}
}
return(Json(CashOPVM, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetBackupDB()
{
if (Session["UserID"] != null)
{
// read connectionstring from config file
var connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
// read backup folder from config file ("C:/BackupDB/")
var backupFolder = ConfigurationManager.AppSettings["BackupFolder"];
var sqlConStrBuilder = new SqlConnectionStringBuilder(connectionString);
// set backupfilename (you will get something like: "C:/temp/MyDatabase-2013-12-07.bak")
var backupFileName = String.Format("{0}{1}-{2}.bak", backupFolder, sqlConStrBuilder.InitialCatalog, DateTime.Now.ToString("yyyy-MM-dd"));
using (var connection = new SqlConnection(sqlConStrBuilder.ConnectionString))
{
var query = String.Format("BACKUP DATABASE {0} TO DISK='{1}'",
sqlConStrBuilder.InitialCatalog, backupFileName);
using (var command = new SqlCommand(query, connection))
{
connection.Open();
command.ExecuteNonQuery();
}
}
string PhyscPath = backupFileName;
try
{
byte[] fileByte = System.IO.File.ReadAllBytes(PhyscPath);
string DownFileName = String.Format("{0}_{1}.bak", sqlConStrBuilder.InitialCatalog,
DateTime.Now.ToString("yyyy-MM-dd"));
TransactionLogService.SaveTransactionLog(_transactionLogService, "BackupDB", "", "01", Session["UserName"].ToString());
return(File(fileByte, System.Net.Mime.MediaTypeNames.Application.Octet, DownFileName));
}
catch (Exception)
{
return(RedirectToAction("BackupDB", "BackupDB"));
}
finally
{
System.IO.File.Delete(backupFileName);
}
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult Save(RateChart RateChart)
{
//RBACUser rUser = new RBACUser(Session["UserName"].ToString());
//if (!rUser.HasPermission(""))
//{
// return Json("X", JsonRequestBehavior.AllowGet);
//}
string eCode = "";
using (var transaction = new TransactionScope())
{
try
{
// query for check existing data and then if null go to transaction
var objRateChart = _RateChartService.All().ToList()
.Where(x => x.ItemCode == RateChart.ItemCode && x.CustCode == RateChart.CustCode).ToList();
//if (objRateChart.Count == 0)
if (objRateChart.Count == 0)
{
RateChart SaveRateChart = new RateChart();
Misclns.CopyPropertiesTo(RateChart, SaveRateChart);
_RateChartService.Add(SaveRateChart);
_RateChartService.Save();
TransactionLogService.SaveTransactionLog(_transactionLogService, "RateChart", "Save",
DateTime.Now.ToString(), Session["UserName"].ToString());
eCode = "1";
}
else
{
eCode = "2";
}
transaction.Complete();
return(Json(eCode, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult UpdateHOR(HORemit hoRemit)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("Remittance_Update"))
{
return(Json("U", JsonRequestBehavior.AllowGet));
}
List <BankOperationVModel> CashOPVM = new List <BankOperationVModel>();
var gset = _gsetService.All().LastOrDefault();
try
{
hoRemit.BranchCode = Session["BranchCode"].ToString();
hoRemit.FinYear = Session["FinYear"].ToString();
hoRemit.bankAccode = Session["BankAccode"].ToString();
using (var transaction = new TransactionScope())
{
try
{
_hoRemitService.Update(hoRemit);
_hoRemitService.Save();
//Delete to provition
// var entryNo = Convert.ToInt64(hoRemit.VoucherNo.Substring(2, 8)).ToString().PadLeft(8, '0');
var entryNo = hoRemit.RemitNo;
LoadDropDown.journalVoucherRemoval("RT", entryNo, hoRemit.VoucherNo, hoRemit.FinYear);
//Insert to provision
LoadDropDown.journalVoucherSave("RT", "I", hoRemit.RemitNo, hoRemit.VoucherNo, hoRemit.FinYear, "01", hoRemit.BranchCode, hoRemit.RemitDate, gset.GCA_HO, Session["UserName"].ToString());
TransactionLogService.SaveTransactionLog(_transactionLogService, "HORemittance", "Update", hoRemit.RemitNo, User.Identity.Name);
CashOPVM = GetAllRemittances(hoRemit.RemitDate, hoRemit.BranchCode, hoRemit.bankAccode);
transaction.Complete();
}
catch (Exception)
{
transaction.Dispose();
}
}
return(Json(CashOPVM, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteMasterRecord(string Type, string DeleteID)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("MasterInformation_Delete"))
{
return(Json("D", JsonRequestBehavior.AllowGet));
}
using (var transaction = new TransactionScope())
{
try
{
//DeleteMemberImages(MemberId);
int DelStatus = 0;
using (AcclineERPContext dbContext = new AcclineERPContext())
{
var resultParameter = new SqlParameter("@Result", SqlDbType.Int)
{
Direction = ParameterDirection.Output
};
dbContext.Database.ExecuteSqlCommand("MasterRecordDelete @Type, @DeleteID, @Result out",
new SqlParameter("@Type", Type),
new SqlParameter("@DeleteID", DeleteID),
resultParameter);
DelStatus = (int)resultParameter.Value;
TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "Delete",
string.Empty, Session["UserName"].ToString());
}
transaction.Complete();
return(Json(DelStatus, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult UpdateItem(ItemInfo item)
{
using (var transaction = new TransactionScope())
{
try
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("Item_Update"))
{
return(Json("U", JsonRequestBehavior.AllowGet));
}
_ItemInfoService.Update(item);
_ItemInfoService.Save();
TransactionLogService.SaveTransactionLog(_transactionLogService, "Item", "Update", item.ItemCode, Session["UserName"].ToString());
ItemMap ItemMap = new ItemMap();
ItemMap.Id = item.Id;
ItemMap.ItemTypeCode = (int)item.ItemType;
ItemMap.GroupID = item.GroupID;
ItemMap.SGroupID = item.SGroupID;
ItemMap.SSGroupID = item.SSGroupID;
ItemMap.ItemCode = item.ItemCode;
var serializerSettings = new JsonSerializerSettings {
PreserveReferencesHandling = PreserveReferencesHandling.Objects
};
string json = JsonConvert.SerializeObject(ItemMap, Formatting.Indented, serializerSettings);
HttpResponseMessage response = GlobalVariabls.WebApiClient.PutAsJsonAsync("ItemMaps/" + item.Id, ItemMap).Result;
transaction.Complete();
return(Json("1", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult SaveVat4P3(Vat4P3 Vat4P3, List <CM_Ingredient> CMIngredient, List <CM_CostExp> CMCostExp)
{
try
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("CostSheet_Insert"))
{
return(Json("X", JsonRequestBehavior.AllowGet));
}
#region For VAT VM_4P3
VM_4P3VM VM_4P3VM = new VM_4P3VM();
VM_4P3VM.VM_4P3 = Vat4P3;
VM_4P3VM.CM_CostExp = CMCostExp;
VM_4P3VM.CM_Ingredient = CMIngredient;
string content = "An error occured during the save.";
var serSettings = new JsonSerializerSettings {
PreserveReferencesHandling = PreserveReferencesHandling.Objects
};
string jsonCov = JsonConvert.SerializeObject(VM_4P3VM, Formatting.Indented, serSettings);
HttpResponseMessage response = GlobalVariabls.VatApiClient.PostAsJsonAsync("VM_4P3/PostVM_4P3", VM_4P3VM).Result;
content = response.StatusCode.ToString();
if (content == "OK")
{
TransactionLogService.SaveTransactionLog(_transactionLogService, "Vat 4.3", "Save", Vat4P3.DeclarationNo, Session["UserName"].ToString());
return(Json(new { Msg = "1", returnValue = "4.3;" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
#endregion
}
catch (Exception ex)
{
return(Json(ex.ToString(), JsonRequestBehavior.AllowGet));
}
}
private string UpdateDesignationInfo(VMMasterForm MstrInf)
{
var DesigInfo = _designationService.All().ToList().FirstOrDefault(x => x.DesigID == MstrInf.ID);
if (DesigInfo != null)
{
var DsgInfList = _designationService.All().ToList().Where(c => c.DesigID != MstrInf.ID).ToList();
var IsCodExst = DsgInfList.FirstOrDefault(x => x.DesigCode == MstrInf.Code);
if (IsCodExst == null)
{
DesigInfo.DesigCode = MstrInf.Code;
DesigInfo.DesigName = MstrInf.Name;
DesigInfo.DesigLocalName = MstrInf.LocalName;
DesigInfo.DesigDesc = MstrInf.Descr;
_designationService.Update(DesigInfo);
_designationService.Save();
var DesigID = DesigInfo.DesigID;
TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "UpdateDesignationInfo",
DesigID.ToString(), Session["UserName"].ToString());
return("1");
}
else
{
return("3");
}
}
else
{
return("2");
}
}
private string UpdateBranchInfo(VMMasterForm MstrInf)
{
var BrInfo = _brInfoService.All().ToList().FirstOrDefault(x => x.BrID == MstrInf.ID);
if (BrInfo != null)
{
var BInfList = _brInfoService.All().ToList().Where(c => c.BrID != MstrInf.ID).ToList();
var IsCodExst = BInfList.FirstOrDefault(x => x.BranchCode == MstrInf.Code);
if (IsCodExst == null)
{
//BrInfo.BranchCode = MstrInf.Code;
BrInfo.BranchName = MstrInf.Name;
BrInfo.BrLocalName = MstrInf.LocalName;
BrInfo.BrAddress = MstrInf.Descr;
_brInfoService.Update(BrInfo);
_brInfoService.Save();
var BrID = BrInfo.BrID;
TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "UpdateBranchInfo",
BrID.ToString(), Session["UserName"].ToString());
return("1");
}
else
{
return("3");
}
}
else
{
return("2");
}
}
private string UpdateProjectInfo(VMMasterForm MstrInf)
{
var ProjInfo = _projInfoService.All().ToList().FirstOrDefault(x => x.ProjID == MstrInf.ID);
if (ProjInfo != null)
{
var PInfList = _projInfoService.All().ToList().Where(c => c.ProjID != MstrInf.ID).ToList();
var IsCodExst = PInfList.FirstOrDefault(x => x.ProjCode == MstrInf.Code);
if (IsCodExst == null)
{
ProjInfo.ProjCode = MstrInf.Code;
ProjInfo.ProjName = MstrInf.Name;
ProjInfo.ProjLocalName = MstrInf.LocalName;
ProjInfo.ProjDescrip = MstrInf.Descr;
_projInfoService.Update(ProjInfo);
_projInfoService.Save();
var ProjID = ProjInfo.ProjID;
TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "UpdateProjectInfo",
ProjID.ToString(), Session["UserName"].ToString());
return("1");
}
else
{
return("3");
}
}
else
{
return("2");
}
}
public ActionResult DeleteVM_BIN(int Id)
{
//RBACUser rUser = new RBACUser(Session["UserName"].ToString());
//if (!rUser.HasPermission("GL_VM_BIN_Delete"))
//{
// return Json("D", JsonRequestBehavior.AllowGet);
//}
using (var transaction = new TransactionScope())
{
try
{
var IsExist = _pR_VM_BINService.All().ToList().FirstOrDefault(x => x.Id == Id);
if (IsExist != null)
{
_pR_VM_BINService.Delete(IsExist);
_pR_VM_BINService.Save();
var HDHolidayID = 1;
TransactionLogService.SaveTransactionLog(_transactionLogService, "SaveVM_BIN", "Delete", HDHolidayID.ToString(), Session["UserName"].ToString());
}
else
{
return(Json("2", JsonRequestBehavior.AllowGet));
}
transaction.Complete();
return(Json("1", JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
private string SaveLocInfo(VMMasterForm MstrInf)
{
var LocCode = _LocationService.All().ToList().FirstOrDefault(x => x.LocCode == MstrInf.Code);
if (LocCode == null)
{
Location _Loc = new Location();
_Loc.LocCode = MstrInf.Code;
_Loc.LocName = MstrInf.Name;
_LocationService.Add(_Loc);
_LocationService.Save();
TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "SaveDesignationInfo",
_Loc.LocCode, Session["UserName"].ToString());
return("1");
}
else
{
return("2");
}
}
private string UpdateUnitInfo(VMMasterForm MstrInf)
{
var UnitInfo = _unitInfoService.All().ToList().FirstOrDefault(x => x.UnitID == MstrInf.ID);
if (UnitInfo != null)
{
var UInfList = _unitInfoService.All().ToList().Where(c => c.UnitID != MstrInf.ID).ToList();
var IsCodExst = UInfList.FirstOrDefault(x => x.UnitCode == MstrInf.Code);
if (IsCodExst == null)
{
UnitInfo.UnitCode = MstrInf.Code;
UnitInfo.UnitName = MstrInf.Name;
UnitInfo.UnitLocalName = MstrInf.LocalName;
UnitInfo.UnitDesc = MstrInf.Descr;
_unitInfoService.Update(UnitInfo);
_unitInfoService.Save();
var UnitID = UnitInfo.UnitID;
TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "UpdateUnitInfo",
UnitID.ToString(), Session["UserName"].ToString());
return("1");
}
else
{
return("3");
}
}
else
{
return("2");
}
}
public ActionResult SaveDepositToBank(Deposit deposit)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("BankDeposit_Insert"))
{
return(Json("X", JsonRequestBehavior.AllowGet));
}
List <CashOperationVModel> CashOPVM = new List <CashOperationVModel>();
try
{
var IfExit = _DepositToBankService.All().Where(x => x.DepositNo == deposit.DepositNo).FirstOrDefault();
if (IfExit == null)
{
if (!string.IsNullOrEmpty(deposit.bankAccode) && deposit.bankAccode.Trim() != "Select Bank A/C")
{
deposit.BranchCode = Session["BranchCode"].ToString();
var GCa = _AcBrService.All().Where(s => s.BranchCode == deposit.BranchCode && s.Ca_Ba == "Ca").Select(x => x.Accode).FirstOrDefault();
if (GCa == null)
{
var gset = _gsetService.All().LastOrDefault();
GCa = gset.GCa;
}
deposit.FinYear = Session["FinYear"].ToString();
deposit.NewChart = _NewChartService.All().ToList().FirstOrDefault(x => x.Accode == deposit.bankAccode.Trim());
//cashReceipt.Customer = _CustomerService.All().ToList().FirstOrDefault(x => x.CustCode == cashReceipt.CustCode);
CashOperation cashOperation = new CashOperation(deposit.DepositDate, 0.0, 0.0, 0.0, 0.0, "", DateTime.Now, false, deposit.FinYear, false, deposit.BranchCode);
var isAlreadyClosed = _CashOperationService.All().ToList().FirstOrDefault(x => x.BranchCode == deposit.BranchCode && x.TrDate.ToString("MM-dd-yyyy") == deposit.DepositDate.ToString("MM-dd-yyyy"));
var openBal = GetOpenBal(deposit.DepositDate, deposit.bankAccode);
var rcecBal = GetAllRemittances(deposit.DepositDate, deposit.BranchCode, deposit.bankAccode).Sum(x => x.Amount);
var payTotal = GetAllPayment(deposit.DepositDate, deposit.BranchCode, deposit.bankAccode).Sum(x => x.Amount);
var closBal = openBal + rcecBal - payTotal;
BankOperation bankOperation = new BankOperation(deposit.DepositDate, openBal, deposit.Amount, 0.0, closBal, deposit.BranchCode, deposit.FinYear, false, deposit.bankAccode);
var sysSet = _sysSetService.All().FirstOrDefault();
var isAlreadySaved = _BankOperationService.All().ToList().FirstOrDefault(x => x.TrDate.ToString("MM-dd-yyyy") == deposit.DepositDate.ToString("MM-dd-yyyy") && x.BranchCode == deposit.BranchCode && x.bankAccode == deposit.bankAccode);
if (isAlreadyClosed == null || isAlreadySaved == null)
{
using (var transaction = new TransactionScope())
{
try
{
_CashOperationService.Add(cashOperation);
_CashOperationService.Save();
_BankOperationService.Add(bankOperation);
_BankOperationService.Save();
_DepositToBankService.Add(deposit);
_DepositToBankService.Save();
TransactionLogService.SaveTransactionLog(_transactionLogService, "Deposit To Bank", "Save", deposit.DepositNo, Session["UserName"].ToString());
LoadDropDown.journalVoucherSave("BD", "I", deposit.DepositNo, deposit.VoucherNo, deposit.FinYear, "01", deposit.BranchCode, deposit.DepositDate, GCa, Session["UserName"].ToString());
CashOPVM = GetAllExpenseAndDeposit(deposit.DepositDate, deposit.BranchCode);
transaction.Complete();
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
return(Json(CashOPVM, JsonRequestBehavior.AllowGet));
}
}
else if (isAlreadyClosed != null && sysSet.CashRule == "O" ? true : isAlreadyClosed.IsClosed == false)
{
var rcecBals = GetAllRemittances(deposit.DepositDate, deposit.BranchCode, deposit.bankAccode).Sum(x => x.Amount);
isAlreadySaved.RecTotal = rcecBals + deposit.Amount;
isAlreadySaved.CloseBal = isAlreadySaved.OpenBal + isAlreadySaved.RecTotal - isAlreadySaved.PayTotal;
using (var transaction = new TransactionScope())
{
try
{
_BankOperationService.Update(isAlreadySaved);
_BankReceiptAppService.Save();
_DepositToBankService.Add(deposit);
_DepositToBankService.Save();
TransactionLogService.SaveTransactionLog(_transactionLogService, "Deposit To Bank", "Save", deposit.DepositNo, Session["UserName"].ToString());
LoadDropDown.journalVoucherSave("BD", "I", deposit.DepositNo, deposit.VoucherNo, deposit.FinYear, "01", deposit.BranchCode, deposit.DepositDate, GCa, Session["UserName"].ToString());
if (sysSet.CashRule == "O")
{
LoadDropDown.CashRecalculate(Session["ProjCode"].ToString(), deposit.BranchCode, deposit.FinYear, Convert.ToDecimal(deposit.Amount), deposit.DepositDate);
}
CashOPVM = GetAllExpenseAndDeposit(deposit.DepositDate, deposit.BranchCode);
transaction.Complete();
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
return(Json(CashOPVM, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json("2", JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json("1", JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json("3", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
public ActionResult UpdateDepositToBank(Deposit deposit, DateTime dateTime)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("BankDeposit_Update"))
{
return(Json("U", JsonRequestBehavior.AllowGet));
}
List <CashOperationVModel> CashOPVM = new List <CashOperationVModel>();
if (ModelState.IsValid)
{
deposit.BranchCode = Session["BranchCode"].ToString();
var GCa = _AcBrService.All().Where(s => s.BranchCode == deposit.BranchCode && s.Ca_Ba == "Ca").Select(x => x.Accode).FirstOrDefault();
if (GCa == null)
{
var gset = _gsetService.All().LastOrDefault();
GCa = gset.GCa;
}
deposit.FinYear = Session["FinYear"].ToString();
deposit.NewChart = _NewChartService.All().ToList().FirstOrDefault(x => x.Accode == deposit.bankAccode.Trim());
CashOperation cashOperation = new CashOperation();
var isClosed = _CashOperationService.All().LastOrDefault(x => x.BranchCode == deposit.BranchCode && Convert.ToDateTime(x.TrDate.ToShortDateString()) <= Convert.ToDateTime(dateTime.ToShortDateString()));
if (isClosed.IsClosed == false)
{
using (var transaction = new TransactionScope())
{
try
{
_DepositToBankService.Update(deposit);
_DepositToBankService.Save();
//delete to provision
var entryNo = deposit.DepositNo;
//var entryNo = Convert.ToInt64(deposit.VoucherNo.Substring(2, 8)).ToString().PadLeft(8, '0');
LoadDropDown.journalVoucherRemoval("BD", entryNo, deposit.VoucherNo, deposit.FinYear);
//insert to provision
LoadDropDown.journalVoucherSave("BD", "I", deposit.DepositNo, deposit.VoucherNo, deposit.FinYear, "01", deposit.BranchCode, deposit.DepositDate, GCa, Session["UserName"].ToString());
TransactionLogService.SaveTransactionLog(_transactionLogService, "Deposit To Bank", "Update", deposit.DepositNo, Session["UserName"].ToString());
var sysSet = _sysSetService.All().FirstOrDefault();
if (sysSet.CashRule == "O")
{
LoadDropDown.CashRecalculate(Session["ProjCode"].ToString(), deposit.BranchCode, deposit.FinYear, Convert.ToDecimal(deposit.Amount), deposit.DepositDate);
}
CashOPVM = GetAllExpenseAndDeposit(deposit.DepositDate, deposit.BranchCode);
transaction.Complete();
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
return(Json(CashOPVM, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json("2", JsonRequestBehavior.AllowGet));
}
}
return(Json("0", JsonRequestBehavior.AllowGet));
}
public ActionResult SavePayment(Payment payment)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("BankPayment_Insert"))
{
return(Json("X", JsonRequestBehavior.AllowGet));
}
List <BankOperationVModel> CashOPVM = new List <BankOperationVModel>();
var gset = _gsetService.All().LastOrDefault();
try
{
var IfExit = _paymentService.All().Where(x => x.PayCode == payment.PayCode).FirstOrDefault();
if (IfExit == null)
{
payment.BranchCode = Session["BranchCode"].ToString();
payment.FinYear = Session["FinYear"].ToString();
payment.bankAccode = Session["BankAccode"].ToString();
var openBal = GetOpenBal(payment.PayDate);
var rcecBal = GetAllRemittances(payment.PayDate, payment.BranchCode, payment.bankAccode).Sum(x => x.Amount);
var payTotal = GetAllPayment(payment.PayDate, payment.BranchCode, payment.bankAccode).Sum(x => x.Amount);
var closBal = openBal + rcecBal - payTotal;
BankOperation bankOperation = new BankOperation(payment.PayDate, openBal, 0.0, payment.Amount, closBal, payment.BranchCode, payment.FinYear, false, payment.bankAccode);
// BankOperation bankOperation = new BankOperation(payment.PayDate, 0.0, 0.0, 0.0, 0.0, payment.BranchCode, payment.FinYear, false, payment.bankAccode);
var isAlreadySaved = _bankOperationService.All().ToList().FirstOrDefault(x => x.TrDate.ToString("MM-dd-yyyy") == payment.PayDate.ToString("MM-dd-yyyy") && x.BranchCode == payment.BranchCode && x.bankAccode == payment.bankAccode);
if (isAlreadySaved == null)
{
using (var transaction = new TransactionScope())
{
try
{
_bankOperationService.Add(bankOperation);
_bankOperationService.Save();
_paymentService.Add(payment);
_paymentService.Save();
//Insert to provision
LoadDropDown.journalVoucherSave("BP", "I", payment.PayCode, payment.VoucherNo, payment.FinYear, "01", payment.BranchCode, payment.PayDate, payment.bankAccode, Session["UserName"].ToString());
TransactionLogService.SaveTransactionLog(_transactionLogService, "Payment", "Save", payment.PayCode, User.Identity.Name);
CashOPVM = GetAllPayment(payment.PayDate, payment.BranchCode, payment.bankAccode);
transaction.Complete();
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
return(Json(CashOPVM, JsonRequestBehavior.AllowGet));
}
else
{
var payTotals = GetAllPayment(payment.PayDate, payment.BranchCode, payment.bankAccode).Sum(x => x.Amount);
isAlreadySaved.PayTotal = payTotals + payment.Amount;
isAlreadySaved.CloseBal = isAlreadySaved.OpenBal + isAlreadySaved.RecTotal - isAlreadySaved.PayTotal;
using (var transaction = new TransactionScope())
{
try
{
_bankOperationService.Update(isAlreadySaved);
_bankOperationService.Save();
_paymentService.Add(payment);
_paymentService.Save();
//Insert to provision
LoadDropDown.journalVoucherSave("BP", "I", payment.PayCode, payment.VoucherNo, payment.FinYear, "01", payment.BranchCode, payment.PayDate, payment.bankAccode, Session["UserName"].ToString());
var sysSet = _sysSetService.All().FirstOrDefault();
if (sysSet.CashRule == "O")
{
LoadDropDown.BankRecalculate(payment.PayDate, Convert.ToDecimal(payment.Amount), Session["ProjCode"].ToString(), payment.BranchCode, payment.FinYear, payment.bankAccode);
}
TransactionLogService.SaveTransactionLog(_transactionLogService, "Payment", "Save", payment.PayCode, User.Identity.Name);
CashOPVM = GetAllPayment(payment.PayDate, payment.BranchCode, payment.bankAccode);
transaction.Complete();
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
return(Json(CashOPVM, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json("1", JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
public ActionResult UpdatePayment(Payment payment)
{
using (var transaction = new TransactionScope())
{
try
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("BankPayment_Update"))
{
return(Json("U", JsonRequestBehavior.AllowGet));
}
List <BankOperationVModel> CashOPVM = new List <BankOperationVModel>();
var gset = _gsetService.All().LastOrDefault();
payment.BranchCode = Session["BranchCode"].ToString();
payment.FinYear = Session["FinYear"].ToString();
payment.bankAccode = Session["BankAccode"].ToString();
string branchCode = Session["BranchCode"].ToString();
string finYear = Session["FinYear"].ToString();
string bankAccode = Session["BankAccode"].ToString();
var bankOperation = _bankOperationService.All().ToList().LastOrDefault(x => x.BranchCode == branchCode && x.bankAccode == bankAccode && x.TrDate == payment.PayDate);
var Payment = _paymentService.All().ToList().Where(x => x.PayCode == payment.PayCode.Trim()).FirstOrDefault();
if (bankOperation != null && Payment != null)
{
bankOperation.PayTotal = bankOperation.PayTotal + Payment.Amount - payment.Amount;
bankOperation.CloseBal = bankOperation.OpenBal + bankOperation.RecTotal - bankOperation.PayTotal;
_bankOperationService.Update(bankOperation);
_bankOperationService.Save();
Payment = payment;
_paymentService.All().ToList().Where(y => y.PayCode == payment.PayCode).ToList().ForEach(x => _paymentService.Delete(x));
_paymentService.Save();
_paymentService.Add(Payment);
_paymentService.Save();
// Delete Provision
var entryNo = payment.PayCode;
LoadDropDown.journalVoucherRemoval("BP", entryNo, payment.VoucherNo, payment.FinYear);
//Insert to provision
LoadDropDown.journalVoucherSave("BP", "I", payment.PayCode, payment.VoucherNo, payment.FinYear, "01", payment.BranchCode, payment.PayDate, payment.bankAccode, Session["UserName"].ToString());
TransactionLogService.SaveTransactionLog(_transactionLogService, "Payment", "Update", payment.PayCode, User.Identity.Name);
var sysSet = _sysSetService.All().FirstOrDefault();
if (sysSet.CashRule == "O")
{
LoadDropDown.BankRecalculate(payment.PayDate, Convert.ToDecimal(payment.Amount), Session["ProjCode"].ToString(), payment.BranchCode, payment.FinYear, payment.bankAccode);
}
CashOPVM = GetAllPayment(payment.PayDate, payment.BranchCode, payment.bankAccode);
transaction.Complete();
return(Json(new { CashOPVM, data = 1 }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
transaction.Dispose();
return(Json(ex.Message.ToString(), JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult UpdateCashMR(MoneyReceiptVM MrVM)
{
using (var transaction = new TransactionScope())
{
try
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("MoneyReceiptCash_Update"))
{
return(Json("U", JsonRequestBehavior.AllowGet));
}
var VchrExist = _pVchrmainService.All().FirstOrDefault(s => s.VchrNo == MrVM.VchrNo);
if (VchrExist == null)
{
return(Json("3", JsonRequestBehavior.AllowGet));
}
var MR = _moneyReceiptService.All().Where(x => x.MRSL == MrVM.MRSL && x.MRNo == MrVM.MRNo && MrVM.Posted == false).FirstOrDefault();
var CR = _CashReceiptService.All().Where(s => s.RefNo == MrVM.MRSL).FirstOrDefault();
var CRSD = _CashReceiptSubDetailsAppService.All().Where(s => s.CashReceiptNo == CR.ReceiptNo).FirstOrDefault();
if (MR != null && CR != null && CRSD != null)
{
//var cabkop = _defACService.All().ToList().FirstOrDefault().CashAc;
var GCa = _AcBrService.All().Where(s => s.BranchCode == MR.BranchCode && s.Ca_Ba == "Ca").Select(x => x.Accode).FirstOrDefault();
if (GCa == null)
{
var gset = _gsetService.All().LastOrDefault();
GCa = gset.GCa;
}
//For MR
MR.MRSL = MrVM.MRSL;
MR.BranchCode = (MrVM.BranchCode == null) ? Session["BranchCode"].ToString() : MrVM.BranchCode;
MR.ProjCode = (MrVM.ProjCode == null) ? Session["ProjCode"].ToString() : MrVM.ProjCode;
MR.MRNo = MrVM.MRNo;
MR.MRDate = MrVM.MRDate;
MR.MRAgainst = MrVM.MRAgainst;
MR.VchrNo = MrVM.VchrNo;
MR.Posted = MrVM.Posted;
MR.AdjWithBill = MrVM.AdjWithBill;
MR.MRAmount = MrVM.Amount;
MR.Accode = MrVM.Accode;
MR.CustCode = MrVM.CustCode;
MR.FinYear = Session["FinYear"].ToString();
MR.JobNo = MrVM.JobNo;
MR.Remarks = MrVM.Remarks;
MR.Ca_Bk = GCa;
CR.ReceiptDate = (DateTime)MrVM.MRDate;
CR.purAccode = MrVM.MRAgainst;// "1.2.004";
CR.RefNo = MrVM.MRSL;
CR.Amount = (Double)MrVM.Amount;
CR.Remarks = MrVM.Remarks;
CR.VoucherNo = MrVM.VchrNo;
CRSD.SubCode = MrVM.CustCode;
CRSD.Accode = MrVM.MRAgainst;
CRSD.Amount = (Double)MrVM.Amount;
_moneyReceiptService.Update(MR);
_CashReceiptService.Update(CR);
_CashReceiptSubDetailsAppService.Update(CRSD);
_CashReceiptService.Save();
_CashReceiptSubDetailsAppService.Save();
_moneyReceiptService.Save();
TransactionLogService.SaveTransactionLog(_transactionLogService, "Cash MR", "Update", MR.MRSL, Session["UserName"].ToString());
LoadDropDown.journalVoucherRemoval("CR", MrVM.MRNo, MrVM.VchrNo, Session["FinYear"].ToString());
LoadDropDown.journalVoucherSave("CR", "I", MrVM.MRNo, MrVM.VchrNo, Session["FinYear"].ToString(), Session["ProjCode"].ToString(), Session["BranchCode"].ToString(), Convert.ToDateTime(MrVM.MRDate), GCa, Session["UserName"].ToString());
transaction.Complete();
return(Json("1", JsonRequestBehavior.AllowGet));
}
else
{
transaction.Dispose();
return(Json("3", JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
