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);
}
