public DataTable GetMember()
{
BaseDL bdl = new BaseDL();
SqlParameter[] prms = new SqlParameter[0];
return(bdl.SelectData("M_Member_SelecAll", prms));
}
public string Print_Genka_ProjectData(Print_GenkaModel Pmodel)
{
BaseDL bdl = new BaseDL();
Pmodel.Sqlprms = new SqlParameter[6];
Pmodel.Sqlprms[0] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = (object)Pmodel.ProjectCD ?? DBNull.Value
};
Pmodel.Sqlprms[1] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = (object)Pmodel.BrandCD ?? DBNull.Value
};
Pmodel.Sqlprms[2] = new SqlParameter("@LoginID", SqlDbType.VarChar)
{
Value = (object)Pmodel.LoginID ?? DBNull.Value
};
Pmodel.Sqlprms[3] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
{
Value = (object)Pmodel.HinbanCD ?? DBNull.Value
};
Pmodel.Sqlprms[4] = new SqlParameter("@Season", SqlDbType.VarChar)
{
Value = (object)Pmodel.Season ?? DBNull.Value
};
Pmodel.Sqlprms[5] = new SqlParameter("@Type", SqlDbType.VarChar)
{
Value = (object)Pmodel.Type ?? DBNull.Value
};
return(bdl.SelectJson("Print_Genka_ProjectData", Pmodel.Sqlprms));
}
public RegisterModel SearchMember(RegisterModel rml)
{
BaseDL bdl = new BaseDL();
SqlParameter[] prms = new SqlParameter[1];
prms[0] = new SqlParameter("@MemberID", SqlDbType.Int)
{
Value = rml.MemberID
};
//prms[1] = new SqlParameter("@StaffName", SqlDbType.VarChar) { Value = sm.StaffName };
DataTable dt = bdl.SelectData("M_Member_Search", prms);
if (dt.Rows.Count > 0)
{
if (!string.IsNullOrWhiteSpace(dt.Rows[0]["Photo"].ToString()))
{
rml.Photo = dt.Rows[0]["Photo"].ToString();
}
else
{
rml.Photo = "Default.png";
}
rml.MemberID = dt.Rows[0]["MemberID"].ToString();
rml.MemberName = dt.Rows[0]["MemberName"].ToString();
rml.MemberPassword = dt.Rows[0]["MemberPassword"].ToString();
rml.ContactNo = dt.Rows[0]["ContactNo"].ToString();
rml.Address = dt.Rows[0]["Address"].ToString();
}
return(rml);
}
public string GetUserTranstionEntry(UserBalanceModel UBModel)
{
BaseDL BDL = new BaseDL();
Function FUN = new Function();
SqlParameter[] prms = new SqlParameter[5];
DateTime dt = DateTime.ParseExact(UBModel.PayDate.Replace("-", "/"), "dd/MM/yyyy", CultureInfo.GetCultureInfo("en-us"));
prms[0] = new SqlParameter("@PayDate", SqlDbType.Date)
{
Value = dt
};
prms[1] = new SqlParameter("@UserID", SqlDbType.VarChar)
{
Value = string.IsNullOrWhiteSpace(UBModel.UserID) ? (object)DBNull.Value : UBModel.UserID
};
prms[2] = new SqlParameter("@TransitionType", SqlDbType.TinyInt)
{
Value = string.IsNullOrWhiteSpace(UBModel.TransitionType) ? (object)DBNull.Value : UBModel.TransitionType
};
prms[3] = new SqlParameter("@Amount", SqlDbType.Int)
{
Value = string.IsNullOrWhiteSpace(UBModel.Amount) ? (object)DBNull.Value : UBModel.Amount
};
prms[4] = new SqlParameter("@OperatorMode", SqlDbType.VarChar)
{
Value = string.IsNullOrWhiteSpace(UBModel.OperatorMode) ? (object)DBNull.Value : UBModel.OperatorMode
};
if (BDL.InsertUpdateDeleteData("User_Transition_Insert", prms))
{
return("true");
}
return("false");
}
public string M_Contrl_Year_ExitCheck(Print_GenkaModel Pmodel) // for 対象年度
{
BaseDL bdl = new BaseDL();
Pmodel.Sqlprms = new SqlParameter[0];
return(bdl.SelectJson("M_Contrl_Year_ExitCheck"));
}
public string DataIsExists(UserBalanceModel UBModel)
{
BaseDL BDL = new BaseDL();
Function FUN = new Function();
SqlParameter[] prms = new SqlParameter[2];
DateTime dt = DateTime.ParseExact(UBModel.PayDate.Replace("-", "/"), "dd/MM/yyyy", CultureInfo.GetCultureInfo("en-us"));
prms[0] = new SqlParameter("@PayDate", SqlDbType.Date)
{
Value = dt
};
prms[1] = new SqlParameter("@UserID", SqlDbType.VarChar)
{
Value = string.IsNullOrWhiteSpace(UBModel.UserID) ? (object)DBNull.Value : UBModel.UserID
};
DataTable DtResult = BDL.SelectData("User_Transition_DataExists", prms);
if (DtResult.Rows.Count > 0)
{
return("true");
}
return("false");
}
public static bool UserAccess(string id)
{
bool flag = false;
BaseDL bdl = new BaseDL();
DataTable dt = new DataTable();
string viewname = id;
SqlParameter[] prms = new SqlParameter[3];
prms[0] = new SqlParameter("@UserID", SqlDbType.VarChar)
{
Value = HttpContext.Current.Session["UserID"].ToString().Split('_')[0]
};
prms[1] = new SqlParameter("@ViewName", SqlDbType.VarChar)
{
Value = viewname
};
prms[2] = new SqlParameter("@Option", SqlDbType.Int)
{
Value = 1
};
dt = bdl.SelectData("User_Authorization_SelectAll", prms);
if (dt.Rows.Count > 0)
{
flag = true;
}
else
{
flag = false;
}
return(flag);
}
public string ExportColumn_Select(ExportColumnModel exportColumnModel)
{
BaseDL bdl = new BaseDL();
exportColumnModel.Sqlprms = new SqlParameter[0];
return(bdl.SelectJson("ExportColumn_Select", exportColumnModel.Sqlprms));
}
public string ItemImportLog_Select(ItemImportLogModel itemImportModel)
{
BaseDL bdl = new BaseDL();
itemImportModel.Sqlprms = new SqlParameter[0];
return(bdl.SelectJson("ItemImportLog_Select", itemImportModel.Sqlprms));
}
public string M_Contrl_YearMonth_ExitCheck(Koushin_GetsujiModel kgmodel)
{
BaseDL bdl = new BaseDL();
kgmodel.Sqlprms = new SqlParameter[0];
return(bdl.SelectJson("M_Contrl_YearMonth_ExitCheck"));
}
public string M_Hinban_Previous_Next(TourokuProjectModel Tmodel)
{
BaseDL bdl = new BaseDL();
Tmodel.Sqlprms = new SqlParameter[6];
Tmodel.Sqlprms[0] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = (object)Tmodel.ProjectCD ?? DBNull.Value
};
Tmodel.Sqlprms[1] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
{
Value = (object)Tmodel.HinbanCD ?? DBNull.Value
};
Tmodel.Sqlprms[2] = new SqlParameter("@status", SqlDbType.VarChar)
{
Value = (object)Tmodel.status ?? DBNull.Value
};
Tmodel.Sqlprms[3] = new SqlParameter("@UserID", SqlDbType.VarChar)
{
Value = (object)Tmodel.LoginID ?? DBNull.Value
};
Tmodel.Sqlprms[4] = new SqlParameter("@Number", SqlDbType.Int)
{
Value = (object)Tmodel.Number ?? DBNull.Value
};
Tmodel.Sqlprms[5] = new SqlParameter("@Previous_Next", SqlDbType.VarChar)
{
Value = (object)Tmodel.Previous_Next ?? DBNull.Value
};
return(bdl.SelectJson("M_Hinban_Previous_Next", Tmodel.Sqlprms));
}
public string M_NouhinBS_Select(TourokuNouhinModel Tnmodel)
{
BaseDL bdl = new BaseDL();
Tnmodel.Sqlprms = new SqlParameter[5];
Tnmodel.Sqlprms[0] = new SqlParameter("@Year", SqlDbType.Int)
{
Value = (object)Tnmodel.Year ?? DBNull.Value
};
Tnmodel.Sqlprms[1] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = Tnmodel.BrandCD
};
Tnmodel.Sqlprms[2] = new SqlParameter("@Season", SqlDbType.TinyInt)
{
Value = (object)Tnmodel.Season ?? DBNull.Value
};
Tnmodel.Sqlprms[3] = new SqlParameter("@PeriodStart", SqlDbType.Int)
{
Value = (object)Tnmodel.PeriodStart ?? DBNull.Value
};
Tnmodel.Sqlprms[4] = new SqlParameter("@PeriodEnd", SqlDbType.Int)
{
Value = (object)Tnmodel.PeriodEnd ?? DBNull.Value
};
return(bdl.SelectJson("M_NouhinBS_Select", Tnmodel.Sqlprms));
}
public string Match_OddsUpdate(MatchModel MModel)
{
BaseDL bdl = new BaseDL();
DateTime dt = DateTime.ParseExact(MModel.MatchDate.Replace("-", "/"), "dd/MM/yyyy", CultureInfo.GetCultureInfo("en-us"));
SqlParameter[] prms = new SqlParameter[3];
prms[0] = new SqlParameter("@UserID", SqlDbType.VarChar)
{
Value = MModel.UserID
};
prms[1] = new SqlParameter("@MatchJson", SqlDbType.VarChar)
{
Value = MModel.MatchJson
};
prms[2] = new SqlParameter("@MatchDate", SqlDbType.Date)
{
Value = dt
};
if (bdl.InsertUpdateDeleteData("M_Match_OddsUpdate", prms))
{
return("1");
}
return("0");
}
public OptionModel OptionModel_Select(OptionModel optionModel)
{
BaseDL bdl = new BaseDL();
optionModel.Sqlprms = new SqlParameter[1];
optionModel.Sqlprms[0] = new SqlParameter("@AutoID", SqlDbType.VarChar)
{
Value = optionModel.AutoID
};
DataTable dt = bdl.SelectDatatable("Option_Select", optionModel.Sqlprms);
foreach (DataRow dr in dt.Rows)
{
optionModel.GroupName = dr["GroupName"].ToString();
optionModel.Option1 = dr["Option1"].ToString();
optionModel.Value1 = dr["Value1"].ToString();
optionModel.Option2 = dr["Option2"].ToString();
optionModel.Value2 = dr["Value2"].ToString();
optionModel.Option3 = dr["Option3"].ToString();
optionModel.Value3 = dr["Value3"].ToString();
optionModel.Option4 = dr["Option4"].ToString();
optionModel.Value4 = dr["Value4"].ToString();
optionModel.Option5 = dr["Option5"].ToString();
optionModel.Value5 = dr["Value5"].ToString();
}
return(optionModel);
}
public CategoryEntryModel CategoryModel_Select(CategoryEntryModel categoryModel)
{
BaseDL bdl = new BaseDL();
categoryModel.Sqlprms = new SqlParameter[2];
categoryModel.Sqlprms[0] = new SqlParameter("@ParentCatCD", SqlDbType.VarChar)
{
Value = categoryModel.ParentCategoryCD
};
categoryModel.Sqlprms[1] = new SqlParameter("@CategoryCD", SqlDbType.VarChar)
{
Value = categoryModel.CategoryCD
};
DataTable dt = bdl.SelectDatatable("Category_Select", categoryModel.Sqlprms);
DataRow dr = dt.Rows[0];
categoryModel.CategoryName = dr["CategoryName"].ToString();
categoryModel.RakutenDirectoryID = dr["RakutenDirectoryID"].ToString();
categoryModel.YahooCategoryID = dr["YahooCategoryID"].ToString();
categoryModel.PonpareCategoryID = dr["PonpareCategoryID"].ToString();
categoryModel.WowmaCategoryID = dr["WowmaCategoryID"].ToString();
categoryModel.RakutenCategorySetNo = dr["RakutenCategorySetNo"].ToString();
categoryModel.R_RacketCategoryID = dr["R_RacketCategoryID"].ToString();
categoryModel.R_SportsPlazaCategoryID = dr["R_SportsPlazaCategoryID"].ToString();
categoryModel.R_LuckpieceCategoryID = dr["R_LuckpieceCategoryID"].ToString();
categoryModel.R_HonpoCategoryID = dr["R_HonpoCategoryID"].ToString();
return(categoryModel);
}
public string GetMessage(string id)
{
BaseDL dl = new BaseDL();
string ID = string.Empty;
string key = string.Empty;
if (id != null)
{
var msgarr = id.Split('_');
ID = msgarr[0];
key = msgarr[1];
}
SqlParameter[] prm = new SqlParameter[2];
prm[0] = new SqlParameter("@ID", SqlDbType.VarChar)
{
Value = ID
};
prm[1] = new SqlParameter("@KEY", SqlDbType.VarChar)
{
Value = key
};
DataTable dt = dl.SelectData("M_Message_Select", prm);
var msg = dt.Rows[0]["Message1"].ToString();
return(msg);
}
public UserModel UserModel_Select(UserModel Umodel)
{
BaseDL bdl = new BaseDL();
Umodel.Sqlprms = new SqlParameter[4];
Umodel.Sqlprms[0] = new SqlParameter("@UserID", SqlDbType.VarChar)
{
Value = Umodel.UserID
};
Umodel.Sqlprms[1] = new SqlParameter("@Password", SqlDbType.VarChar)
{
Value = Umodel.Password
};
Umodel.Sqlprms[2] = new SqlParameter("@UserName", SqlDbType.VarChar)
{
Value = Umodel.UserName
};
Umodel.Sqlprms[3] = new SqlParameter("@Status", SqlDbType.VarChar)
{
Value = Umodel.Status
};
DataTable dt = bdl.SelectDatatable("User_Select", Umodel.Sqlprms);
foreach (DataRow dr in dt.Rows)
{
Umodel.UserID = dr["UserID"].ToString();
Umodel.UserName = dr["UserName"].ToString();
Umodel.Password = dr["Password"].ToString();
Umodel.Status = dr["Status"].ToString();
}
return(Umodel);
}
public DataTable GetBookType()
{
BaseDL bdl = new BaseDL();
SqlParameter[] prms = new SqlParameter[0];
return(bdl.SelectData("M_BookType_SelectAll", prms));
}
public DataSet Order_Input_M_Item_Data(string MakerItemCD)
{
DataSet ds = new DataSet();
BaseDL dl = new BaseDL();
if (!string.IsNullOrWhiteSpace(MakerItemCD))
{
string[] itemcd = MakerItemCD.Split(',');
SqlParameter[] prms = new SqlParameter[9];
for (int i = 0; i < itemcd.Count(); i++)
{
prms[i] = new SqlParameter("@MakerItemCD" + i, SqlDbType.VarChar)
{
Value = itemcd[i].ToString()
};
}
for (int i = itemcd.Count(); i < 8; i++)
{
prms[i] = new SqlParameter("@MakerItemCD" + i, SqlDbType.VarChar)
{
Value = ""
};
}
prms[8] = new SqlParameter("@CompanyCD", SqlDbType.VarChar)
{
Value = "1001"
};
ds = dl.SelectDataSet("OrderInput_M_Item_Select", prms);
}
return(ds);
}
public string SKU_Stock_Select(ItemModel item)
{
BaseDL bdl = new BaseDL();
item.Sqlprms = new SqlParameter[6];
item.Sqlprms[0] = new SqlParameter("@JanCD", SqlDbType.VarChar)
{
Value = item.JanCD
};
item.Sqlprms[1] = new SqlParameter("@ItemCD", SqlDbType.VarChar)
{
Value = item.ItemCD
};
item.Sqlprms[2] = new SqlParameter("@ItemName", SqlDbType.VarChar)
{
Value = item.ItemName
};
item.Sqlprms[3] = new SqlParameter("@YearCD", SqlDbType.VarChar)
{
Value = item.YearCD
};
item.Sqlprms[4] = new SqlParameter("@SeasonCD", SqlDbType.VarChar)
{
Value = item.SeasonCD
};
item.Sqlprms[5] = new SqlParameter("@CompetitionName", SqlDbType.VarChar)
{
Value = item.CompetitionName
};
return(bdl.SelectJson("SKU_Stock_Select", item.Sqlprms));
}
public string M_HinBan_Select_List(TourokuProjectModel Tmodel)
{
BaseDL bdl = new BaseDL();
Tmodel.Sqlprms = new SqlParameter[0];
return(bdl.SelectJson("M_HinBan_Select_List", Tmodel.Sqlprms));
}
public async Task <ReturnMessageInfo> setHotelLoginTime(LoginInfo loginInfo)
{
ReturnMessageInfo msgInfo = new ReturnMessageInfo();
BaseDL bdl = new BaseDL();
NpgsqlParameter[] para = new NpgsqlParameter[3];
para[0] = new NpgsqlParameter("@hotelcode", NpgsqlDbType.Varchar)
{
Value = loginInfo.HotelCode
};
para[1] = new NpgsqlParameter("@usercode", NpgsqlDbType.Varchar)
{
Value = loginInfo.UserCode
};
if (loginInfo.SessionFlag == false)
{
para[2] = new NpgsqlParameter("@logindate", NpgsqlDbType.Timestamp)
{
Value = DateTime.Now
}
}
;
else
{
para[2] = new NpgsqlParameter("@logindate", NpgsqlDbType.Timestamp)
{
Value = DateTime.Now.AddMinutes(-2)
}
};
string sql = "update mst_hoteluser set logindate=@logindate where hotel_code=@hotelcode and usercode=@usercode";
msgInfo = await bdl.InsertUpdateDeleteData(sql, para);
return(msgInfo);
}
public string D_StockData_IUD(Touroku_NyuukaModel tnmodel)
{
BaseDL bdl = new BaseDL();
tnmodel.Sqlprms = new SqlParameter[6];
tnmodel.Sqlprms[0] = new SqlParameter("@SEQ", SqlDbType.VarChar)
{
Value = (object)tnmodel.SEQ ?? DBNull.Value
};
tnmodel.Sqlprms[1] = new SqlParameter("@MaterialsCD", SqlDbType.VarChar)
{
Value = (object)tnmodel.MaterialsCD ?? DBNull.Value
};
tnmodel.Sqlprms[2] = new SqlParameter("@StockDate", SqlDbType.VarChar)
{
Value = (object)tnmodel.StockDate ?? DBNull.Value
};
tnmodel.Sqlprms[3] = new SqlParameter("@StockAmount", SqlDbType.VarChar)
{
Value = (object)tnmodel.StockAmount ?? DBNull.Value
};
tnmodel.Sqlprms[4] = new SqlParameter("@Remarks", SqlDbType.VarChar)
{
Value = (object)tnmodel.Remarks ?? DBNull.Value
};
tnmodel.Sqlprms[5] = new SqlParameter("@Mode", SqlDbType.VarChar)
{
Value = (object)tnmodel.Mode ?? DBNull.Value
};
return(bdl.SelectJson("D_StockData_IUD", tnmodel.Sqlprms));
}
public string Mall_Select(MallModel mallModel)
{
BaseDL bdl = new BaseDL();
mallModel.Sqlprms = new SqlParameter[0];
return(bdl.SelectJson("Mall_Select", mallModel.Sqlprms));
}
public string Category_CUD(CategoryEntryModel categoryModel)
{
BaseDL bdl = new BaseDL();
categoryModel.Sqlprms = new SqlParameter[13];
categoryModel.Sqlprms[0] = new SqlParameter("@CategoryCD", SqlDbType.VarChar)
{
Value = categoryModel.CategoryCD
};
categoryModel.Sqlprms[1] = new SqlParameter("@CategoryName", SqlDbType.VarChar)
{
Value = categoryModel.CategoryName
};
categoryModel.Sqlprms[2] = new SqlParameter("@ParentCategoryCD", SqlDbType.VarChar)
{
Value = categoryModel.ParentCategoryCD
};
categoryModel.Sqlprms[3] = new SqlParameter("@RakutenDirectoryID", SqlDbType.VarChar)
{
Value = categoryModel.RakutenDirectoryID
};
categoryModel.Sqlprms[4] = new SqlParameter("@YahooCategoryID", SqlDbType.VarChar)
{
Value = categoryModel.YahooCategoryID
};
categoryModel.Sqlprms[5] = new SqlParameter("@PonpareCategoryID", SqlDbType.VarChar)
{
Value = categoryModel.PonpareCategoryID
};
categoryModel.Sqlprms[6] = new SqlParameter("@WowmaCategoryID", SqlDbType.VarChar)
{
Value = categoryModel.WowmaCategoryID
};
categoryModel.Sqlprms[7] = new SqlParameter("@RakutenCategorySetNo", SqlDbType.VarChar)
{
Value = categoryModel.RakutenCategorySetNo
};
categoryModel.Sqlprms[8] = new SqlParameter("@R_RacketCategoryID", SqlDbType.VarChar)
{
Value = categoryModel.R_RacketCategoryID
};
categoryModel.Sqlprms[9] = new SqlParameter("@R_SportsPlazaCategoryID", SqlDbType.VarChar)
{
Value = categoryModel.R_SportsPlazaCategoryID
};
categoryModel.Sqlprms[10] = new SqlParameter("@R_LuckpieceCategoryID", SqlDbType.VarChar)
{
Value = categoryModel.R_LuckpieceCategoryID
};
categoryModel.Sqlprms[11] = new SqlParameter("@R_HonpoCategoryID", SqlDbType.VarChar)
{
Value = categoryModel.R_HonpoCategoryID
};
categoryModel.Sqlprms[12] = new SqlParameter("@Mode", SqlDbType.VarChar)
{
Value = categoryModel.Mode
};
return(bdl.InsertUpdateDeleteData("Category_CUD", categoryModel.Sqlprms));
}
public String Option_Save(OptionModel optionModel)
{
BaseDL bdl = new BaseDL();
optionModel.Sqlprms = new SqlParameter[13];
optionModel.Sqlprms[0] = new SqlParameter("@AutoID", SqlDbType.VarChar)
{
Value = optionModel.AutoID
};
optionModel.Sqlprms[1] = new SqlParameter("@GroupName", SqlDbType.VarChar)
{
Value = optionModel.GroupName
};
optionModel.Sqlprms[2] = new SqlParameter("@Option1", SqlDbType.VarChar)
{
Value = optionModel.Option1
};
optionModel.Sqlprms[3] = new SqlParameter("@Value1", SqlDbType.VarChar)
{
Value = optionModel.Value1
};
optionModel.Sqlprms[4] = new SqlParameter("@Option2", SqlDbType.VarChar)
{
Value = optionModel.Option2
};
optionModel.Sqlprms[5] = new SqlParameter("@Value2", SqlDbType.VarChar)
{
Value = optionModel.Value2
};
optionModel.Sqlprms[6] = new SqlParameter("@Option3", SqlDbType.VarChar)
{
Value = optionModel.Option3
};
optionModel.Sqlprms[7] = new SqlParameter("@Value3", SqlDbType.VarChar)
{
Value = optionModel.Value3
};
optionModel.Sqlprms[8] = new SqlParameter("@Option4", SqlDbType.VarChar)
{
Value = optionModel.Option4
};
optionModel.Sqlprms[9] = new SqlParameter("@Value4", SqlDbType.VarChar)
{
Value = optionModel.Value4
};
optionModel.Sqlprms[10] = new SqlParameter("@Option5", SqlDbType.VarChar)
{
Value = optionModel.Option5
};
optionModel.Sqlprms[11] = new SqlParameter("@Value5", SqlDbType.VarChar)
{
Value = optionModel.Value5
};
optionModel.Sqlprms[12] = new SqlParameter("@Mode", SqlDbType.VarChar)
{
Value = optionModel.Mode
};
return(bdl.InsertUpdateDeleteData("Option_CUD", optionModel.Sqlprms));
}
public string M_Contrl_YearMonth_Genka_Update(Koushin_GenkaModel kgmodel)
{
BaseDL bdl = new BaseDL();
kgmodel.Sqlprms = new SqlParameter[0];
//kgmodel.Sqlprms[0] = new SqlParameter("@Date", SqlDbType.VarChar) { Value = (object)kgmodel.processing_date ?? DBNull.Value };
return(bdl.SelectJson("M_Contrl_YearMonth_Genka_Update", kgmodel.Sqlprms));
}
public string M_Control_SelectAll()
{
BaseDL bdl = new BaseDL();
//Kmodel.Sqlprms = new SqlParameter[0];
return(bdl.SelectJson("M_Control_SelectAll"));
}
public string View_Select(ViewModel viewModel)
{
BaseDL bdl = new BaseDL();
viewModel.Sqlprms = new SqlParameter[1];
viewModel.Sqlprms[0] = new SqlParameter("@UserID", viewModel.UserID);
return(bdl.SelectJson("View_Select", viewModel.Sqlprms));
}
public string CategorySerial_Update(CategoryListModel model)
{
BaseDL bdl = new BaseDL();
model.Sqlprms = new SqlParameter[1];
model.Sqlprms[0] = new SqlParameter("@CategoryJson", JsonConvert.SerializeObject(model.CategoryList));
return(bdl.InsertUpdateDeleteData("CategorySerial_Update", model.Sqlprms));
}
