public Import_DutyFreeRecommendationViewModel GeById(int id) { Import_DutyFreeRecommendationViewModel model = ent.Import_DutyFreeRecommendation.Select(x => new Import_DutyFreeRecommendationViewModel() { ImportId = x.ImportId, DeletedDate = x.DeletedDate, DeletedBy = x.DeletedBy, UpDatedBy = x.UpDatedBy, UpdateDate = x.UpdateDate, GA_Id = x.GA_Id, PA_Id = x.PA_Id, DonnerName = x.DonnerName, DonnerAddress = x.DonnerAddress, Council_RegistrtionNumber = x.Council_RegistrtionNumber, CouncilRegistrationDate = x.CouncilRegistrationDate, CouncilRegistrationDateNp = x.CouncilRegistrationDateNp, DiscriptionOfGoods = x.DiscriptionOfGoods, InvoiceNumber = x.InvoiceNumber, InvoiceDate = x.InvoiceDate, InvoiceDateNp = x.InvoiceDateNp, DecisionDate = x.DecisionDate, DecisionDateNp = x.DecisionDateNp, TotalAmountForieignCurrency = x.TotalAmountForieignCurrency, TotalAmountNepaliCurrency = x.TotalAmountNepaliCurrency, Remarks = x.Remarks, CreatedDate = DateTime.Now, CreatedBy = x.CreatedBy }).Where(x => x.ImportId == id).FirstOrDefault(); return(model); }
public ActionResult Index() { Import_DutyFreeRecommendationViewModel model = new Import_DutyFreeRecommendationViewModel(); model.Import_DutyFreeRecommendationViewModelList = pro.GetList(); return(View(model)); }
public ActionResult InsertUpdate(int?id) { Import_DutyFreeRecommendationViewModel model = new Import_DutyFreeRecommendationViewModel(); if (id > 0) { model = pro.GeById(id ?? 0); } return(View(model)); }
public ActionResult InsertUpdate(Import_DutyFreeRecommendationViewModel model) { try { var result = pro.InsertImport_DutyFreeRecommendation(model); if (result == true) { TempData["SuccessMsg"] = "सफल भयो"; return(RedirectToAction("Index")); } } catch { TempData["Msg"] = "असफल भयो "; return(View()); } return(View()); }
public bool InsertImport_DutyFreeRecommendation(Import_DutyFreeRecommendationViewModel model) { using (SamajkalyanEntities ent = new SamajkalyanEntities()) { try { var workPermitRow = ent.Import_DutyFreeRecommendation.Where(x => x.ImportId == model.ImportId).FirstOrDefault(); //_context.Database.Connection.Open(); //_context.Database.Connection.BeginTransaction(); if (workPermitRow == null) { workPermitRow = new Import_DutyFreeRecommendation(); } ; // workPermitRow.WorkPermitId = model.WorkPermitId; workPermitRow.GA_Id = model.GA_Id; workPermitRow.PA_Id = model.PA_Id; workPermitRow.Council_RegistrtionNumber = model.Council_RegistrtionNumber; workPermitRow.CouncilRegistrationDate = model.CouncilRegistrationDate; workPermitRow.CouncilRegistrationDateNp = model.CouncilRegistrationDateNp; workPermitRow.DonnerName = model.DonnerName; workPermitRow.DonnerAddress = model.DonnerAddress; workPermitRow.DiscriptionOfGoods = model.DiscriptionOfGoods; workPermitRow.InvoiceDateNp = model.InvoiceDateNp; workPermitRow.DecisionDate = model.DecisionDate; workPermitRow.InvoiceNumber = model.InvoiceNumber; workPermitRow.TotalAmountForieignCurrency = model.TotalAmountForieignCurrency; workPermitRow.TotalAmountNepaliCurrency = model.TotalAmountNepaliCurrency; workPermitRow.Remarks = model.Remarks; workPermitRow.CreatedBy = model.CreatedBy; workPermitRow.CreatedDate = model.CreatedDate; //deploymentRow.Status = true; if (model.ImportId == 0) { // generalAgreementRow.Status = false; ent.Import_DutyFreeRecommendation.Add(workPermitRow); ent.SaveChanges(); } else { // deploymentRow.Status = dmodel.Status ?? false; workPermitRow.UpDatedBy = model.UpDatedBy; workPermitRow.UpdateDate = model.UpdateDate; ent.Import_DutyFreeRecommendation.Attach(workPermitRow); ent.Entry(workPermitRow).State = EntityState.Modified; ent.SaveChanges(); } //if (model.ImportId <= 0) //{ // model.ImportId = ent.Database.SqlQuery<WorkPermitViewModel>("select * from WorkPermit where WorkPermitId=(select max (WorkPermitId) from WorkPermit )").ToList().FirstOrDefault().WorkPermitId; // //employeeRow.EmpId=employeeRow.EmpId != 0 ? employeeRow.EmpId : empModel.EmpId; //} } catch (Exception ex) { return(false); } } return(true); }
public ActionResult Details(int id) { Import_DutyFreeRecommendationViewModel abc = pro.GeById(id); return(PartialView(abc)); }