public ActionResult SaveVls(VisaLocationVM Vls) { List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>; if (list == null) { return(Redirect("Login/InLogin")); } else { Vls.CmpyCode = list[0].CmpyCode; Vls.UserName = list[0].user_name; return(Json(_VlService.SaveVls(Vls), JsonRequestBehavior.AllowGet)); } }
public VisaLocationVM SaveVls(VisaLocationVM Vls) { return(_VlRepo.SaveVls(Vls)); }
public VisaLocationVM SaveVls(VisaLocationVM Vls) { try { if (!Vls.EditFlag) { var Drecord = new List <string>(); List <VisaLocNew> ObjList = new List <VisaLocNew>(); ObjList.AddRange(Vls.VisaLocNew.Select(m => new VisaLocNew { CmpyCode = m.CmpyCode, Code = m.Code, Name = m.Name, CompanyMolID = m.CompanyMolID }).ToList()); int n = 0; n = ObjList.Count; while (n > 0) { int Bbs1 = _EzBusinessHelper.ExecuteScalar("Select count(*) as [count1] from VLOC001 where CmpyCode='" + Vls.CmpyCode + "' and Code='" + ObjList[n - 1].Code + "'"); if (Bbs1 == 0) { StringBuilder sb = new StringBuilder(); sb.Append("'" + Vls.CmpyCode + "',"); sb.Append("'" + ObjList[n - 1].Code + "',"); sb.Append("'" + ObjList[n - 1].Name + "',"); sb.Append("'" + "" + "',"); sb.Append("'" + ObjList[n - 1].CompanyMolID + "')"); using (TransactionScope scope1 = new TransactionScope()) { int i = _EzBusinessHelper.ExecuteNonQuery("insert into VLOC001(CmpyCode,Code,Name,UniCodeName,CompanyMolID) values(" + sb.ToString() + ""); _EzBusinessHelper.ActivityLog(Vls.CmpyCode, Vls.UserName, "Add Visa Location Master", ObjList[n - 1].Code, Environment.MachineName); if (i > 0) { scope1.Complete(); Vls.SaveFlag = true; Vls.ErrorMessage = string.Empty; } } } else { Drecord.Add(ObjList[n - 1].Code.ToString()); Vls.Drecord = Drecord; Vls.SaveFlag = false; Vls.ErrorMessage = "Duplicate Record"; } n = n - 1; } return(Vls); } var VlsEdit = _EzBusinessHelper.ExecuteScalarDec("Select count(*) from VLOC001 where CmpyCode='" + Vls.CmpyCode + "' and Code='" + Vls.Code + "'"); if (VlsEdit != 0) { using (TransactionScope scope = new TransactionScope()) { Vls.SaveFlag = _EzBusinessHelper.ExecuteNonQuery1("update VLOC001 set CmpyCode='" + Vls.CmpyCode + "',Code='" + Vls.Code + "',Name='" + Vls.Name + "',CompanyMolID='" + Vls.CompanyMolID + "' where CmpyCode='" + Vls.CmpyCode + "' and Code='" + Vls.Code + "'"); _EzBusinessHelper.ActivityLog(Vls.CmpyCode, Vls.UserName, "Update Visa Location Master", Vls.Code, Environment.MachineName); // Vls.SaveFlag = true; scope.Complete(); } Vls.ErrorMessage = string.Empty; } else { Vls.SaveFlag = false; Vls.ErrorMessage = "Record not available"; } } catch (Exception ex) { Vls.SaveFlag = false; // unit.ErrorMessage = exceptionMessage; } return(Vls); }