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