public ArrayList getAllKeyword1CuPhap(String Cum_tu_1)
{
ArrayList listCuPhap = new ArrayList();
//String sql = ConfigurationManager.AppSettings["sql.getAllKeyword1CuPhap"];
//SqlCommand objCommand = new SqlCommand(sql);
//objCommand.Parameters.AddWithValue("@ten", ten);
//DataTable result = DataUtil.executeQuery(objCommand);
SqlParameter[] parameter = new SqlParameter[1];
int i = 0;
parameter[i] = new SqlParameter("Cum_tu_1", SqlDbType.NVarChar);
parameter[i++].Value = Cum_tu_1;
DataTable result = DataUtil.executeStore("sp_getAllKeyword1CuPhap", parameter);
if (result == null)
{
return(listCuPhap);
}
else
{
foreach (DataRow row in result.Rows)
{
CuPhapMODEL cuPhapModel = new CuPhapMODEL();
cuPhapModel.Cum_Tu_2 = row["Cum_tu_2"].ToString();
listCuPhap.Add(cuPhapModel);
}
return(listCuPhap);
}
}
public CuPhapMODEL getCuPhapByID(int id)
{
//String sql = ConfigurationManager.AppSettings["sql.getCuPhapByID"];
//SqlCommand objCommand = new SqlCommand(sql);
//CuPhapMODEL cuPhapModel = new CuPhapMODEL();
//objCommand.Parameters.AddWithValue("@id",id);
//DataTable result = DataUtil.executeQuery(objCommand);
try
{
CuPhapMODEL cuPhapModel = new CuPhapMODEL();
SqlParameter[] parameter = new SqlParameter[1];
int i = 0;
parameter[i] = new SqlParameter("ID", SqlDbType.NVarChar);
parameter[i++].Value = id;
DataTable result = DataUtil.executeStore("sp_getCuPhapByID", parameter);
foreach (DataRow row in result.Rows)
{
cuPhapModel.Id = row["ID"].ToString();
cuPhapModel.Ten = row["Ten"].ToString();
cuPhapModel.Cum_Tu_1 = row["Cum_tu_1"].ToString();
cuPhapModel.Cum_Tu_2 = row["Cum_tu_2"].ToString();
cuPhapModel.Cum_Tu_3 = row["Cum_tu_3"].ToString();
cuPhapModel.Cum_Tu_4 = row["Cum_tu_4"].ToString();
cuPhapModel.Cum_Tu_5 = row["Cum_tu_5"].ToString();
cuPhapModel.Cum_Tu_6 = row["Cum_tu_6"].ToString();
cuPhapModel.Cum_Tu_7 = row["Cum_tu_7"].ToString();
cuPhapModel.Cum_Tu_8 = row["Cum_tu_8"].ToString();
cuPhapModel.Cum_Tu_9 = row["Cum_tu_9"].ToString();
cuPhapModel.Cum_Tu_10 = row["Cum_tu_10"].ToString();
cuPhapModel.Ghi_Chu = row["Ghi_chu"].ToString();
////cuPhapModel.Ngay_Cap_Nhat_Cuoi = row["Ngay_cap_nhat_cuoi"].ToString();
//cuPhapModel.User11 = row["User1"].ToString();
//cuPhapModel.User21 = row["User2"].ToString();
//cuPhapModel.User31 = row["User3"].ToString();
//cuPhapModel.User41 = row["User4"].ToString();
//cuPhapModel.User51 = row["User5"].ToString();
}
return(cuPhapModel);
}
catch (Exception)
{
throw;
}
}
//public ArrayList getAllCuPhap()
//{
// ArrayList listCuPhap = new ArrayList();
// String sql = ConfigurationManager.AppSettings["sql.getAllCuPhap"];
// SqlCommand objCommand = new SqlCommand(sql);
// DataTable result = DataUtil.executeQuery(objCommand);
// foreach (DataRow row in result.Rows)
// {
// CuPhapMODEL cuPhapModel = new CuPhapMODEL();
// cuPhapModel.Id = row["ID"].ToString();
// cuPhapModel.Ten = row["Ten"].ToString();
// cuPhapModel.Cum_Tu_1 = row["Cum_tu_1"].ToString();
// cuPhapModel.Cum_Tu_2 = row["Cum_tu_2"].ToString();
// cuPhapModel.Cum_Tu_3 = row["Cum_tu_3"].ToString();
// cuPhapModel.Cum_Tu_4 = row["Cum_tu_4"].ToString();
// cuPhapModel.Cum_Tu_5 = row["Cum_tu_5"].ToString();
// cuPhapModel.Cum_Tu_6 = row["Cum_tu_6"].ToString();
// cuPhapModel.Cum_Tu_7 = row["Cum_tu_7"].ToString();
// cuPhapModel.Cum_Tu_8 = row["Cum_tu_8"].ToString();
// cuPhapModel.Cum_Tu_9 = row["Cum_tu_9"].ToString();
// cuPhapModel.Cum_Tu_10 = row["Cum_tu_10"].ToString();
// cuPhapModel.Ghi_Chu = row["Ghi_chu"].ToString();
// cuPhapModel.Ngay_Cap_Nhat_Cuoi = row["Ngay_cap_nhat_cuoi"].ToString();
// cuPhapModel.User11 = row["User1"].ToString();
// cuPhapModel.User21 = row["User2"].ToString();
// cuPhapModel.User31 = row["User3"].ToString();
// cuPhapModel.User41 = row["User4"].ToString();
// cuPhapModel.User51 = row["User5"].ToString();
// listCuPhap.Add(cuPhapModel);
// }
// return listCuPhap;
//}
//public static DataTable getAllCuPhapINTODataTable()
//{
// String sql = ConfigurationManager.AppSettings["sql.getAllCuPhap"];
// SqlCommand objCommand = new SqlCommand(sql);
// return DataUtil.executeQuery(objCommand);
//}
public ArrayList getAllKeywordCuPhap()
{
ArrayList listCuPhap = new ArrayList();
//String sql = ConfigurationManager.AppSettings["sql.getAllTenCuPhap"];
//SqlCommand objCommand = new SqlCommand(sql);
//DataTable result = DataUtil.executeQuery(objCommand);
DataTable result = DataUtil.executeStore("sp_getAllTenCuPhap", null);
foreach (DataRow row in result.Rows)
{
CuPhapMODEL cuPhapModel = new CuPhapMODEL();
cuPhapModel.Cum_Tu_1 = row["Cum_Tu_1"].ToString();
listCuPhap.Add(cuPhapModel);
}
return(listCuPhap);
}
public static CuPhapMODEL getCuPhapByCumCuPhap(string cumCuPhap)
{
try
{
SqlParameter[] parameter = new SqlParameter[1];
parameter[0] = new SqlParameter("@cumCuPhap", SqlDbType.VarChar);
parameter[0].Value = cumCuPhap;
CuPhapMODEL cuPhapModel = new CuPhapMODEL();
DataTable result = DataUtil.executeStore("sp_ISO_SMS_getCumCuPhap", parameter);
foreach (DataRow row in result.Rows)
{
cuPhapModel.Id = row["ID"].ToString();
cuPhapModel.Ten = row["Ten"].ToString();
cuPhapModel.Cum_Tu_1 = row["Cum_tu_1"].ToString();
cuPhapModel.Cum_Tu_2 = row["Cum_tu_2"].ToString();
cuPhapModel.Cum_Tu_3 = row["Cum_tu_3"].ToString();
cuPhapModel.Cum_Tu_4 = row["Cum_tu_4"].ToString();
cuPhapModel.Cum_Tu_5 = row["Cum_tu_5"].ToString();
cuPhapModel.Cum_Tu_6 = row["Cum_tu_6"].ToString();
cuPhapModel.Cum_Tu_7 = row["Cum_tu_7"].ToString();
cuPhapModel.Cum_Tu_8 = row["Cum_tu_8"].ToString();
cuPhapModel.Cum_Tu_9 = row["Cum_tu_9"].ToString();
cuPhapModel.Cum_Tu_10 = row["Cum_tu_10"].ToString();
cuPhapModel.Ghi_Chu = row["Ghi_chu"].ToString();
cuPhapModel.Ngay_Cap_Nhat_Cuoi = row["Ngay_cap_nhat_cuoi"].ToString();
cuPhapModel.User11 = row["User1"].ToString();
cuPhapModel.User21 = row["User2"].ToString();
cuPhapModel.User31 = row["User3"].ToString();
cuPhapModel.User41 = row["User4"].ToString();
cuPhapModel.User51 = row["User5"].ToString();
}
return(cuPhapModel);
}
catch (Exception)
{
throw;
}
}
public Boolean updateCuPhap(CuPhapMODEL cuPhapModel)
{
try
{
SqlParameter[] parameter = new SqlParameter[19];
int i = 0;
parameter[i] = new SqlParameter("ID", SqlDbType.NVarChar);
parameter[i++].Value = cuPhapModel.Id;
parameter[i] = new SqlParameter("Ten", SqlDbType.NVarChar);
parameter[i++].Value = cuPhapModel.Ten;
parameter[i] = new SqlParameter("Cum_tu_1", SqlDbType.NVarChar);
parameter[i++].Value = cuPhapModel.Cum_Tu_1;
parameter[i] = new SqlParameter("Cum_tu_2", SqlDbType.NVarChar);
parameter[i++].Value = cuPhapModel.Cum_Tu_2;
parameter[i] = new SqlParameter("Cum_tu_3", SqlDbType.NVarChar);
parameter[i++].Value = cuPhapModel.Cum_Tu_3;
parameter[i] = new SqlParameter("Cum_tu_4", SqlDbType.NVarChar);
parameter[i++].Value = cuPhapModel.Cum_Tu_4;
parameter[i] = new SqlParameter("Cum_tu_5", SqlDbType.NVarChar);
parameter[i++].Value = cuPhapModel.Cum_Tu_5;
parameter[i] = new SqlParameter("Cum_tu_6", SqlDbType.NVarChar);
parameter[i++].Value = cuPhapModel.Cum_Tu_6;
parameter[i] = new SqlParameter("Cum_tu_7", SqlDbType.NVarChar);
parameter[i++].Value = cuPhapModel.Cum_Tu_7;
parameter[i] = new SqlParameter("Cum_tu_8", SqlDbType.NVarChar);
parameter[i++].Value = cuPhapModel.Cum_Tu_8;
parameter[i] = new SqlParameter("Cum_tu_9", SqlDbType.NVarChar);
parameter[i++].Value = cuPhapModel.Cum_Tu_9;
parameter[i] = new SqlParameter("Cum_tu_10", SqlDbType.NVarChar);
parameter[i++].Value = cuPhapModel.Cum_Tu_10;
parameter[i] = new SqlParameter("Ghi_chu", SqlDbType.NVarChar);
parameter[i++].Value = cuPhapModel.Ghi_Chu;
parameter[i] = new SqlParameter("Ngay_cap_nhat_cuoi", SqlDbType.NVarChar);
parameter[i++].Value = "";
parameter[i] = new SqlParameter("User1", SqlDbType.NVarChar);
parameter[i++].Value = "";
parameter[i] = new SqlParameter("User2", SqlDbType.NVarChar);
parameter[i++].Value = "";
parameter[i] = new SqlParameter("User3", SqlDbType.NVarChar);
parameter[i++].Value = "";
parameter[i] = new SqlParameter("User4", SqlDbType.NVarChar);
parameter[i++].Value = "";
parameter[i] = new SqlParameter("User5", SqlDbType.NVarChar);
parameter[i++].Value = "";
Boolean kq = DataUtil.executeNonStore("sp_SMS_UpdateCuPhapByID", parameter);
return(kq);
}
catch (Exception)
{
throw;
}
}
