public List <ClientAssignCommissionCommon> GetAssignedCategoryList(ClientAssignCommissionCommon ACC) { string sql = "exec sproc_client_commission_detail"; sql += " @flag='s'"; sql += ", @agent_id=" + dao.FilterString(ACC.AgentId); sql += ", @agent_type=" + dao.FilterString(ACC.AgentType); var dt = dao.ExecuteDataTable(sql); List <ClientAssignCommissionCommon> lst = new List <ClientAssignCommissionCommon>(); if (dt != null) { foreach (DataRow item in dt.Rows) { var common = new ClientAssignCommissionCommon { AgentName = item["distributorname"].ToString(), AgentId = item["distributorid"].ToString(), AgentType = item["agent_type"].ToString(), CommissionCategoryId = item["categoryid"].ToString(), CommissionCategoryName = item["name"].ToString() }; lst.Add(common); } } return(lst); }
public ActionResult AssignCategory(string Search = "", int Pagesize = 10) { ClientAssignCommissionCommon ACC = new ClientAssignCommissionCommon(); ACC.AgentType = Session["UserType"].ToString(); ACC.AgentId = ApplicationUtilities.GetSessionValue("agentid").ToString();//Session["UserId"].ToString(); var list = comm.GetAssignedCategoryList(ACC); foreach (var item in list) { item.Action = StaticData.GetActions("AssignCommissionCategory", item.AgentId.ToString().EncryptParameter(), this, "", "/client/clientcommission/ManageAssignCategory?ID=" + item.AgentId.EncryptParameter(), ""); } IDictionary <string, string> param = new Dictionary <string, string>(); param.Add("AgentName", "Agent Name"); param.Add("AgentType", "Agent Type"); param.Add("CommissionCategoryName", "Category Name"); // param.Add("CreateDate", "Created On"); // param.Add("updatedby", "Updated By"); param.Add("Action", "Action"); ProjectGrid.column = param; var grid = ProjectGrid.MakeGrid(list, "Assign Category", Search, Pagesize, false, "", "", "Home", "Commission", "", ""); ViewData["grid"] = grid; return(View()); }
public CommonDbResponse ManageAssignCategory(ClientAssignCommissionCommon ACC) { string sql = "exec sproc_client_commission_detail "; sql += "@flag ='com_u' "; sql += ", @comm_category_id=" + dao.FilterString(ACC.CommissionCategoryId); sql += ", @distributor_id=" + dao.FilterString(ACC.AgentId); sql += ", @updated_by=" + dao.FilterString(ACC.ActionUser); return(dao.ParseCommonDbResponse(sql)); }
public ClientAssignCommissionCommon GetAssignedCategoryById(string id) { ClientAssignCommissionCommon common = new ClientAssignCommissionCommon(); string sql = "exec sproc_client_commission_detail"; sql += " @flag='sid'"; sql += ", @distributor_id=" + dao.FilterString(id); var dt = dao.ExecuteDataRow(sql); if (dt != null) { common.CommissionCategoryId = dt["agent_commission_id"].ToString(); common.AgentName = dt["agent_name"].ToString(); common.AgentId = dt["agent_id"].ToString(); } return(common); }
public ActionResult ManageAssignCategory(string ID) { ClientAssignCommissionCommon ACC = comm.GetAssignedCategoryById(ID.DecryptParameter()); ClientAssignCommissionModel ACM = new ClientAssignCommissionModel(); if (ACC != null) { ACM.AgentName = ACC.AgentName; ACM.AgentId = ACC.AgentId.EncryptParameter(); ACM.CommissionCategoryId = ACC.CommissionCategoryId; ViewBag.CommissionCategoryList = ApplicationUtilities.SetDDLValue(ICB.sproc_get_dropdown_list("016", ApplicationUtilities.GetSessionValue("agentid").ToString()), ACM.CommissionCategoryId, "Select Commission Category"); return(View(ACM)); } this.ShowPopup(1, "Error"); return(RedirectToAction("AssignCategory")); }
public ActionResult ManageAssignCategory(ClientAssignCommissionModel ACM) { if (ModelState.IsValid) { if (!string.IsNullOrEmpty(ACM.AgentId.DecryptParameter())) { ClientAssignCommissionCommon ACC = new ClientAssignCommissionCommon(); ACC.CommissionCategoryId = ACM.CommissionCategoryId; ACC.AgentId = ACM.AgentId.DecryptParameter(); ACC.ActionUser = Session["username"].ToString(); CommonDbResponse dbresp = comm.ManageAssignCategory(ACC); if (dbresp.Code == 0) { this.ShowPopup(0, dbresp.Message); return(RedirectToAction("AssignCategory")); } ACM.Msg = dbresp.Message; } } this.ShowPopup(1, "Error " + ACM.Msg); return(View(ACM)); }
public CommonDbResponse ManageAssignCategory(ClientAssignCommissionCommon ACC) { return(_repo.ManageAssignCategory(ACC)); }
public List <ClientAssignCommissionCommon> GetAssignedCategoryList(ClientAssignCommissionCommon ACC) { return(_repo.GetAssignedCategoryList(ACC)); }