public JsonResult UpdBPLevelDtl(BPLevelDtlModel bpLevelDtl)
{
Result data = null;
try
{
strLoginID = HttpContext.Session.GetString("loginid");
data = new Result();
string spName = "UP_BP_LEVEL_DTL_TX_INS_BULK";
string[] spParamName = new string[] {
"@pi_intBPLevelGroupNo", "@pi_strBPLevelNameList", "@pi_strBPAmtList", "@pi_strAdminID", "@po_intRetVal",
"@po_strErrMsg"
};
object[] spParamValue = new object[] {
bpLevelDtl.BPLevelGroupNo, bpLevelDtl.BPLevelName, bpLevelDtl.BPAmts, strLoginID, DBNull.Value,
DBNull.Value
};
data = dbConn.SqlExecuteSPReturnValue(spName, spParamName, spParamValue);
}
catch (Exception ex)
{
data.RetVal = 940;
data.ErrMsg = "Exception in UpdBPLevelDtl : " + ex.Message;
return(Json(data));
}
return(Json(new { data }));
}
public JsonResult DetailBPLevelDtl(BPLevelDtlModel bpLevelDtl)
{
List <BPLevelDtlModel> data = new List <BPLevelDtlModel>();
try
{
string spName = "UP_MEMBERSTORE_BPLEVEL_AR_LST";
string[] spParamName = new string[] {
"@pi_intMemberStoreNo", "@pi_intBPLevelGroupNo", "@pi_intBPLevelNo"
};
object[] spParamValue = new object[] {
bpLevelDtl.MemberStoreNo, bpLevelDtl.BPLevelGroupNo, DBNull.Value
};
Result <DataTable> result = dbConn.SqlExecuteSPReturnTable(spName, spParamName, spParamValue);
if (result.RetVal.Equals(0))
{
foreach (DataRow row in result.data.Rows)
{
BPLevelDtlModel obj = new BPLevelDtlModel
{
BPLevelName = row["BPLEVELNAME"].ToString(),
BPAmt = Convert.ToInt32(row["BPAMT"])
};
data.Add(obj);
}
}
}
catch (Exception ex)
{
Console.WriteLine("Exception in DetailBPLevelDtl : " + ex.Message);
return(Json(data));
}
return(Json(new { data }));
}
