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 })); }