public ActionResult BulkUpdateStatus(List<Insurance> lstMoter, string UploadType)
{
long returnCode = -1;
string InsuranceStatusJson = string.Empty;
string ErrorMsg = string.Empty;
if (Session["UserName"] != null)
{
ViewBag.UserName = Session["UserName"].ToString();
}
if (Session["RoleId"] != null)
{
ViewBag.RoleId = Session["RoleId"];
}
try
{
InsuranceStatusJson = JsonConvert.SerializeObject(lstMoter);
returnCode = new MotorBAL().BulkUpdateInsuranceStatus(InsuranceStatusJson, -1, "UserName", UploadType, out ErrorMsg);
}
catch (Exception ex)
{
throw;
}
return Json(ErrorMsg);
}
public ActionResult BulkUpdate(List <Insurance> lstInsuranceBulkUpload, string UploadType)
{
long returnCode = -1;
string InsuranceStatusJson = string.Empty;
string ErrorMsg = string.Empty;
try
{
InsuranceStatusJson = JsonConvert.SerializeObject(lstInsuranceBulkUpload);
returnCode = new MotorBAL().BulkUpdateInsurance(InsuranceStatusJson, -1, "Admin", UploadType, out ErrorMsg);
}
catch (Exception ex)
{
throw;
}
return(Json(ErrorMsg));
}
public ActionResult BulkUpdate(HttpPostedFileBase CSVFile, string hdnMsgStatus)
{
long returnCode = -1;
if (Session["UserName"] != null)
{
ViewBag.UserName = Session["UserName"].ToString();
}
if (Session["RoleId"] != null)
{
ViewBag.RoleId = Session["RoleId"];
}
string InsuranceStatusJson = string.Empty;
string ErrorMsg = string.Empty;
string ErrorMssage = string.Empty;
string _filePath = string.Empty;
string _FileName = string.Empty;
string _ConfigureFilePath = ConfigurationManager.AppSettings["BulkUploadCsvFilePath"].ToString();
try
{
if (ModelState.IsValid && hdnMsgStatus == "Y")
{
if (CSVFile.ContentLength > 0)
{
_FileName = DateTime.Now.ToString("yyyyMMddHHmmss") + "_" + Path.GetFileName(CSVFile.FileName);
_filePath = Path.Combine(Server.MapPath(_ConfigureFilePath), Path.GetFileName(_FileName));
CSVFile.SaveAs(_filePath);
}
List<CsvFileBulkUplaod> lstValues = System.IO.File.ReadAllLines(_filePath)
.Skip(1)
.Select(v => FromCsv(v))
.ToList();
List<List<CsvFileBulkUplaod>> lstValueList = lstValues.Select((x, i) => new { Index = i, Value = x })
.GroupBy(x => x.Index / 5000)
.Select(x => x.Select(v => v.Value).ToList()).ToList();
using (TransactionScope transactionScope = new TransactionScope())
{
try
{
for (int i = 0; i < lstValueList.Count; i++)
{
InsuranceStatusJson = JsonConvert.SerializeObject(lstValueList[i]);
returnCode = new MotorBAL().BulkUpdateInsurance(InsuranceStatusJson, -1, "Admin", "Bulk", out ErrorMsg);
if (ErrorMsg != "Successfully")
{
ErrorMssage = ErrorMssage + ErrorMsg;
}
}
transactionScope.Complete();
transactionScope.Dispose();
}
catch (Exception ex)
{
transactionScope.Dispose();
ViewBag.Message = "please contact Administrator";
throw ex;
}
}
if (returnCode != -1)
{
if (ErrorMssage == "Successfully")
{
ViewBag.Message = "Upload Successfully";
}
else
{
ViewBag.Message = "Upload Successfully, Please Check already exists Policy NOs : " + ErrorMssage;
}
//ViewBag.Message = ErrorMsg;
System.IO.File.Delete(_filePath);
}
else
{
ViewBag.Message = "please contact Administrator";
}
}
}
catch (Exception ex)
{
ViewBag.Message = "please contact Administrator";
throw;
}
return View("BulkUpload");
}
