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