Пример #1
0
        public FileResult downloadfiles(string type, string memid)
        {
            try
            {
                var    db           = new DBContext();
                string decrptMemId  = Decrypt.DecryptMe(memid);
                long   fid          = long.Parse(decrptMemId);
                var    filename     = new TBL_MASTER_MEMBER();
                string filepath     = string.Empty;
                string fileNameinfo = string.Empty;
                if (type == "Pan")
                {
                    filename     = db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == fid).FirstOrDefault();
                    filepath     = filename.PAN_FILE_NAME.ToString();
                    fileNameinfo = "PanCard";
                }
                else
                {
                    filename     = db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == fid).FirstOrDefault();
                    filepath     = filename.AADHAAR_FILE_NAME.ToString();
                    fileNameinfo = "AadhaarCard";
                }

                //string contentType = "application/pdf";
                string contentType = string.Empty;

                string path          = filepath;
                string fileName      = path.Substring(path.LastIndexOf(((char)92)) + 1);
                int    index         = fileName.LastIndexOf('.');
                string onyName       = fileName.Substring(0, index);
                string fileExtension = fileName.Substring(index + 1);
                if (fileExtension == "png" || fileExtension == "PNG")
                {
                    fileNameinfo = fileNameinfo + "." + fileExtension;
                    contentType  = "Images/png";
                }
                else if (fileExtension == "jpg" || fileExtension == "JPG" || fileExtension == "jpeg")
                {
                    fileNameinfo = fileNameinfo + "." + fileExtension;
                    contentType  = "Images/jpg";
                }
                else if (fileExtension == "pdf" || fileExtension == "pdf")
                {
                    fileNameinfo = fileNameinfo + "." + fileExtension;
                    contentType  = "application/pdf";
                }
                //Parameters to file are
                //1. The File Path on the File Server
                //2. The content type MIME type
                //3. The parameter for the file save by the browser
                return(File(filepath, contentType, fileNameinfo));
                //string filename = (from f in files
                //                   where f.FileId == fid
                //                   select f.FilePath).First();
            }
            catch (Exception ex)
            {
                Logger.Error("Controller:-  DistributorKYC(Distributor), method:- downloadfiles (File) Line No:- 158", ex);
                throw;
            }
        }
Пример #2
0
        public 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 CheckUser = db.TBL_MASTER_MEMBER.Where(x => x.MEM_ID == value.MEM_ID).FirstOrDefault();
                    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...");
                                var memberrole = db.TBL_MASTER_MEMBER_ROLE.Where(x => x.ROLE_NAME == "WHITE LEVEL" || x.ROLE_NAME == "API USER").ToList();
                                ViewBag.RoleDetails = new SelectList(memberrole, "ROLE_ID", "ROLE_NAME");
                                return(View("CreateMember", value));
                            }
                            else if (value.AADHAAR_NO == null)
                            {
                                ViewBag.checkstatus = "0";
                                ModelState.AddModelError("AADHAAR_NO", "Please give Aadhaar Card Number...");
                                var memberrole = db.TBL_MASTER_MEMBER_ROLE.Where(x => x.ROLE_NAME == "WHITE LEVEL" || x.ROLE_NAME == "API USER").ToList();
                                ViewBag.RoleDetails = new SelectList(memberrole, "ROLE_ID", "ROLE_NAME");
                                return(View("CreateMember", value));
                            }
                        }
                        if (value.PAN_NO != null || PanFile != null)
                        {
                            if (PanFile == null)
                            {
                                ModelState.AddModelError("AADHAAR_NO", "Please Upload Pan Card Image...");
                                var memberrole = db.TBL_MASTER_MEMBER_ROLE.Where(x => x.ROLE_NAME == "WHITE LEVEL" || x.ROLE_NAME == "API USER").ToList();
                                ViewBag.RoleDetails = new SelectList(memberrole, "ROLE_ID", "ROLE_NAME");
                                return(View("CreateMember", value));
                            }
                            else if (value.PAN_NO == null)
                            {
                                ModelState.AddModelError("AADHAAR_NO", "Please give Pan Card Number...");
                                var memberrole = db.TBL_MASTER_MEMBER_ROLE.Where(x => x.ROLE_NAME == "WHITE LEVEL" || x.ROLE_NAME == "API USER").ToList();
                                ViewBag.RoleDetails = new SelectList(memberrole, "ROLE_ID", "ROLE_NAME");
                                return(View("CreateMember", value));
                            }
                        }
                        value.BALANCE           = 0;
                        value.UNDER_WHITE_LEVEL = 0;
                        value.INTRODUCER        = 1;
                        //value.BLOCKED_BALANCE = 0;
                        value.ACTIVE_MEMBER = true;
                        if (value.BLOCKED_BALANCE == null)
                        {
                            value.BLOCKED_BALANCE = 0;
                        }
                        else
                        {
                            value.BLOCKED_BALANCE = value.BLOCKED_BALANCE;
                        }
                        value.IS_DELETED   = false;
                        value.JOINING_DATE = System.DateTime.Now;
                        //value.CREATED_BY = long.Parse(Session["UserId"].ToString());
                        value.CREATED_BY         = CurrentUser.USER_ID;
                        value.LAST_MODIFIED_DATE = System.DateTime.Now;
                        db.TBL_MASTER_MEMBER.Add(value);
                        db.SaveChanges();
                        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;
                        db.SaveChanges();
                        var servlist = db.TBL_SETTINGS_SERVICES_MASTER.ToList();
                        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);
                            db.SaveChanges();
                        }
                        ViewBag.savemsg = "Data Save Successfully";
                        Session["msg"]  = "Data Save 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;
                            CheckUser.AADHAAR_NO        = value.AADHAAR_NO;
                        }
                        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.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;
                        db.SaveChanges();
                        ViewBag.savemsg = "Data Update Successfully";
                        Session["msg"]  = "Data Update Successfully";
                    }
                    //throw new Exception();
                    ContextTransaction.Commit();
                    return(RedirectToAction("Index"));
                }
                catch (Exception ex)
                {
                    ContextTransaction.Rollback();
                    throw ex;
                    //return View("Error", new HandleErrorInfo(ex, "APILabel", "CreateMember"));
                }
            }
        }
Пример #3
0
        //[Route("WhiteLevel/Registration")]
        public async Task <ActionResult> CreateMember(string memid = "")
        {
            if (Session["WhiteLevelUserId"] != null)
            {
                try
                {
                    if (memid != "")
                    {
                        var dbcontext = new DBContext();

                        var model      = new TBL_MASTER_MEMBER();
                        var memberrole = await dbcontext.TBL_MASTER_MEMBER_ROLE.Where(x => x.ROLE_NAME != "WHITE LEVEL" && x.ROLE_NAME != "API USER").ToListAsync();

                        ViewBag.RoleDetails = new SelectList(memberrole, "ROLE_ID", "ROLE_NAME");
                        ViewBag.checkstatus = "1";
                        string decrptSlId = Decrypt.DecryptMe(memid);
                        //long Memid = long.Parse(decrptSlId);
                        long idval = long.Parse(decrptSlId);
                        ViewBag.checkmail = true;
                        model             = await dbcontext.TBL_MASTER_MEMBER.FirstOrDefaultAsync(x => x.MEM_ID == idval);

                        model.BLOCKED_BALANCE = Math.Round(Convert.ToDecimal(model.BLOCKED_BALANCE), 0); Session.Remove("msg");
                        Session.Remove("msg");
                        Session["msg"] = null;
                        return(View(model));
                        //return View("CreateMember", "MemberAPILabel", new {area ="Admin" },model);
                    }
                    else
                    {
                        var dbcontext = new DBContext();
                        ViewBag.checkstatus = "0";
                        //var memberrole = await dbcontext.TBL_MASTER_MEMBER_ROLE.Where(x => x.ROLE_NAME != "WHITE LEVEL" && x.ROLE_NAME != "API USER").ToListAsync();
                        var memberrole = await dbcontext.TBL_MASTER_MEMBER_ROLE.Where(x => x.ROLE_NAME == "SUPER DISTRIBUTOR").ToListAsync();

                        ViewBag.RoleDetails = new SelectList(memberrole, "ROLE_ID", "ROLE_NAME");
                        var user = new TBL_MASTER_MEMBER();
                        ViewBag.checkmail = false;
                        user.UName        = "";
                        Session.Remove("msg");
                        Session["msg"] = null;
                        ModelState.Clear();
                        return(View());
                    }
                }
                catch (Exception ex)
                {
                    //throw ex;
                    Logger.Error("Controller:-  MemberAPILabel(Admin), method:- CreateMember (GET) Line No:- 140", ex);
                    return(RedirectToAction("Exception", "ErrorHandler", new { area = "" }));
                    //return RedirectToAction("Notfound", "ErrorHandler");
                }
            }
            else
            {
                Session["WhiteLevelUserId"]   = null;
                Session["WhiteLevelUserName"] = null;
                Session["UserType"]           = null;
                Session.Remove("WhiteLevelUserId");
                Session.Remove("WhiteLevelUserName");
                Session.Remove("UserType");
                return(RedirectToAction("Index", "AdminLogin", new { area = "Admin" }));
            }
        }
        public async Task <ActionResult> CreateMember(string memid = "")
        {
            //long userid = long.Parse(Session["UserId"].ToString());
            if (Session["PowerAdminUserId"] != null)
            {
                try
                {
                    if (memid != "")
                    {
                        var dbcontext  = new DBContext();
                        var model      = new TBL_MASTER_MEMBER();
                        var memberrole = await dbcontext.TBL_MASTER_MEMBER_ROLE.Where(x => x.ROLE_NAME == "WHITE LEVEL" || x.ROLE_NAME == "API USER").ToListAsync();

                        ViewBag.RoleDetails = new SelectList(memberrole, "ROLE_ID", "ROLE_NAME");
                        ViewBag.checkstatus = "1";
                        string decrptSlId = Decrypt.DecryptMe(memid);
                        //long Memid = long.Parse(decrptSlId);
                        long idval = long.Parse(decrptSlId);
                        model = await dbcontext.TBL_MASTER_MEMBER.FirstOrDefaultAsync(x => x.MEM_ID == idval);

                        model.BLOCKED_BALANCE = Math.Round(Convert.ToDecimal(model.BLOCKED_BALANCE), 0);
                        ViewBag.checkmail     = true;
                        Session.Remove("msg");
                        Session["msg"] = null;
                        return(View(model));
                    }
                    else
                    {
                        var dbcontext = new DBContext();
                        ViewBag.checkstatus = "0";
                        //var memberrole =await dbcontext.TBL_MASTER_MEMBER_ROLE.Where(x => x.ROLE_NAME == "WHITE LEVEL" || x.ROLE_NAME == "API USER").ToListAsync();
                        var memberrole = await dbcontext.TBL_MASTER_MEMBER_ROLE.Where(x => x.ROLE_NAME == "WHITE LEVEL").ToListAsync();

                        ViewBag.RoleDetails = new SelectList(memberrole, "ROLE_ID", "ROLE_NAME");
                        var user = new TBL_MASTER_MEMBER();
                        Session.Remove("msg");
                        Session["msg"]    = null;
                        ViewBag.checkmail = false;
                        user.UName        = "";
                        ModelState.SetModelValue("UName", new ValueProviderResult(null, string.Empty, CultureInfo.InvariantCulture));
                        ModelState.SetModelValue("User_pwd", new ValueProviderResult(null, string.Empty, CultureInfo.InvariantCulture));
                        ModelState.Clear();
                        return(View());
                    }
                }
                catch (Exception ex)
                {
                    //throw ex;
                    Logger.Error("Controller:-  CreateMember(PowerAdmin), method:- CreateMember (GET) Line No:- 136", ex);
                    return(RedirectToAction("Exception", "ErrorHandler", new { area = "" }));
                }
            }
            else
            {
                Session["PowerAdminUserId"]   = null;
                Session["PowerAdminUserName"] = null;
                Session["UserType"]           = null;
                Session.Remove("PowerAdminUserId");
                Session.Remove("PowerAdminUserName");
                Session.Remove("UserType");
                Response.Redirect(Url.Action("Index", "PowerAdminLogin", new { area = "PowerAdmin" }));
                return(View());
            }
        }
Пример #5
0
        //public async Task<JsonResult> POSTADDMerchantDetails(TBL_MASTER_MEMBER objsupermem, HttpPostedFileBase AadhaarFile, HttpPostedFileBase PanFile)
        public async Task <JsonResult> POSTADDMerchantDetails(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;
                    }
                    objsupermem.EMAIL_ID          = objsupermem.EMAIL_ID.ToLower();
                    objsupermem.UNDER_WHITE_LEVEL = MemberCurrentUser.MEM_ID;
                    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(string memid = "")
        {
            initpage();////
            //long userid = long.Parse(Session["UserId"].ToString());
            if (Session["SuperDistributorId"] != null)
            {
                try
                {
                    if (memid != "")
                    {
                        var dbcontext = new DBContext();

                        var model      = new TBL_MASTER_MEMBER();
                        var memberrole = await dbcontext.TBL_MASTER_MEMBER_ROLE.Where(x => x.ROLE_NAME != "WHITE LEVEL" && x.ROLE_NAME != "API USER" && x.ROLE_NAME != "SUPER DISTRIBUTOR").ToListAsync();

                        ViewBag.RoleDetails = new SelectList(memberrole, "ROLE_ID", "ROLE_NAME");
                        ViewBag.checkstatus = "1";
                        string decrptSlId = Decrypt.DecryptMe(memid);
                        //long Memid = long.Parse(decrptSlId);
                        long idval = long.Parse(decrptSlId);
                        model = await dbcontext.TBL_MASTER_MEMBER.FirstOrDefaultAsync(x => x.MEM_ID == idval);

                        model.BLOCKED_BALANCE = Math.Round(Convert.ToDecimal(model.BLOCKED_BALANCE), 0); Session.Remove("msg");
                        ViewBag.checkmail     = true;
                        Session.Remove("msg");
                        Session["msg"] = null;
                        var GSTValueID = dbcontext.TBL_TAX_MASTERS.Where(x => x.TAX_NAME == "GST").ToList();
                        ViewBag.GSTValue = new SelectList(GSTValueID, "SLN", "TAX_NAME");
                        var TDSValueID = dbcontext.TBL_TAX_MASTERS.Where(x => x.TAX_NAME == "TDS").ToList();
                        ViewBag.TDSValue = new SelectList(TDSValueID, "SLN", "TAX_NAME");
                        return(View(model));
                        //return View("CreateMember", "MemberAPILabel", new {area ="Admin" },model);
                    }
                    else
                    {
                        var dbcontext = new DBContext();
                        ViewBag.checkstatus = "0";
                        var memberrole = await dbcontext.TBL_MASTER_MEMBER_ROLE.Where(x => x.ROLE_NAME != "WHITE LEVEL" && x.ROLE_NAME != "API USER" && x.ROLE_NAME != "SUPER DISTRIBUTOR").ToListAsync();

                        ViewBag.RoleDetails = new SelectList(memberrole, "ROLE_ID", "ROLE_NAME");
                        var user = new TBL_MASTER_MEMBER();
                        user.UName        = "";
                        ViewBag.checkmail = false;
                        Session.Remove("msg");
                        Session["msg"] = null;
                        var GSTValueID = dbcontext.TBL_TAX_MASTERS.Where(x => x.TAX_NAME == "GST").ToList();
                        ViewBag.GSTValue = new SelectList(GSTValueID, "SLN", "TAX_NAME");
                        var TDSValueID = dbcontext.TBL_TAX_MASTERS.Where(x => x.TAX_NAME == "TDS").ToList();
                        ViewBag.TDSValue = new SelectList(TDSValueID, "SLN", "TAX_NAME");
                        return(View());
                    }
                }
                catch (Exception ex)
                {
                    Logger.Error("Controller:-  SuperMember(Super), method:- CreateMember (GET) Line No:- 143", ex);
                    return(RedirectToAction("Exception", "ErrorHandler", new { area = "" }));
                }
            }
            else
            {
                Session["SuperDistributorId"]       = null;
                Session["SuperDistributorUserName"] = null;
                Session["UserType"] = null;
                Session.Remove("SuperDistributorId");
                Session.Remove("SuperDistributorUserName");
                Session.Remove("UserType");
                return(RedirectToAction("Index", "SuperLogin", new { area = "Super" }));
            }
        }