///////////////////////////////////////////////////////////////////////////////////////////////////////////// //for delete public void DeleteLedgerMaster(int LedgerMasterId) { GL_Ledgers result = ent.GL_Ledgers.Where(x => x.LedgerId == LedgerMasterId).FirstOrDefault(); ent.DeleteObject(result); ent.SaveChanges(); }
public void UpdateGeneralLegder(BranchOfficeManagementModel model) { GL_Ledgers led = ent.GL_Ledgers.Where(x => x.Id == model.BranchOfficeId && x.AccTypeId == 8).FirstOrDefault(); led.LedgerName = model.BranchOffice + " " + model.BranchOfficeCode; ent.ApplyCurrentValues(led.EntityKey.EntitySetName, led); ent.SaveChanges(); }
public void UpdateGeneralLegder(DistributorManagementModel model) { GL_Ledgers led = entity.GL_Ledgers.Where(x => x.Id == model.DistributorId && x.AccTypeId == 9).FirstOrDefault(); led.LedgerName = model.DistributorName + " " + model.DistributorCode; entity.ApplyCurrentValues(led.EntityKey.EntitySetName, led); entity.SaveChanges(); }
public long AddLedgerMaster(GL_Ledgers obj) { ent.AddToGL_Ledgers(obj); ent.SaveChanges(); //to return the primary key return(obj.LedgerId); }
//for delete public void DeleteLedgerMaster(int ID) { GL_Ledgers result = ent.GL_Ledgers.Where(x => x.Id == ID).FirstOrDefault(); if (result != null) { ent.DeleteObject(result); ent.SaveChanges(); } }
//to get ledger name public string GetLedgerDetail(int id) { GL_Ledgers result = ent.GL_Ledgers.Where(x => x.LedgerId == id).FirstOrDefault(); LedgerMasterModel model = new LedgerMasterModel(); model.LedgerId = (int)result.LedgerId; model.LedgerName = result.LedgerName; return(model.LedgerName); }
public void EditLedgerInfo(GL_Ledgers obj) { EntityModel ent = new EntityModel(); var result = ent.GL_Ledgers.Where(x => x.Id == obj.Id).FirstOrDefault(); if (result != null) { obj.LedgerId = result.LedgerId; ent.ApplyCurrentValues(result.EntityKey.EntitySetName, obj); ent.SaveChanges(); } }
//for edit public void EditLedgerMaster(LedgerMasterModel model) { GL_Ledgers result = ent.GL_Ledgers.Where(x => x.LedgerId == model.LedgerId).FirstOrDefault(); result.LedgerId = model.LedgerId; result.ProductId = model.ProductId; result.AccGroupId = model.AccGroupId; result.AccSubGroupId = model.AccSubGroupId; result.AccTypeId = model.AccTypeId; result.Id = model.ddlAirLines; result.LedgerName = model.LedgerName; ent.ApplyCurrentValues(result.EntityKey.EntitySetName, result); ent.SaveChanges(); }
//for adding into GL_Ledgers Table public void LedgerAdd(LedgerMasterModel modelToSave) { GL_Ledgers datamodel = new GL_Ledgers { ProductId = modelToSave.ProductId, AccGroupId = modelToSave.AccGroupId, AccSubGroupId = modelToSave.AccSubGroupId, AccTypeId = modelToSave.AccTypeId, Id = modelToSave.ddlAirLines, LedgerName = modelToSave.LedgerName, CreatedDate = DateTime.Now, }; ent.AddToGL_Ledgers(datamodel); ent.SaveChanges(); }
public GL_Ledgers GetLedgerInfoByLedgerId(int LedgerId) { EntityModel ent = new EntityModel(); GL_Ledgers result = ent.GL_Ledgers.Where(x => x.LedgerId == LedgerId).FirstOrDefault(); if (result != null) { return(result); } // return result; else { return(result); } }
public int GetLedgerInformationById(int id) { GL_Ledgers result = ent.GL_Ledgers.Where(x => x.Id == id).FirstOrDefault(); AirLinesModel model = new AirLinesModel(); if (result != null) { model.LedgerId = (int)result.LedgerId; model.AccTypes = result.AccTypeId; model.LedId = (int)result.Id; return(model.LedgerId); } else { return(model.LedgerId); } }
public void SaveBranchOfficeLedger(int BranchOfficeId, int ProductId, int CreatedBy) { var BranchOfficeDetails = GetBranchOfficeInfo(BranchOfficeId); GL_Ledgers datamodel = new GL_Ledgers { Id = BranchOfficeId, ProductId = ProductId, AccGroupId = 1, AccSubGroupId = 1, AccTypeId = 8, LedgerName = BranchOfficeDetails.BranchOfficeName + " " + BranchOfficeDetails.BranchOfficeCode, CreatedBy = CreatedBy, CreatedDate = DateTime.Now, }; ent.AddToGL_Ledgers(datamodel); ent.SaveChanges(); }
public void SaveAgentGeneralLedger(int agentid, int ProductId, int CreatedBy) { var agentdetails = GetAgentInfo(agentid); GL_Ledgers datamodel = new GL_Ledgers { Id = agentid, ProductId = ProductId, AccGroupId = 1, AccSubGroupId = 1, AccTypeId = 2, LedgerName = "A/C " + agentdetails.AgentName, CreatedBy = CreatedBy, CreatedDate = DateTime.Now, }; ent.AddToGL_Ledgers(datamodel); ent.SaveChanges(); }
public int GetLedgerMasterDetail(int id) { GL_Ledgers result = ent.GL_Ledgers.Where(x => x.Id == id).FirstOrDefault(); AirLinesModel model = new AirLinesModel(); if (result != null) { model.LedgerId = (int)result.LedgerId; model.LedId = (int)result.Id; model.LedgerName = result.LedgerName; return(model.LedId); } else { return(model.LedId); } }
public void SaveDistributorLedger(DistributorManagementModel model) { DistributorManagementModel distributorsDetails = GetDistributorsDetailsModel(model.DistributorId); GL_Ledgers datamodel = new GL_Ledgers { Id = model.DistributorId, ProductId = 1, AccGroupId = 1, AccSubGroupId = 1, AccTypeId = 9, LedgerName = distributorsDetails.DistributorName + " " + distributorsDetails.DistributorCode, CreatedBy = model.CreatedBy, CreatedDate = DateTime.UtcNow, }; entity.AddToGL_Ledgers(datamodel); entity.SaveChanges(); }
////////////////////////////////////////////////for detail///////////////////////////////////////////// public LedgerMasterModel Detail(int id) { GL_Ledgers result = ent.GL_Ledgers.Where(x => x.LedgerId == id).FirstOrDefault(); LedgerMasterModel model = new LedgerMasterModel(); model.LedgerId = (int)result.LedgerId; model.ProductId = result.ProductId; model.ProductName = result.Core_Products.ProductName; model.AccGroupId = result.AccGroupId; model.AccGroupName = result.GL_AccGroups.AccGroupName; model.AccSubGroupId = result.AccSubGroupId; model.AccSubGroupName = result.GL_AccSubGroups.AccSubGroupName; model.AccTypeId = result.AccTypeId; model.AccTypeName = result.GL_AccTypes.AccTypeName; model.ddlAirLines = result.Id; model.LedgerName = result.LedgerName; model.MapTable = result.GL_AccTypes.MapTable; model.ValueMember = result.GL_AccTypes.ValueMember; model.DisplayMember = result.GL_AccTypes.DisplayMember; return(model); }
public ActionResult Create(AirLinesModel model) { EntityModel ent = new EntityModel(); bool check = ser.CheckAirlineName(model.AirlineName); if (check == true) { //AirLinesServices.ServiceAirlineClient ser = new AirLinesServices.ServiceAirlineClient(); try { //new save with settlement Condition// Airlines datamodel = new Airlines(); if (model.chkSettlement == false) { datamodel.AirlineCode = model.AirlineCode.TrimEnd(); datamodel.AirlineName = model.AirlineName.TrimEnd(); datamodel.AirlineTypeId = model.AirlineTypId; //datamodel.SettlmentLedgerId = model.LedgerId; datamodel.SettlmentLedgerId = model.LedgerId; datamodel.CountryId = Convert.ToInt32(model.CountryId); datamodel.isActive = true; ser.AddAirLine(datamodel); } if (model.chkSettlement == true) { ////////insertng into Airline Table//////////// datamodel.AirlineCode = model.AirlineCode.TrimEnd(); datamodel.AirlineName = model.AirlineName.TrimEnd(); datamodel.AirlineTypeId = model.AirlineTypId; datamodel.SettlmentLedgerId = model.AirlineId; datamodel.CountryId = Convert.ToInt32(model.CountryId); datamodel.isActive = true; int airlineid = ser.AddAirLine(datamodel); // datamodel.SettlmentLedgerId = airlineid; // ser.AddAirLine(datamodel); datamodel.SettlmentLedgerId = airlineid; ser.EditAirLineInfo(datamodel); ///////////inserting into Legder Table//////// GL_Ledgers datamodel1 = new GL_Ledgers(); // datamodel1.LedgerId = airlineid; datamodel1.ProductId = 1; datamodel1.AccGroupId = 2; datamodel1.AccSubGroupId = 2; datamodel1.AccTypeId = 1; datamodel1.Id = airlineid; //datamodel1.LedgerName = "A/C" + " " + model.AirlineName.TrimEnd(); datamodel1.LedgerName = model.AirlineName.TrimEnd(); datamodel1.CreatedDate = DateTime.Now; ser.AddLedger(datamodel1); ////////////////////////////////////////////////// } } catch { // var AirlineModel = new AirLineModel() // { // AirlineTypList = ser.GetAirlineTypeList(), // AccTypesList = ser.GetAllAccTypesList(), // BSPorConsolidatorList = ser.GetAllGetLedgername() // }; // return View(AirlineModel); } return(RedirectToAction("Index")); } var viewModel = new AirLinesModel() { AirlineTypList = ser.GetAirlineTypeList(), AccTypesList = ser.GetAllAccTypesList(), BSPorConsolidatorList = ser.GetAllGetLedgername() }; TempData["Error"] = "Airline Name Already Exists"; return(View(viewModel)); }
public int getLedgerId(int AirlineId) { return((int)GL_Ledgers.Where(x => x.Id == AirlineId && x.AccTypeId == 1).Select(x => x.LedgerId).FirstOrDefault()); }
public ActionResult Edit(AirLinesModel model, Int32 id, FormCollection fs) { // ser.EditAirLineInfo(obj); //new edit Airlines obj = new Airlines(); if (model.chkSettlement == false) { obj.AirlineId = id; obj.AirlineCode = model.AirlineCode.Trim(); obj.AirlineName = model.AirlineName.Trim(); obj.AirlineTypeId = model.AirlineTypId; obj.isActive = true; obj.SettlmentLedgerId = model.LedgerId; obj.CountryId = Convert.ToInt32(model.CountryId); ser.EditAirLineInfo(obj); ser.DeleteLedgerMaster(id); } if (model.chkSettlement == true) { obj.AirlineId = id; obj.AirlineCode = model.AirlineCode.Trim(); obj.AirlineName = model.AirlineName.Trim(); obj.AirlineTypeId = model.AirlineTypId; obj.isActive = true; obj.SettlmentLedgerId = obj.AirlineId; obj.CountryId = obj.CountryId; ser.EditAirLineInfo(obj); //to get the ID from GL_Ledger int LedId = ser.GetLedgerMasterDetail(id); GL_Ledgers obj1 = new GL_Ledgers(); if (LedId == 0) { obj1.LedgerId = id; obj1.ProductId = 1; obj1.AccGroupId = 2; obj1.AccSubGroupId = 2; obj1.AccTypeId = 1; obj1.Id = id; obj1.LedgerName = model.AirlineName.Trim(); obj1.CreatedDate = DateTime.Now; ser.AddLedger(obj1); } else { //obj1.LedgerId = id; obj1.ProductId = 1; obj1.AccGroupId = 2; obj1.AccSubGroupId = 2; obj1.AccTypeId = 1; obj1.Id = id; obj1.LedgerName = model.AirlineName.Trim(); obj1.CreatedDate = DateTime.Now; ser.EditLedgerInfo(obj1); } } //new edit //new edit Airlines obj2 = new Airlines(); if (model.chkSettlement == false) { obj2.AirlineId = id; obj2.AirlineCode = model.AirlineCode.Trim(); obj2.AirlineName = model.AirlineName.Trim(); obj2.AirlineTypeId = model.AirlineTypId; obj2.isActive = true; obj2.SettlmentLedgerId = model.BSPorConsolidatorId; obj2.CountryId = Convert.ToInt32(model.CountryId); ser.EditAirLineInfo(obj2); } if (model.chkSettlement == true) { GL_Ledgers obj1 = new GL_Ledgers(); //obj1.LedgerId = id; obj1.ProductId = 1; obj1.AccGroupId = 2; obj1.AccSubGroupId = 2; obj1.AccTypeId = 1; obj1.Id = id; obj1.LedgerName = model.AirlineName.Trim(); obj1.CreatedDate = DateTime.Now; Int64 LedgerId = 0; if (!ser.isLedgerExists(id)) { LedgerId = ser.AddLedger(obj1); } else { ser.EditLedgerInfo(obj1); LedgerId = ser.getLedgerId(id); } obj2.AirlineId = id; obj2.AirlineCode = model.AirlineCode.Trim(); obj2.AirlineName = model.AirlineName.Trim(); obj2.AirlineTypeId = model.AirlineTypId; obj2.isActive = true; obj2.SettlmentLedgerId = (int)LedgerId; obj2.CountryId = Convert.ToInt32(model.CountryId); ser.EditAirLineInfo(obj2); } return(RedirectToAction("Index")); }
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// public Int64 AddLedger(GL_Ledgers obj) { ent.AddToGL_Ledgers(obj); ent.SaveChanges(); return(obj.LedgerId); }