public static List<Trimester> GetList(Paging paging, string order, string sort, string queryWord)
{
List<Trimester> list = new List<Trimester>();
Trimester model = null;
DataSet ds = SqlHelper.GetListByPage("PSS_Trimester", paging, order, sort);
foreach (DataRow dr in ds.Tables["PSS_Trimester"].Rows)
{
model = new Trimester();
if (!string.IsNullOrEmpty(dr["tri_Id"].ToString()))
{
model.tri_Id = int.Parse(dr["tri_Id"].ToString());
}
model.tri_Name = dr["tri_Name"].ToString();
model.tri_IsOpen = (bool)dr["tri_IsOpen"];
if (!string.IsNullOrEmpty(dr["tri_StartDate"].ToString()))
{
model.tri_StartDate = DateTime.Parse(dr["tri_StartDate"].ToString());
model.StartDate_Time = model.tri_StartDate.ToString("dd/MM/yyyy");
}
if (!string.IsNullOrEmpty(dr["tri_EndDate"].ToString()))
{
model.tri_EndDate = DateTime.Parse(dr["tri_EndDate"].ToString());
model.EndDate_Time = model.tri_EndDate.ToString("dd/MM/yyyy");
}
list.Add(model);
};
return list;
}
public static List<Trimester> GetList()
{
List<Trimester> list = new List<Trimester>();
Trimester model = null;
string sql = "select * from PSS_Trimester";
DataSet ds = SqlHelper.GetDataSetBySql(sql, "PSS_Trimester");
foreach (DataRow dr in ds.Tables["PSS_Trimester"].Rows)
{
model = new Trimester();
if (!string.IsNullOrEmpty(dr["tri_Id"].ToString()))
{
model.tri_Id = int.Parse(dr["tri_Id"].ToString());
}
model.tri_Name = dr["tri_Name"].ToString();
model.tri_IsOpen = (bool)dr["tri_IsOpen"];
if (!string.IsNullOrEmpty(dr["tri_StartDate"].ToString()))
{
model.tri_StartDate = DateTime.Parse(dr["tri_StartDate"].ToString());
model.StartDate_Time = model.tri_StartDate.ToString("dd/MM/yyyy");
}
if (!string.IsNullOrEmpty(dr["tri_EndDate"].ToString()))
{
model.tri_EndDate = DateTime.Parse(dr["tri_EndDate"].ToString());
model.EndDate_Time = model.tri_EndDate.ToString("dd/MM/yyyy");
}
list.Add(model);
};
return list;
}
public static void Delete(Trimester model)
{
string sql = "select * from PSS_Trimester where tri_Id='" + model.tri_Id + "'";
DataSet ds = SqlHelper.GetDataSetBySql(sql, "PSS_Trimester");
DataRow dr = ds.Tables["PSS_Trimester"].Rows[0];
dr.Delete();
SqlHelper.UpdateDataSet(ds, sql, "PSS_Trimester");
if (ds != null)
ds.Dispose();
}
public static Trimester GetModel(int id)
{
string sql = "select * from PSS_Trimester where tri_Id='" + id + "'";
DataSet ds = SqlHelper.GetDataSetBySql(sql, "PSS_Trimester");
Trimester model = null;
if (ds.Tables[0].Rows.Count > 0)
{
model = new Trimester();
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["tri_Id"].ToString()))
{
model.tri_Id = int.Parse(ds.Tables[0].Rows[0]["tri_Id"].ToString());
}
model.tri_Name = ds.Tables[0].Rows[0]["tri_Name"].ToString();
model.tri_IsOpen =(bool)ds.Tables[0].Rows[0]["tri_IsOpen"];
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["tri_StartDate"].ToString()))
{
model.tri_StartDate = DateTime.Parse(ds.Tables[0].Rows[0]["tri_StartDate"].ToString());
model.StartDate_Time = model.tri_StartDate.ToString("dd/MM/yyyy");
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["tri_EndDate"].ToString()))
{
model.tri_EndDate = DateTime.Parse(ds.Tables[0].Rows[0]["tri_EndDate"].ToString());
model.EndDate_Time = model.tri_EndDate.ToString("dd/MM/yyyy");
}
}
if (ds != null)
ds.Dispose();
return model;
}
public static void Update(Trimester model)
{
string sql = "select * from PSS_Trimester where tri_Id='" + model.tri_Id + "'";
DataSet ds = SqlHelper.GetDataSetBySql(sql, "PSS_Trimester");
DataRow dr = ds.Tables["PSS_Trimester"].Rows[0];
dr["tri_Name"] = model.tri_Name;
dr["tri_IsOpen"] = model.tri_IsOpen;
dr["tri_StartDate"] = model.tri_StartDate;
dr["tri_EndDate"] = model.tri_EndDate;
SqlHelper.UpdateDataSet(ds, sql, "PSS_Trimester");
if (ds != null)
ds.Dispose();
}
public static void Save(Trimester model)
{
string sql = "select * from PSS_Trimester where 1<>1";
DataSet ds = SqlHelper.GetDataSetBySql(sql, "PSS_Trimester");
DataRow dr = ds.Tables["PSS_Trimester"].NewRow();
int maxId = SqlHelper.GetMaxId("select max(tri_Id) from PSS_Trimester");
dr["tri_Id"] = ++maxId;
dr["tri_Name"] = model.tri_Name;
dr["tri_IsOpen"] = model.tri_IsOpen;
dr["tri_StartDate"] = model.tri_StartDate;
dr["tri_EndDate"] = model.tri_EndDate;
ds.Tables["PSS_Trimester"].Rows.Add(dr);
SqlHelper.UpdateDataSet(ds, sql, "PSS_Trimester");
if (ds != null)
ds.Dispose();
}
public ContentResult TrimesterSave(Trimester model, int? id)
{
JsonDataGridResult jsonResult = new JsonDataGridResult();
try
{
Trimester trimester = null;
if (id.HasValue)
{
trimester = TrimesterService.GetModel(id.Value);
}
else
{
trimester = new Trimester();
}
trimester.tri_Name = model.tri_Name;
trimester.tri_IsOpen = model.tri_IsOpen;
trimester.tri_StartDate = model.tri_StartDate;
trimester.tri_EndDate = model.tri_EndDate;
if (id.HasValue)
{
TrimesterService.Update(trimester);
}
else
{
TrimesterService.Save(trimester);
}
jsonResult.result = true;
jsonResult.message = "";
}
catch (Exception ex)
{
jsonResult.result = false;
jsonResult.message = ex.Message;
}
string result = JsonConvert.SerializeObject(jsonResult);
return Content(result);
}
