public ActionResult AssignCategory(string Search = "", int Pagesize = 10)
{
AssignCommissionCommon ACC = new AssignCommissionCommon();
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, "", "/admin/commission/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 List <AssignCommissionCommon> GetAssignedCategoryList(AssignCommissionCommon ACC)
{
string sql = "exec sproc_agent_commission_detail";
sql += " @flag='dcom'";
sql += ", @agent_id=" + dao.FilterString(ACC.AgentId);
sql += ", @agent_type=" + dao.FilterString(ACC.AgentType);
var dt = dao.ExecuteDataTable(sql);
List <AssignCommissionCommon> lst = new List <AssignCommissionCommon>();
if (dt != null)
{
foreach (DataRow item in dt.Rows)
{
var common = new AssignCommissionCommon
{
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 CommonDbResponse ManageAssignCategory(AssignCommissionCommon ACC)
{
string sql = "exec sproc_agent_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 AssignCommissionCommon GetAdminCommCatagory(string id)
{
AssignCommissionCommon common = new AssignCommissionCommon();
string sql = "exec sproc_agent_commission_detail";
sql += " @flag='comm_idd'";
sql += ", @agent_id=" + dao.FilterString(id);
var dt = dao.ExecuteDataRow(sql);
if (dt != null)
{
common.CommissionCategoryId = dt["agent_commission_id"].ToString();
}
return(common);
}
public AssignCommissionCommon GetAssignedCategoryById(string id)
{
AssignCommissionCommon common = new AssignCommissionCommon();
string sql = "exec sproc_agent_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)
{
AssignCommissionCommon ACC = comm.GetAssignedCategoryById(ID.DecryptParameter());
AssignCommissionModel ACM = new AssignCommissionModel();
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"), ACM.CommissionCategoryId, "Select Commission Category");
return(View(ACM));
}
this.ShowPopup(1, "Error");
return(RedirectToAction("AssignCategory"));
}
public ActionResult ManageAssignCategory(AssignCommissionModel ACM)
{
if (ModelState.IsValid)
{
if (!string.IsNullOrEmpty(ACM.AgentId.DecryptParameter()))
{
AssignCommissionCommon ACC = new AssignCommissionCommon();
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(AssignCommissionCommon ACC)
{
return(_repo.ManageAssignCategory(ACC));
}
public List <AssignCommissionCommon> GetAssignedCategoryList(AssignCommissionCommon ACC)
{
return(_repo.GetAssignedCategoryList(ACC));
}
