//public async Task<JsonResult> POSTADDMerchantInformation(TBL_MASTER_MEMBER objsupermem, HttpPostedFileBase AadhaarFile, HttpPostedFileBase PanFile) public async Task <JsonResult> POSTADDMerchantInformation(TBL_MASTER_MEMBER objsupermem) { initpage();//// var db = new DBContext(); using (System.Data.Entity.DbContextTransaction ContextTransaction = db.Database.BeginTransaction()) { try { //if (objsupermem.AADHAAR_NO != null || AadhaarFile != null) //{ // if (AadhaarFile == null) // { // ViewBag.checkstatus = "0"; // ModelState.AddModelError("AADHAAR_NO", "Please Upload Aadhaar Card Image..."); // return Json("Please Upload Aadhaar Card Image...", JsonRequestBehavior.AllowGet); // } // else if (objsupermem.AADHAAR_NO == null) // { // ViewBag.checkstatus = "0"; // ModelState.AddModelError("AADHAAR_NO", "Please give Aadhaar Card Number..."); // return Json("Please give Aadhaar Card Number...", JsonRequestBehavior.AllowGet); // } //} //if (objsupermem.PAN_NO != null || PanFile != null) //{ // if (PanFile == null) // { // ModelState.AddModelError("AADHAAR_NO", "Please Upload Pan Card Image..."); // return Json("Please Upload Pan Card Image...", JsonRequestBehavior.AllowGet); // } // else if (objsupermem.PAN_NO == null) // { // ModelState.AddModelError("AADHAAR_NO", "Please give Pan Card Number..."); // return Json("Please give Pan Card Number...", JsonRequestBehavior.AllowGet); // } //} objsupermem.BALANCE = 0; if (objsupermem.BLOCKED_BALANCE == null) { objsupermem.BLOCKED_BALANCE = 0; objsupermem.BALANCE = 0; } else { objsupermem.BLOCKED_BALANCE = objsupermem.BLOCKED_BALANCE; objsupermem.BALANCE = objsupermem.BLOCKED_BALANCE; } var underWhitelevel = db.TBL_MASTER_MEMBER.FirstOrDefault(x => x.MEM_ID == MemberCurrentUser.MEM_ID); objsupermem.EMAIL_ID = objsupermem.EMAIL_ID.ToLower(); objsupermem.UNDER_WHITE_LEVEL = underWhitelevel.INTRODUCER; objsupermem.INTRODUCER = objsupermem.DISTRIBUTOR_ID; //objsupermem.BLOCKED_BALANCE = 0; objsupermem.ACTIVE_MEMBER = true; objsupermem.IS_DELETED = false; objsupermem.JOINING_DATE = System.DateTime.Now; //objsupermem.CREATED_BY = long.Parse(Session["UserId"].ToString()); objsupermem.CREATED_BY = MemberCurrentUser.MEM_ID; //objsupermem.CREATED_BY = CurrentUser.USER_ID; objsupermem.LAST_MODIFIED_DATE = System.DateTime.Now; objsupermem.GST_MODE = 1; objsupermem.TDS_MODE = 1; objsupermem.DUE_CREDIT_BALANCE = 0; objsupermem.CREDIT_BALANCE = 0; objsupermem.IS_TRAN_START = true; db.TBL_MASTER_MEMBER.Add(objsupermem); await db.SaveChangesAsync(); string aadhaarfilename = string.Empty; string Pancardfilename = string.Empty; ////Checking file is available to save. //if (AadhaarFile != null) //{ // string aadharpath = Path.GetFileName(AadhaarFile.FileName); // string AadharfileName = aadharpath.Substring(aadharpath.LastIndexOf(((char)92)) + 1); // int index = AadharfileName.LastIndexOf('.'); // string onyName = AadharfileName.Substring(0, index); // string fileExtension = AadharfileName.Substring(index + 1); // var AadhaarFileName = objsupermem.MEM_ID + "_" + objsupermem.AADHAAR_NO + "." + fileExtension; // //var AdharServerSavePath = Path.Combine(Server.MapPath("~/MemberFiles/") + AadhaarFileName); // var AdharServerSavePath = (Server.MapPath(@"/MemberFiles/") + AadhaarFileName); // aadhaarfilename = "/MemberFiles/" + AadhaarFileName; // AadhaarFile.SaveAs(AdharServerSavePath); //} //if (PanFile != null) //{ // string Pannopath = Path.GetFileName(PanFile.FileName); // string PannofileName = Pannopath.Substring(Pannopath.LastIndexOf(((char)92)) + 1); // int index = PannofileName.LastIndexOf('.'); // string onyName = PannofileName.Substring(0, index); // string PanfileExtension = PannofileName.Substring(index + 1); // var InputPanCard = objsupermem.MEM_ID + "_" + objsupermem.PAN_NO + "." + PanfileExtension; // //var PanserverSavePath = Path.Combine(Server.MapPath("~/MemberFiles/") + InputPanCard); // var PanserverSavePath = (Server.MapPath(@"/MemberFiles/") + InputPanCard); // Pancardfilename = "/MemberFiles/" + InputPanCard; // PanFile.SaveAs(PanserverSavePath); //} var imageupload = db.TBL_MASTER_MEMBER.Find(objsupermem.MEM_ID); imageupload.AADHAAR_FILE_NAME = aadhaarfilename; imageupload.PAN_FILE_NAME = Pancardfilename; db.Entry(imageupload).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); var servlist = await db.TBL_SETTINGS_SERVICES_MASTER.ToListAsync(); foreach (var lst in servlist) { TBL_WHITELABLE_SERVICE objser = new TBL_WHITELABLE_SERVICE() { MEMBER_ID = long.Parse(objsupermem.MEM_ID.ToString()), SERVICE_ID = long.Parse(lst.SLN.ToString()), ACTIVE_SERVICE = false }; db.TBL_WHITELABLE_SERVICE.Add(objser); await db.SaveChangesAsync(); } //ViewBag.savemsg = "Data Saved Successfully"; //Session["msg"] = "Data Saved Successfully"; //ContextTransaction.Commit(); //throw new Exception(); ContextTransaction.Commit(); return(Json("Merchant Added Successfully", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ContextTransaction.Rollback(); Logger.Error("Controller:- MemberChannelRegistration(Admin), method:- ADDSUPERDISTRIBUTOR (POST) Line No:- 230", ex); throw ex; return(Json("Please Try After Sometime", JsonRequestBehavior.AllowGet)); //return View("Error", new HandleErrorInfo(ex, "APILabel", "CreateMember")); } } }
public async Task <ActionResult> CreateMember(TBL_MASTER_MEMBER value, HttpPostedFileBase AadhaarFile, HttpPostedFileBase PanFile) { var db = new DBContext(); using (System.Data.Entity.DbContextTransaction ContextTransaction = db.Database.BeginTransaction()) { try { var whiteleveluser = await db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == MemberCurrentUser.MEM_ID).FirstOrDefaultAsync(); var CheckUser = await db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == value.MEM_ID).FirstOrDefaultAsync(); if (CheckUser == null) { if (value.AADHAAR_NO != null || AadhaarFile != null) { if (AadhaarFile == null) { ViewBag.checkstatus = "0"; ModelState.AddModelError("AADHAAR_NO", "Please Upload Aadhaar Card Image..."); return(View("CreateMember", value)); } else if (value.AADHAAR_NO == null) { ViewBag.checkstatus = "0"; ModelState.AddModelError("AADHAAR_NO", "Please give Aadhaar Card Number..."); return(View("CreateMember", value)); } } if (value.PAN_NO != null || PanFile != null) { if (PanFile == null) { ModelState.AddModelError("AADHAAR_NO", "Please Upload Pan Card Image..."); return(View("CreateMember", value)); } else if (value.PAN_NO == null) { ModelState.AddModelError("AADHAAR_NO", "Please give Pan Card Number..."); return(View("CreateMember", value)); } } value.BALANCE = 0; if (value.BLOCKED_BALANCE == null) { value.BLOCKED_BALANCE = 0; } else { value.BLOCKED_BALANCE = value.BLOCKED_BALANCE; } value.UNDER_WHITE_LEVEL = whiteleveluser.UNDER_WHITE_LEVEL; value.INTRODUCER = MemberCurrentUser.MEM_ID; //value.BLOCKED_BALANCE = 0; value.ACTIVE_MEMBER = true; value.IS_DELETED = false; value.JOINING_DATE = System.DateTime.Now; //value.CREATED_BY = long.Parse(Session["UserId"].ToString()); value.CREATED_BY = MemberCurrentUser.MEM_ID; //value.CREATED_BY = CurrentUser.USER_ID; value.LAST_MODIFIED_DATE = System.DateTime.Now; db.TBL_MASTER_MEMBER.Add(value); await db.SaveChangesAsync(); string aadhaarfilename = string.Empty; string Pancardfilename = string.Empty; //Checking file is available to save. if (AadhaarFile != null) { string aadharpath = Path.GetFileName(AadhaarFile.FileName); string AadharfileName = aadharpath.Substring(aadharpath.LastIndexOf(((char)92)) + 1); int index = AadharfileName.LastIndexOf('.'); string onyName = AadharfileName.Substring(0, index); string fileExtension = AadharfileName.Substring(index + 1); var AadhaarFileName = value.MEM_ID + "_" + value.AADHAAR_NO + "." + fileExtension; //var AdharServerSavePath = Path.Combine(Server.MapPath("~/MemberFiles/") + AadhaarFileName); var AdharServerSavePath = (Server.MapPath(@"/MemberFiles/") + AadhaarFileName); aadhaarfilename = "/MemberFiles/" + AadhaarFileName; AadhaarFile.SaveAs(AdharServerSavePath); } if (PanFile != null) { string Pannopath = Path.GetFileName(PanFile.FileName); string PannofileName = Pannopath.Substring(Pannopath.LastIndexOf(((char)92)) + 1); int index = PannofileName.LastIndexOf('.'); string onyName = PannofileName.Substring(0, index); string PanfileExtension = PannofileName.Substring(index + 1); var InputPanCard = value.MEM_ID + "_" + value.PAN_NO + "." + PanfileExtension; //var PanserverSavePath = Path.Combine(Server.MapPath("~/MemberFiles/") + InputPanCard); var PanserverSavePath = (Server.MapPath(@"/MemberFiles/") + InputPanCard); Pancardfilename = "/MemberFiles/" + InputPanCard; PanFile.SaveAs(PanserverSavePath); } var imageupload = db.TBL_MASTER_MEMBER.Find(value.MEM_ID); imageupload.AADHAAR_FILE_NAME = aadhaarfilename; imageupload.PAN_FILE_NAME = Pancardfilename; db.Entry(imageupload).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); var servlist = await db.TBL_SETTINGS_SERVICES_MASTER.ToListAsync(); foreach (var lst in servlist) { TBL_WHITELABLE_SERVICE objser = new TBL_WHITELABLE_SERVICE() { MEMBER_ID = long.Parse(value.MEM_ID.ToString()), SERVICE_ID = long.Parse(lst.SLN.ToString()), ACTIVE_SERVICE = false }; db.TBL_WHITELABLE_SERVICE.Add(objser); await db.SaveChangesAsync(); } ViewBag.savemsg = "Data Saved Successfully"; Session["msg"] = "Data Saved Successfully"; //ContextTransaction.Commit(); } else { ViewBag.checkstatus = "1"; string aadhaarfilename = string.Empty; string Pancardfilename = string.Empty; //Checking file is available to save. if (AadhaarFile != null) { string Pannopath = Path.GetFileName(PanFile.FileName); string PannofileName = Pannopath.Substring(Pannopath.LastIndexOf(((char)92)) + 1); int index = PannofileName.LastIndexOf('.'); string onyName = PannofileName.Substring(0, index); string PanfileExtension = PannofileName.Substring(index + 1); var AadhaarFileName = value.MEM_ID + "_" + value.AADHAAR_NO + "." + PanfileExtension; //var AdharServerSavePath = Path.Combine(Server.MapPath("~/MemberFiles/") + AadhaarFileName); var AdharServerSavePath = (Server.MapPath(@"/MemberFiles/") + AadhaarFileName); aadhaarfilename = "/MemberFiles/" + AadhaarFileName; AadhaarFile.SaveAs(AdharServerSavePath); CheckUser.AADHAAR_FILE_NAME = aadhaarfilename; } if (PanFile != null) { string Pannopath = Path.GetFileName(PanFile.FileName); string PannofileName = Pannopath.Substring(Pannopath.LastIndexOf(((char)92)) + 1); int index = PannofileName.LastIndexOf('.'); string onyName = PannofileName.Substring(0, index); string PanfileExtension = PannofileName.Substring(index + 1); var InputPanCard = value.MEM_ID + "_" + value.PAN_NO + "." + PanfileExtension; //var PanserverSavePath = Path.Combine(Server.MapPath("~/MemberFiles/") + InputPanCard); var PanserverSavePath = (Server.MapPath(@"/MemberFiles/") + InputPanCard); Pancardfilename = "/MemberFiles/" + InputPanCard; PanFile.SaveAs(PanserverSavePath); CheckUser.PAN_FILE_NAME = Pancardfilename; } CheckUser.UName = value.UName; CheckUser.UNDER_WHITE_LEVEL = whiteleveluser.UNDER_WHITE_LEVEL; CheckUser.INTRODUCER = MemberCurrentUser.MEM_ID; CheckUser.AADHAAR_NO = value.AADHAAR_NO; CheckUser.PAN_NO = value.PAN_NO; //CheckUser.MEMBER_MOBILE = value.MEMBER_MOBILE; //CheckUser.UNDER_WHITE_LEVEL = value.UNDER_WHITE_LEVEL; CheckUser.MEMBER_MOBILE = value.MEMBER_MOBILE; CheckUser.MEMBER_NAME = value.MEMBER_NAME; CheckUser.COMPANY = value.COMPANY; CheckUser.MEMBER_ROLE = value.MEMBER_ROLE; //CheckUser.INTRODUCER = value.INTRODUCER; CheckUser.ADDRESS = value.ADDRESS; CheckUser.CITY = value.CITY; CheckUser.PIN = value.PIN; CheckUser.EMAIL_ID = value.EMAIL_ID; CheckUser.SECURITY_PIN_MD5 = value.SECURITY_PIN_MD5; CheckUser.BLOCKED_BALANCE = value.BLOCKED_BALANCE; db.Entry(CheckUser).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); ViewBag.savemsg = "Data Updated Successfully"; Session["msg"] = "Data Updated Successfully"; } //throw new Exception(); ContextTransaction.Commit(); return(RedirectToAction("Index")); } catch (Exception ex) { ContextTransaction.Rollback(); Logger.Error("Controller:- SuperMember(Super), method:- CreateMember (POST) Line No:- 344", ex); return(RedirectToAction("Exception", "ErrorHandler", new { area = "" })); throw ex; //return View("Error", new HandleErrorInfo(ex, "APILabel", "CreateMember")); } } }