public List <CommissionCategoryDetailCommon> GetAgentCommissionCategoryProductList(string Id)
{
string sql = "exec sproc_agent_commission_detail";
sql += " @flag='cid'";
sql += ",@comm_category_id=" + dao.FilterString(Id);
var dt = dao.ExecuteDataTable(sql);
List <CommissionCategoryDetailCommon> CDC = new List <CommissionCategoryDetailCommon>();
if (dt != null)
{
foreach (DataRow item in dt.Rows)
{
var common = new CommissionCategoryDetailCommon
{
CommissionDetailId = item["com_detail_id"].ToString(),
CommissionCategoryId = item["com_category_id"].ToString(),
ProductId = item["product_id"].ToString(),
ProductLabel = item["product_label"].ToString(),
CommissionType = item["commission_type"].ToString(),
CommissionValue = item["commission_value"].ToString(),
CommissionPercentType = item["commission_percent_type"].ToString()
};
CDC.Add(common);
}
}
return(CDC);
}
public ActionResult ManageCommissionCategoryProduct(CommissionCategoryDetailModel CMC)
{
ViewBag.productlist = ApplicationUtilities.SetDDLValue(ICB.sproc_get_dropdown_list("servicelist"), CMC.ProductId, "Select Product");
// ViewBag.CommissionPercentType = ApplicationUtilities.SetDDLValue(ICB.sproc_get_dropdown_list("031"), CMC.CommissionPercentType, "Select Percent Type");
CMC.CommissionPercentTypeList = ApplicationUtilities.SetDDLValue(ICB.sproc_get_dropdown_list("031"), CMC.CommissionPercentType, "Select Percent Type");
CMC.CommissionTypeList = LoadDropdownList("commissiontype") as List <SelectListItem>;
if (ModelState.IsValid)
{
CommissionCategoryDetailCommon CDC = new CommissionCategoryDetailCommon();
CDC.CommissionDetailId = CMC.CommissionDetailId.DecryptParameter();
CDC.ProductId = CMC.ProductId;
CDC.CommissionCategoryId = CMC.CommissionCategoryId.DecryptParameter();
CDC.CommissionType = CMC.CommissionType;
CDC.CommissionPercentType = CMC.CommissionPercentType;
CDC.CommissionValue = CMC.CommissionValue;
CDC.IpAddress = ApplicationUtilities.GetIP();
CDC.ActionUser = Session["username"].ToString();
if ((CDC.CommissionType != "F" && float.Parse(CDC.CommissionValue) > 100) || (float.Parse(CDC.CommissionValue) < 0))
{
this.ShowPopup(1, "Commission Value Mismatch");
return(View(CMC));
}
CommonDbResponse dbres = comm.ManageCommissionCategoryProduct(CDC);
if (dbres.Code == 0)
{
this.ShowPopup(0, dbres.Message);
return(RedirectToAction("CommissionProductList", new { categoryid = CMC.CommissionCategoryId }));
}
CMC.Msg = dbres.Message;
}
this.ShowPopup(1, "Error" + CMC.Msg);
return(View(CMC));
}
public ActionResult ManageAgentCommissionCategoryProduct(string id)
{
CommissionCategoryDetailCommon CDC = comm.GetAgentCommissioncategoryProductById(id.DecryptParameter());
CommissionCategoryDetailModel CMC = new CommissionCategoryDetailModel();
string agentid = Session["AgentId"].ToString();
if (CDC != null)
{
CMC.CommissionDetailId = CDC.CommissionDetailId.EncryptParameter();
CMC.ProductId = CDC.ProductId;
CMC.CommissionCategoryId = CDC.CommissionCategoryId.EncryptParameter();
CMC.CommissionType = CDC.CommissionType;
CMC.CommissionValue = CDC.CommissionValue;
string agentcommCat = comm.GetAdminCommCatagory(agentid).CommissionCategoryId;
var admincomm = comm.GetAdminCommvalue(agentcommCat, CDC.ProductId);
CMC.AdminCommissionType = admincomm.CommissionType;
CMC.AdminCommissionValue = admincomm.CommissionValue;
CMC.AdminProductId = admincomm.ProductId;
//CMC.CommissionPercentType = CDC.CommissionPercentType.Trim();
}
ViewBag.productlist = ApplicationUtilities.SetDDLValue(ICB.sproc_get_dropdown_list("servicelist"), CMC.ProductId, "Select Product");
CMC.CommissionPercentTypeList = ApplicationUtilities.SetDDLValue(ICB.sproc_get_dropdown_list("031"), CMC.CommissionPercentType, "Select Percent Type");
CMC.CommissionTypeList = LoadDropdownList("commissiontype") as List <SelectListItem>;
return(View(CMC));
}
public CommonDbResponse ManageAgentCommissionCategoryProduct(CommissionCategoryDetailCommon CDC)
{
string sql = "exec sproc_agent_commission_detail";
sql += " @flag='u'";
sql += ", @commission_type=" + dao.FilterString(CDC.CommissionType);
sql += ", @commission_value=" + dao.FilterString(CDC.CommissionValue);
sql += ", @commission_percent_type=" + dao.FilterString(CDC.CommissionPercentType);
sql += ", @updated_by=" + dao.FilterString(CDC.ActionUser);
sql += ", @updated_ip=" + dao.FilterString(CDC.IpAddress);
sql += ", @product_id=" + dao.FilterString(CDC.ProductId);
sql += ", @comm_category_detail_id=" + dao.FilterString(CDC.CommissionDetailId);
sql += ", @comm_category_id=" + dao.FilterString(CDC.CommissionCategoryId);
return(dao.ParseCommonDbResponse(sql));
}
public CommissionCategoryDetailCommon GetAdminCommvalue(string catId, string productId)
{
CommissionCategoryDetailCommon common = new CommissionCategoryDetailCommon();
string sql = "exec sproc_agent_commission_detail";
sql += " @flag='comm_prod'";
sql += ", @comm_category_id=" + dao.FilterString(catId);
sql += ", @product_id=" + dao.FilterString(productId);
var dt = dao.ExecuteDataRow(sql);
if (dt != null)
{
common.CommissionType = dt["commission_type"].ToString();
common.CommissionValue = dt["commission_value"].ToString();
//common.ProductId = dt["product_id"].ToString();
}
return(common);
}
public CommissionCategoryDetailCommon GetAgentCommissioncategoryProductById(string id)
{
string sql = "exec sproc_agent_commission_detail";
sql += " @flag='scp'";
sql += ",@comm_category_detail_id=" + dao.FilterString(id);
var dt = dao.ExecuteDataRow(sql);
CommissionCategoryDetailCommon CDC = new CommissionCategoryDetailCommon();
if (dt != null)
{
CDC.CommissionDetailId = dt["com_detail_id"].ToString();
CDC.CommissionCategoryId = dt["com_category_id"].ToString();
CDC.ProductId = dt["product_id"].ToString();
CDC.CommissionType = dt["commission_type"].ToString();
CDC.CommissionValue = dt["commission_value"].ToString();
CDC.CommissionPercentType = dt["commission_percent_type"].ToString();
}
return(CDC);
}
public ActionResult ManageCommissionCategoryProduct(string id)
{
CommissionCategoryDetailCommon CDC = comm.GetCommissioncategoryProductById(id.DecryptParameter());
CommissionCategoryDetailModel CMC = new CommissionCategoryDetailModel();
if (CDC != null)
{
CMC.CommissionDetailId = CDC.CommissionDetailId.EncryptParameter();
CMC.ProductId = CDC.ProductId;
CMC.CommissionCategoryId = CDC.CommissionCategoryId.EncryptParameter();
CMC.CommissionType = CDC.CommissionType;
CMC.CommissionValue = CDC.CommissionValue;
CMC.CommissionPercentType = CDC.CommissionPercentType.Trim();
}
ViewBag.productlist = ApplicationUtilities.SetDDLValue(ICB.sproc_get_dropdown_list("servicelist"), CMC.ProductId, "Select Product");
CMC.CommissionPercentTypeList = ApplicationUtilities.SetDDLValue(ICB.sproc_get_dropdown_list("031"), CMC.CommissionPercentType, "Select Percent Type");
CMC.CommissionTypeList = LoadDropdownList("commissiontype") as List <SelectListItem>;
return(View(CMC));
}
public CommonDbResponse ManageAgentCommissionCategoryProduct(CommissionCategoryDetailCommon CDC)
{
return(_repo.ManageAgentCommissionCategoryProduct(CDC));
}
