public ActionResult ViewAgentDetail(string User_Name, string agentId = "", string ParentId = "") { AgentManagementModel AM = new AgentManagementModel(); if (!string.IsNullOrEmpty(ParentId) && string.IsNullOrEmpty(ParentId.DecryptParameter())) { return(RedirectToAction("Index", new { parent_id = ParentId })); } else { AM.ParentID = ParentId; } if (!string.IsNullOrEmpty(agentId)) { AM.AgentID = agentId.DecryptParameter(); if (!string.IsNullOrEmpty(AM.AgentID)) { AgentManagementCommon AC = buss.GetAgentById(AM.AgentID, User_Name.DecryptParameter()); AM = AC.MapObject <AgentManagementModel>(); AM.AgentID = AM.AgentID.EncryptParameter(); AM.UserID = AM.UserID.EncryptParameter(); AM.ParentID = AM.ParentID.EncryptParameter(); var pprovince = LoadDropdownList("province") as Dictionary <string, string>; AM.AgentProvince = pprovince.ContainsKey(AM.AgentProvince) ? pprovince.FirstOrDefault(x => x.Key == AM.AgentProvince).Value : AM.AgentProvince; return(View(AM)); } } this.ShowPopup(1, "Error"); return(RedirectToAction("Index")); }
public CommonDbResponse ManageAgentUser(AgentManagementCommon amc) { string sql = "sproc_agent_Detail_v3 "; sql += "@flag ='" + (string.IsNullOrEmpty(amc.UserID) ? "id" : "ud") + "' "; sql += ",@user_id =" + dao.FilterString(amc.UserID); sql += ",@agent_id =" + dao.FilterString(amc.AgentID); sql += ",@full_name =" + dao.FilterString(amc.FullName); sql += ",@password ="******",@action_user ="******",@action_ip =" + dao.FilterString(amc.IpAddress); sql += " ,@role_id='8'"; if (string.IsNullOrEmpty(amc.UserID)) { sql += ",@is_primary ='N'"; sql += ",@user_status ='Y'"; sql += ",@usr_type ='Agent'"; //+ dao.FilterString(amc.UserType); sql += ",@usr_type_id ='8'"; // + dao.FilterString(amc.UserType); sql += ",@user_mobile_number =" + dao.FilterString(amc.UserMobileNumber); sql += ",@user_name = " + dao.FilterString(amc.UserName); sql += ",@user_email =" + dao.FilterString(amc.UserEmail); } return(dao.ParseCommonDbResponse(sql)); }
public JsonResult ExtendCreditLimit(string agentid) { AgentManagementCommon amc = new AgentManagementCommon(); AgentCreditLimitModel aclm = new AgentCreditLimitModel(); if (!string.IsNullOrEmpty(agentid)) { string agent_id = agentid.DecryptParameter(); if (!string.IsNullOrEmpty(agent_id)) { string username = ApplicationUtilities.GetSessionValue("UserName").ToString(); amc = buss.GetAgentById(agent_id, username); aclm.AgentId = amc.AgentID.EncryptParameter(); aclm.AgentName = amc.AgentName; aclm.AgentCurrentCreditLimit = amc.AgentCreditLimit; string value = string.Empty; value = JsonConvert.SerializeObject(aclm, Formatting.Indented, new JsonSerializerSettings { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); return(Json(value, JsonRequestBehavior.AllowGet)); } } this.ShowPopup(1, "Error"); return(null); }
public List <AgentManagementCommon> GetUserList(AgentManagementCommon amc) { var Dis = new List <AgentManagementCommon>(); string sql = "sproc_agent_Detail_v3 @flag ='aguser' "; sql += ",@agent_id=" + dao.FilterString(amc.AgentID); sql += ",@user_id=" + dao.FilterString(amc.UserID); sql += ",@action_user="******"agent_id"].ToString(); Distri.UserID = dr["user_id"].ToString(); Distri.FirstName = dr["first_name"].ToString(); Distri.MiddleName = dr["middle_name"].ToString(); Distri.LastName = dr["last_name"].ToString(); Distri.FullName = dr["full_name"].ToString(); Distri.UserEmail = dr["user_email"].ToString(); Distri.UserMobileNumber = dr["user_mobile_no"].ToString(); Distri.UserName = dr["user_name"].ToString(); //Distri.UserPassword = dr["password"].ToString(); Distri.UserType = dr["usr_type"].ToString(); Distri.IsPrimary = dr["is_primary"].ToString(); Distri.UserStatus = dr["status"].ToString(); Dis.Add(Distri); } } return(Dis); }
public List <AgentManagementCommon> GetAgentList(string AgentId, string username, string parentid = "") { string sql = "Exec sproc_agent_Detail_v3"; sql += " @flag='s'"; sql += " ,@agent_type='Agent'"; sql += " ,@parent_Id=" + dao.FilterParameter(parentid); sql += " ,@agent_id=" + dao.FilterParameter(AgentId); sql += " ,@action_user="******"parent_id"].ToString(), AgentID = item["agent_id"].ToString(), AgentName = item["agent_name"].ToString(), AgentOperationType = item["agent_operation_type"].ToString(), AgentStatus = item["agent_status"].ToString(), AgentCreditLimit = item["agent_credit_limit"].ToString(), AgentMobileNumber = item["agent_mobile_no"].ToString(), AgentBalance = item["available_balance"].ToString() }; lst.Add(AC); } } return(lst); }
public ActionResult ManageAgentUser(AgentUserModel dcommon) { if (!string.IsNullOrEmpty(dcommon.UserID)) { ModelState.Remove("Password"); ModelState.Remove("ConfirmPassword"); ModelState.Remove("UserEmail"); ModelState.Remove("UserMobileNumber"); ModelState.Remove("UserName"); } if (ModelState.IsValid) { if (!string.IsNullOrEmpty(dcommon.UserID)) { dcommon.UserID = dcommon.UserID.DecryptParameter(); } if (!string.IsNullOrEmpty(dcommon.AgentID)) { dcommon.AgentID = dcommon.AgentID.DecryptParameter(); } AgentManagementCommon amcommon = new AgentManagementCommon(); amcommon = dcommon.MapObject <AgentManagementCommon>(); amcommon.ActionUser = ApplicationUtilities.GetSessionValue("username").ToString(); amcommon.IpAddress = ApplicationUtilities.GetIP(); CommonDbResponse dbresp = buss.ManageAgentUser(amcommon); if (dbresp.Code == shared.Models.ResponseCode.Success) { this.ShowPopup(0, "Save Succesfully"); return(RedirectToAction("ViewAgentUser", new { AgentId = dcommon.AgentID.EncryptParameter() })); } } this.ShowPopup(1, "Save unsuccessful.Please try again!"); return(View(dcommon)); }
public ActionResult ManageAgent(string User_Name, string agentId = "", string ParentId = "") { AgentManagementModel AM = new AgentManagementModel(); if (!string.IsNullOrEmpty(ParentId) && string.IsNullOrEmpty(ParentId.DecryptParameter())) { return(RedirectToAction("Index", new { parent_id = ParentId })); } else { AM.ParentID = ParentId; } if (!string.IsNullOrEmpty(agentId)) { AM.AgentID = agentId.DecryptParameter(); if (!string.IsNullOrEmpty(AM.AgentID)) { AgentManagementCommon AC = buss.GetAgentById(AM.AgentID, User_Name.DecryptParameter()); AM = AC.MapObject <AgentManagementModel>(); AM.AgentID = AM.AgentID.EncryptParameter(); AM.UserID = AM.UserID.EncryptParameter(); AM.ParentID = AM.ParentID.EncryptParameter(); RemoveupdateValidation(AM); } } if (string.IsNullOrEmpty(agentId)) { AM.AgentCountry = "Nepal"; } LoadDropDownList(AM); return(View(AM)); }
public ActionResult AssignRole(string AgentId, string UserId = "") { AgentManagementCommon amc = new AgentManagementCommon(); var agent_id = AgentId.DecryptParameter(); var user_id = UserId.DecryptParameter(); if (string.IsNullOrEmpty(agent_id)) { return(RedirectToAction("Index")); } if (!string.IsNullOrEmpty(UserId)) { if (string.IsNullOrEmpty(user_id)) { return(RedirectToAction("ViewAgentUser", new { AgentId = agent_id.EncryptParameter() })); } } amc.ActionUser = Session["UserName"].ToString(); amc.UserID = user_id; amc.AgentID = agent_id; var arole = buss.getAgentUserRO(amc); if (arole != null) { AgentUserRole aur = new AgentUserRole(); aur.AgentID = arole.AgentID.EncryptParameter(); aur.UserID = arole.UserID.EncryptParameter(); aur.RoleId = arole.RoleId; aur.IsPrimary = arole.IsPrimary; return(View(aur)); } return(RedirectToAction("ViewAgentUser", new { AgentId = agent_id.EncryptParameter() })); }
public CommonDbResponse ResetPassword(AgentManagementCommon Common) { string sql = "sproc_agent_Detail_v3 @flag = 'rpass'"; sql += ", @agent_id=" + dao.FilterString(Common.AgentID); sql += ", @user_id=" + dao.FilterString(Common.UserID); sql += ", @action_user="******", @created_ip=" + DAO.FilterString(Common.ActionIP); return(dao.ParseCommonDbResponse(sql)); }
public CommonDbResponse Disable_EnableAgent(AgentManagementCommon amc) { string sql = "sproc_agent_Detail_v3 "; sql += " @flag='eau'"; sql += ",@agent_id=" + dao.FilterString(amc.AgentID); sql += ",@action_user="******",@user_status=" + dao.FilterString(amc.UserStatus); return(dao.ParseCommonDbResponse(sql)); }
public CommonDbResponse AssignAgentUserRole(AgentManagementCommon amc) { string sql = "Exec sproc_agent_detail"; sql += " @flag='drole'"; sql += " ,@user_id=" + dao.FilterString(amc.UserID); sql += " ,@agent_id=" + dao.FilterString(amc.AgentID); sql += " ,@is_primary=" + dao.FilterString(amc.IsPrimary); sql += " ,@role_id='8'";// + dao.FilterString(RoleId); return(dao.ParseCommonDbResponse(sql)); }
public ActionResult ViewAgentUser(string AgentId = "", string ParentId = "") { string parentID = ParentId.DecryptParameter(); string agentId = AgentId.DecryptParameter(); if (!string.IsNullOrEmpty(ParentId)) { if (string.IsNullOrEmpty(parentID)) { return(RedirectToAction("Index", new { parent_id = parentID.EncryptParameter() })); } } if (!string.IsNullOrEmpty(AgentId)) { if (string.IsNullOrEmpty(agentId)) { return(RedirectToAction("Index", new { parent_id = parentID.EncryptParameter(), AgentId = agentId.EncryptParameter() })); } } AgentManagementCommon amc = new AgentManagementCommon(); amc.AgentID = agentId; amc.ActionUser = Session["UserName"].ToString(); var AgentCommon = buss.GetUserList(amc); //Actions foreach (var item in AgentCommon) { item.Action = StaticData.GetActions("ViewAgentUser", item.UserID.EncryptParameter(), this, "", "", item.AgentID.EncryptParameter(), item.UserStatus, parentID.EncryptParameter(), item.IsPrimary.Trim()); item.UserStatus = "<span class='badge badge-" + (item.UserStatus.Trim().ToUpper() == "Y" ? "success" : "danger") + "'>" + (item.UserStatus.Trim().ToUpper() == "Y" ? "Active" : "Blocked") + "</span>"; item.IsPrimary = "<span class='badge badge-" + (item.IsPrimary.Trim().ToUpper() == "Y" ? "success" : "danger") + "'>" + (item.IsPrimary.Trim().ToUpper() == "Y" ? "Primary" : "Secondary") + "</span>"; } //Column Creator IDictionary <string, string> param = new Dictionary <string, string>(); //param.Add("AgentId", "Agent Id"); param.Add("FullName", "Full Name"); param.Add("UserName", "User Name"); param.Add("UserEmail", "Email"); param.Add("UserMobileNumber", "Mobile Number"); //param.Add("UserType", "User Type"); param.Add("IsPrimary", "Is primary"); param.Add("UserStatus", "Status"); param.Add("Action", "Action"); ProjectGrid.column = param; //Ends //Add New var grid = ProjectGrid.MakeGrid(AgentCommon, "Agent Users", "", 0, true, "", "", "Home", "Agent", "/Admin/AgentManagement/ManageAgentUser", "/Admin/AgentManagement/ManageAgentUser?AgentId=" + agentId.EncryptParameter()); ViewData["grid"] = grid; return(View()); }
public JsonResult ResetPassword(string userid, string agentid) { var data = new CommonDbResponse(); bool valid = true; if (!string.IsNullOrEmpty(userid)) { userid = userid.DecryptParameter(); if (string.IsNullOrEmpty(userid)) { data = new CommonDbResponse { ErrorCode = 1, Message = "Invalid User." }; valid = false; } } if (!string.IsNullOrEmpty(agentid)) { agentid = agentid.DecryptParameter(); if (string.IsNullOrEmpty(agentid)) { data = new CommonDbResponse { ErrorCode = 1, Message = "Invalid User." }; valid = false; } } if (valid) { AgentManagementCommon DMC = new AgentManagementCommon() { UserID = userid, AgentID = agentid, UserStatus = "Y", ActionUser = ApplicationUtilities.GetSessionValue("username").ToString(), IpAddress = ApplicationUtilities.GetIP() }; data = buss.ResetPassword(DMC); //if (data.ErrorCode == 0) //{ // data.Message = "User Password Reset Successfully"; //} } data.SetMessageInTempData(this); return(Json(data)); }
public ActionResult ManageAgentUser(string AgentId, string UserId = "") { AgentUserModel Agentmodel = new AgentUserModel(); var Agent_id = AgentId.DecryptParameter(); var user_id = UserId.DecryptParameter(); if (string.IsNullOrEmpty(Agent_id)) { return(RedirectToAction("Index")); } if (!string.IsNullOrEmpty(UserId)) { if (string.IsNullOrEmpty(user_id)) { return(RedirectToAction("ViewAgentUser", new { AgentId = AgentId })); } AgentManagementCommon amc = new AgentManagementCommon(); amc.AgentID = Agent_id; amc.ActionUser = Session["UserName"].ToString(); amc.UserID = user_id; var agentUserList = buss.GetUserList(amc);//.FirstOrDefault(); if (agentUserList.Count > 0) { var agentm = agentUserList.FirstOrDefault(); Agentmodel.UserID = agentm.UserID.EncryptParameter(); Agentmodel.FullName = agentm.FullName; Agentmodel.UserEmail = agentm.UserEmail; Agentmodel.UserMobileNumber = agentm.UserMobileNumber; Agentmodel.UserStatus = agentm.UserStatus; Agentmodel.UserName = agentm.UserName; } else { ApplicationUtilities.ShowPopup(this, 1, "User Not Found!"); return(RedirectToAction("ViewAgentUser", new { AgentId = AgentId })); } } Agentmodel.AgentID = AgentId; return(View(Agentmodel)); }
public AgentManagementCommon getAgentUserRO(AgentManagementCommon amc) { string sql = "Exec sproc_agent_detail_v3"; sql += " @flag='grole'"; sql += " ,@user_id=" + dao.FilterString(amc.UserID); sql += " ,@agent_id=" + dao.FilterString(amc.AgentID); sql += " ,@action_user="******"user_id"].ToString(); RC.AgentID = dt["Agent_id"].ToString(); RC.RoleId = dt["role_id"].ToString(); RC.IsPrimary = dt["is_primary"].ToString(); } return(RC); }
public ActionResult AssignRole(AgentUserRole dcommon) { var agent_id = dcommon.AgentID.DecryptParameter(); var user_id = dcommon.UserID.DecryptParameter(); if (string.IsNullOrEmpty(agent_id)) { return(RedirectToAction("Index")); } if (!string.IsNullOrEmpty(dcommon.UserID)) { if (string.IsNullOrEmpty(user_id)) { return(RedirectToAction("ViewAgentUser", new { AgentId = agent_id.EncryptParameter() })); } } if (ModelState.IsValid) { var isPrimary = "n"; if (dcommon.IsPrimary == "on") { isPrimary = "y"; } AgentManagementCommon amc = new AgentManagementCommon(); amc.UserName = Session["UserName"].ToString(); amc.UserID = user_id; amc.AgentID = agent_id; amc.IsPrimary = isPrimary; amc.RoleId = dcommon.RoleId; CommonDbResponse dbresp = buss.AssignAgentUserRole(amc); if (dbresp.Code == 0) { this.ShowPopup(0, "Role Assigned Successfully."); return(RedirectToAction("ViewAgentUser", new { AgentId = agent_id.EncryptParameter() })); } } this.ShowPopup(1, "Failed to assign role to user!"); return(View(dcommon)); }
public JsonResult DisableAgent(string AgentId) { if (!string.IsNullOrEmpty(AgentId)) { if (!string.IsNullOrEmpty(AgentId.DecryptParameter())) { AgentManagementCommon amc = new AgentManagementCommon(); amc.AgentID = AgentId.DecryptParameter(); amc.IpAddress = ApplicationUtilities.GetIP(); amc.ActionUser = ApplicationUtilities.GetSessionValue("username").ToString(); amc.UserStatus = "N"; CommonDbResponse dbresp = buss.Disable_EnableAgent(amc); if (dbresp.ErrorCode == 0) { dbresp.Message = "Successfully Blocked Agent"; dbresp.SetMessageInTempData(this); } return(Json(dbresp)); } } return(Json(new CommonDbResponse { ErrorCode = 1, Message = "Invalid Agent." })); }
public CommonDbResponse ManageAgent(AgentManagementCommon AC) { return(repo.ManageAgent(AC)); }
public CommonDbResponse ManageAgentUser(AgentManagementCommon amc) { return(repo.ManageAgentUser(amc)); }
public CommonDbResponse Disable_EnableAgentUser(AgentManagementCommon amc) { return(repo.Disable_EnableAgentUser(amc)); }
public CommonDbResponse ResetPassword(AgentManagementCommon Common) { return(repo.ResetPassword(Common)); }
public CommonDbResponse AssignAgentUserRole(AgentManagementCommon amc) { return(repo.AssignAgentUserRole(amc)); }
public AgentManagementCommon getAgentUserRO(AgentManagementCommon amc) { return(repo.getAgentUserRO(amc)); }
public AgentManagementCommon GetAgentById(string AgentId, string username) { string sql = "Exec sproc_agent_Detail_v3"; sql += " @flag='ds'"; sql += ", @agent_id=" + dao.FilterString(AgentId); sql += ", @action_user="******"agent_type"].ToString(); AC.AgentID = dt["agent_id"].ToString(); AC.ParentID = dt["parent_id"].ToString(); AC.AgentOperationType = dt["agent_operation_type"].ToString(); string test = dt["is_auto_commission"].ToString(); AC.AgentCommissionType = dt["is_auto_commission"].ToString().ToUpper() == "TRUE" ? true : false;//dt[""].ToString(); AC.AgentName = dt["agent_name"].ToString(); AC.AgentPhoneNumber = dt["agent_phone_no"].ToString(); AC.AgentMobileNumber = dt["agent_mobile_no"].ToString(); AC.AgentEmail = dt["agent_email_address"].ToString(); // AC.AgentWebUrl = dt["agent_web_url"].ToString(); AC.AgentWebUrl = dt["web_url"].ToString(); AC.AgentRegistrationNumber = dt["agent_registration_no"].ToString(); AC.AgentPanNumber = dt["agent_pan_no"].ToString(); AC.AgentContractDate = dt["agent_contract_local_date"].ToString(); AC.AgentContractDate_BS = dt["agent_contract_nepali_date"].ToString(); AC.AgentCountry = dt["agent_country"].ToString(); //AC.AgentProvince = dt["agent_province"].ToString(); //AC.AgentDistrict = dt["agent_district"].ToString(); //AC.AgentVDC_Muncipality = dt["agent_localbody"].ToString(); //AC.AgentWardNo = dt["agent_wardno"].ToString(); //AC.AgentStreet = dt["agent_address"].ToString(); AC.AgentProvince = dt["permanent_province"].ToString(); AC.AgentDistrict = dt["permanent_district"].ToString(); AC.AgentVDC_Muncipality = dt["permanent_localbody"].ToString(); AC.AgentWardNo = dt["permanent_wardno"].ToString(); AC.AgentStreet = dt["permanent_address"].ToString(); AC.AgentCreditLimit = dt["agent_credit_limit"].ToString(); AC.AgentBalance = dt["available_balance"].ToString(); AC.AgentLogo = dt["agent_logo_img"].ToString(); //AC.AgentRegistrationCertificate = dt["agent_registeration_cert_image"].ToString(); //AC.AgentPanCertificate = dt["agent_pan_cert_image"].ToString(); AC.AgentRegistrationCertificate = dt["agent_document_img_back"].ToString(); AC.AgentPanCertificate = dt["agent_document_img_front"].ToString(); AC.UserID = dt["user_id"].ToString(); AC.UserName = dt["user_name"].ToString(); //AC.Password = dt[""].ToString(); //AC.ConfirmPassword = dt[""].ToString(); AC.FirstName = dt["first_name"].ToString(); AC.MiddleName = dt["middle_name"].ToString(); AC.LastName = dt["last_name"].ToString(); AC.UserMobileNumber = dt["user_mobile_no"].ToString(); AC.UserEmail = dt["user_email"].ToString(); AC.ContactPersonName = dt["contact_person_name"].ToString(); AC.ContactPersonMobileNumber = dt["contact_person_mobile_no"].ToString(); AC.ContactPersonIdType = dt["contact_person_id_type"].ToString(); AC.ContactPersonIdNumber = dt["contact_person_id_no"].ToString(); //AC.ContactPersonIdIssueCountry = dt[""].ToString(); AC.ContactPersonIdIssueDistrict = dt["contact_id_issued_district"].ToString(); AC.ContactPersonIdIssueDate = dt["contact_id_issue_local_date"].ToString(); AC.ContactPersonIdIssueDate_BS = dt["contact_id_issued_bs_date"].ToString(); //AC.ContactPersonIdExpiryDate = dt["contact_id_expiry_local_date"].ToString(); //AC.ContactPersonIdExpiryDate_BS = dt["contact_id_expiry_bs_date"].ToString(); } return(AC); }
public List <AgentManagementCommon> GetUserList(AgentManagementCommon amc) { return(repo.GetUserList(amc)); }
public ActionResult ManageAgent(AgentManagementModel agentModel, HttpPostedFileBase Agent_Logo, HttpPostedFileBase Pan_Certiticate, HttpPostedFileBase Registration_Certificate, string changepassword = "") { var Agent_LogoPath = ""; var Pan_CertiticatePath = ""; var Registration_CertificatePath = ""; ModelState.Remove("AgentContractDate_BS"); LoadDropDownList(agentModel); if (!string.IsNullOrEmpty(agentModel.AgentID)) { agentModel.AgentID = agentModel.AgentID.DecryptParameter(); ModelState.Remove("userName"); if (changepassword.ToUpper() != "ON") { RemoveupdateValidation(agentModel); agentModel.Password = ""; agentModel.ConfirmPassword = ""; } } if (agentModel.AgentOperationType.ToUpper() != "BUSINESS") { agentModel.AgentMobileNumber = agentModel.UserMobileNumber; agentModel.AgentEmail = agentModel.UserEmail; RemoveBusinessValidation(agentModel); } if (ModelState.IsValid) { AgentManagementCommon AC = new AgentManagementCommon(); AC = agentModel.MapObject <AgentManagementCommon>(); if (!string.IsNullOrEmpty(AC.AgentID)) { if (string.IsNullOrEmpty(AC.AgentID)) { return(View(agentModel)); } //if (string.IsNullOrEmpty(changepassword)) //{ // AC.Password = ""; // AC.ConfirmPassword = ""; //} AC.AgentID = AC.AgentID;//.DecryptParameter(); AC.UserID = AC.UserID.DecryptParameter(); } if (!string.IsNullOrEmpty(AC.ParentID)) { if (string.IsNullOrEmpty(AC.ParentID.DecryptParameter())) { return(View(agentModel)); } AC.ParentID = AC.ParentID.DecryptParameter(); } AC.ActionUser = ApplicationUtilities.GetSessionValue("UserName").ToString(); AC.IpAddress = ApplicationUtilities.GetIP(); if (Agent_Logo != null) { var contentType = Agent_Logo.ContentType; var allowedExtensions = new[] { ".jpg", ".png", ".jpeg" }; var fileName = Path.GetFileName(Agent_Logo.FileName); String timeStamp = DateTime.Now.ToString(); var ext = Path.GetExtension(Agent_Logo.FileName); if (Agent_Logo.ContentLength > 1 * 1024 * 1024)//1 MB { this.ShowPopup(1, "Image Size must be less than 1MB"); return(View(agentModel)); } if (allowedExtensions.Contains(ext.ToLower())) { string datet = DateTime.Now.ToString().Replace('/', ' ').Replace(':', ' '); string myfilename = "logo " + datet + ext.ToLower(); Agent_LogoPath = Path.Combine(Server.MapPath("~/Content/userupload/Agent"), myfilename); AC.AgentLogo = "/Content/userupload/Agent/" + myfilename; } else { this.ShowPopup(1, "File Must be .jpg,.png,.jpeg"); return(View(agentModel)); } } if (AC.AgentOperationType.ToUpper() == "BUSINESS") { if (Pan_Certiticate != null) { var allowedExtensions = new[] { ".jpg", ".png", ".jpeg" }; var fileName = Path.GetFileName(Pan_Certiticate.FileName); String timeStamp = DateTime.Now.ToString(); var ext = Path.GetExtension(Pan_Certiticate.FileName); if (Pan_Certiticate.ContentLength > 1 * 1024 * 1024)//1 MB { this.ShowPopup(1, "Image Size must be less than 1MB"); return(View(agentModel)); } if (allowedExtensions.Contains(ext.ToLower())) { string datet = DateTime.Now.ToString().Replace('/', ' ').Replace(':', ' '); string myfilename = "pan " + datet + ext.ToLower(); Pan_CertiticatePath = Path.Combine(Server.MapPath("~/Content/userupload/Agent"), myfilename); AC.AgentPanCertificate = "/Content/userupload/Agent/" + myfilename; } else { this.ShowPopup(1, "File Must be .jpg,.png,.jpeg"); return(View(agentModel)); } } if (Registration_Certificate != null) { var allowedExtensions = new[] { ".jpg", ".png", ".jpeg" }; var fileName = Path.GetFileName(Registration_Certificate.FileName); String timeStamp = DateTime.Now.ToString(); var ext = Path.GetExtension(Registration_Certificate.FileName); if (Registration_Certificate.ContentLength > 1 * 1024 * 1024)//1 MB { this.ShowPopup(1, "Image Size must be less than 1MB"); return(View(agentModel)); } if (allowedExtensions.Contains(ext.ToLower())) { string datet = DateTime.Now.ToString().Replace('/', ' ').Replace(':', ' '); string myfilename = "reg" + datet + ext.ToLower(); Registration_CertificatePath = Path.Combine(Server.MapPath("~/Content/userupload/Agent"), myfilename); AC.AgentRegistrationCertificate = "/Content/userupload/Agent/" + myfilename; //Registration_Certificate.SaveAs(path); } else { this.ShowPopup(1, "File Must be .jpg,.png,.jpeg"); return(View(agentModel)); } } } CommonDbResponse dbresp = buss.ManageAgent(AC); if (dbresp.Code == 0) { if (AC.AgentOperationType.ToUpper() == "BUSINESS") { if (Pan_Certiticate != null) { Pan_Certiticate.SaveAs(Pan_CertiticatePath); } if (Registration_Certificate != null) { Registration_Certificate.SaveAs(Registration_CertificatePath); } } if (Agent_Logo != null) { Agent_Logo.SaveAs(Agent_LogoPath); } this.ShowPopup(0, dbresp.Message); return(RedirectToAction("Index", new { parent_id = agentModel.ParentID })); } agentModel.Msg = dbresp.Message; } this.ShowPopup(1, "Error " + agentModel.Msg); return(View(agentModel)); }
public CommonDbResponse ManageAgent(AgentManagementCommon AC) { string sql = "sproc_agent_Detail_v3 "; sql += "@flag='" + (string.IsNullOrEmpty(AC.AgentID) ? "i" : "u") + "'"; sql += " ,@agent_type='Agent'"; sql += " ,@agent_id=" + dao.FilterString(AC.AgentID); sql += " ,@agent_operation_type=" + dao.FilterString(AC.AgentOperationType); sql += " ,@agent_commission_type=" + AC.AgentCommissionType; // sql += " ,@agent_mobile_no=" + dao.FilterString(AC.AgentMobileNumber); //sql += " ,@agent_contract_date_bs=" + dao.FilterString(AC.AgentContractDate_BS); sql += " ,@agent_country=" + dao.FilterString(AC.AgentCountry); sql += " ,@agent_province=" + dao.FilterString(AC.AgentProvince); sql += " ,@agent_district=" + dao.FilterString(AC.AgentDistrict); sql += " ,@agent_local_body=" + dao.FilterString(AC.AgentVDC_Muncipality); sql += " ,@agent_ward_number=" + dao.FilterString(AC.AgentWardNo); sql += " ,@agent_street=" + dao.FilterString(AC.AgentStreet); sql += " ,@agent_available_balance=" + dao.FilterString(AC.AgentBalance); sql += " ,@agent_logo=" + dao.FilterString(AC.AgentLogo); sql += " ,@agent_name=" + dao.FilterString(AC.AgentName); //user info sql += " ,@user_id=" + dao.FilterString(AC.UserID); sql += " ,@first_name=" + dao.FilterString(AC.FirstName); sql += " ,@middle_name=" + dao.FilterString(AC.MiddleName); sql += " ,@last_name=" + dao.FilterString(AC.LastName); //contact Person sql += " ,@contact_person_name=" + dao.FilterString(AC.ContactPersonName); sql += " ,@contact_person_mobile_number=" + dao.FilterString(AC.ContactPersonMobileNumber); sql += " ,@contact_person_ID_type=" + dao.FilterString(AC.ContactPersonIdType); sql += " ,@contact_person_ID_no=" + dao.FilterString(AC.ContactPersonIdNumber); //sql += " ,@contact_person_id_issue_country=" + dao.FilterString(AC.ContactPersonIdIssueCountry); sql += " ,@contact_person_id_issue_district=" + dao.FilterString(AC.ContactPersonIdIssueDistrict); sql += " ,@contact_person_Id_issue_date=" + dao.FilterString(AC.ContactPersonIdIssueDate); sql += " ,@contact_person_id_issue_date_nepali=" + dao.FilterString(AC.ContactPersonIdIssueDate_BS); sql += " ,@contact_person_id_expiry_date=" + dao.FilterString(AC.ContactPersonIdExpiryDate); sql += " ,@contact_person_id_expiry_date_nepali=" + dao.FilterString(AC.ContactPersonIdExpiryDate_BS); sql += " ,@action_user="******" ,@action_ip=" + dao.FilterString(AC.IpAddress); sql += " ,@action_platform=''";// + dao.FilterString(AC.IpAddress); sql += " ,@role_id='8'"; sql += " ,@usr_type='Agent'"; sql += " ,@usr_type_id='8'"; //sql += " ,@agent_mobile_no=" + dao.FilterString(AC.AgentMobileNumber); //sql += " ,@agent_email=" + dao.FilterString(AC.AgentEmail); if (!string.IsNullOrEmpty(AC.Password)) { sql += " ,@password="******" ,@confirm_password="******"BUSINESS") { sql += " ,@agent_web_url=" + dao.FilterString(AC.AgentWebUrl); sql += " ,@agent_registration_no=" + dao.FilterString(AC.AgentRegistrationNumber); sql += " ,@agent_Pan_no=" + dao.FilterString(AC.AgentPanNumber); sql += " ,@agent_contract_date=" + dao.FilterString(AC.AgentContractDate); sql += " ,@agent_reg_certificate=" + dao.FilterString(AC.AgentRegistrationCertificate); sql += " ,@agent_pan_Certificate=" + dao.FilterString(AC.AgentPanCertificate); sql += " ,@agent_mobile_no=" + dao.FilterString(AC.AgentMobileNumber); sql += " ,@agent_email=" + dao.FilterString(AC.AgentEmail); } else { sql += " ,@agent_mobile_no=" + dao.FilterString(AC.UserMobileNumber); sql += " ,@agent_email=" + dao.FilterString(AC.UserEmail); } if (string.IsNullOrEmpty(AC.AgentID)) { //user Information sql += " ,@agent_name=" + dao.FilterString(AC.AgentName); sql += " ,@agent_credit_limit=" + dao.FilterString(AC.AgentCreditLimit); sql += " ,@user_name=" + dao.FilterString(AC.UserName); sql += " ,@user_mobile_number=" + dao.FilterString(AC.UserMobileNumber); sql += " ,@user_email=" + dao.FilterString(AC.UserEmail); sql += " ,@parent_id=" + dao.FilterString(AC.ParentID); } return(dao.ParseCommonDbResponse(sql)); }