public JsonResult InsBPLevelGroup(BPLevelModel bpLevel)
{
Result data = null;
try
{
strLoginID = HttpContext.Session.GetString("loginid");
data = new Result();
string spName = "UP_BP_LEVEL_TX_INS";
string[] spParamName = new string[] {
"@pi_intMemberStoreNo", "@pi_strBPLevelFlag", "@pi_strAdminID", "@po_intRetVal", "@po_strErrMsg"
};
object[] spParamValue = new object[] {
bpLevel.MemberStoreNo, bpLevel.BPLevelFlag, strLoginID, DBNull.Value, DBNull.Value
};
data = dbConn.SqlExecuteSPReturnValue(spName, spParamName, spParamValue);
}
catch (Exception ex)
{
data.RetVal = 970;
data.ErrMsg = "Exception in InsBPLevelGroup : " + ex.Message;
return(Json(data));
}
return(Json(new { data }));
}
public JsonResult UpdBPLevelGroup(BPLevelModel bpLevel)
{
Result data = null;
try
{
data = new Result();
string spName = "UP_BP_LEVEL_TX_UPD";
string[] spParamName = new string[] {
"@pi_intMemberStoreNo", "@pi_intBPLevelGroupNo", "@pi_intUseState", "@po_intRetVal", "@po_strErrMsg"
};
object[] spParamValue = new object[] {
bpLevel.MemberStoreNo, bpLevel.BPLevelGroupNo, bpLevel.UseState, DBNull.Value, DBNull.Value
};
data = dbConn.SqlExecuteSPReturnValue(spName, spParamName, spParamValue);
}
catch (Exception ex)
{
data.RetVal = 960;
data.ErrMsg = "Exception in UpdBPLevelGroup : " + ex.Message;
return(Json(data));
}
return(Json(new { data }));
}
public JsonResult GetBPLevelGroupList(BPLevelModel bpLevel)
{
List <BPLevelModel> data = new List <BPLevelModel>();
try
{
string spName = "UP_MEMBERSTORE_BPLEVELGROUP_AR_LST";
string[] spParamName = new string[] {
"@pi_intMemberStoreNo"
};
object[] spParamValue = new object[] {
bpLevel.MemberStoreNo
};
Result <DataTable> result = dbConn.SqlExecuteSPReturnTable(spName, spParamName, spParamValue);
if (result.RetVal.Equals(0))
{
foreach (DataRow row in result.data.Rows)
{
BPLevelModel obj = new BPLevelModel
{
BPLevelGroupNo = Convert.ToInt64(row["BPLEVELGROUPNO"]),
MemberStoreNo = Convert.ToInt64(row["MEMBERSTORENO"]),
BPLevelFlag = row["BPLEVELFLAG"].ToString(),
UseState = Convert.ToInt16(row["USESTATE"]),
RegDate = row["REGDATE"].ToString(),
UpdDate = row["UPDDATE"].ToString() ?? ""
};
data.Add(obj);
}
}
}
catch (Exception ex)
{
Console.WriteLine("Exception in GetBPLevelGroupList : " + ex.Message);
return(Json(data));
}
return(Json(new { data }));
}
