/// <summary> /// Insert new Item for Solutions. /// </summary> /// <param name="model"></param> /// <returns></returns> public static int Insert(SolutionsModel model) { try { using (DataContentDataContext dc = new DataContentDataContext()) { Solution newItem = new Solution(); newItem.ID = model.ID; newItem.Name = model.Name; newItem.Header = model.Header; newItem.Contents = model.Contents; newItem.Link_Image = model.Link_Image; newItem.Link_Image_Small = model.Link_Image_Small; newItem.Type_Solution = model.Type_Solution; newItem.Creater = model.Creater; newItem.CreateDate = model.CreateDate; newItem.Modifier = model.Modifier; newItem.ModifyDate = model.ModifyDate; dc.Solutions.InsertOnSubmit(newItem); dc.SubmitChanges(); } return 1; } catch (Exception) { return 0; } }
protected void lbtnDelete_Command(object sender, CommandEventArgs e) { try { SolutionsModel model = new SolutionsModel(); model.ID = e.CommandArgument.ToString(); SolutionsViewModel.Delete(model); } catch (Exception) { lblError.Text = "Lỗi hệ thống!"; } }
public void UpdateSolution() { SolutionsModel model = new SolutionsModel(); model.ID = txtId.Text; model.Name = txtName.Text; //model.Price = txtPrice.Text; model.Type_Solution = (cmdSerType.SelectedValue != "") ? cmdSerType.SelectedValue.ToCharArray()[0] : '0'; model.Header = FTBHeader.Text; model.Contents = FTBContents.Text; model.Link_Image_Small = (imgSmall.FileName != null) ? UploadImage(imgSmall, "small") : showImgSmall.ImageUrl; model.Link_Image = (imgBig.FileName != "") ? UploadImage(imgBig, "big") : showImageBig.ImageUrl; model.Modifier = Session["user"].ToString(); model.ModifyDate = DateTime.Now.ToString("yyyyMMdd"); SolutionsViewModel.Update(model); }
public void SaveSolution() { SolutionsModel model = new SolutionsModel(); model.ID = txtId.Text; model.Name = txtName.Text; //model.Price = txtPrice.Text; model.Type_Solution = (cmdSerType.SelectedValue != "") ? cmdSerType.SelectedValue.ToCharArray()[0] : '0'; model.Header = FTBHeader.Text; model.Contents = FTBContents.Text; model.Link_Image_Small = UploadImage(imgSmall, "small"); model.Link_Image = UploadImage(imgBig, "big"); model.Creater = Session["user"].ToString(); model.CreateDate = DateTime.Now.ToString("yyyyMMdd"); SolutionsViewModel.Insert(model); }
private void BindData() { try { if ( Request.QueryString["id"] != null) { SolutionsModel model = new SolutionsModel(); model.ID = Request.QueryString["id"]; objSolution = SolutionsViewModel.SelectOne(model); } } catch (Exception) { } }
/// <summary> /// Deleted Solution Item /// </summary> /// <param name="model"></param> /// <returns></returns> public static int Delete(SolutionsModel model) { try { using (DataContentDataContext dc = new DataContentDataContext()) { Solution delItem = dc.Solutions.Where(a => a.ID == model.ID).SingleOrDefault(); dc.Solutions.DeleteOnSubmit(delItem); dc.SubmitChanges(); } return 1; } catch (Exception) { return 0; } }
public void getDateEdit() { SolutionsModel model = new SolutionsModel(); model.ID = Request.QueryString["id"]; if (model.ID != "") { model = SolutionsViewModel.SelectOne(model); txtId.Text = model.ID; txtName.Text = model.Name; //txtPrice.Text = model.Price; cmdSerType.SelectedValue = model.Type_Solution.ToString(); showImgSmall.ImageUrl = model.Link_Image_Small; showImageBig.ImageUrl = model.Link_Image; FTBHeader.Text = model.Header; FTBContents.Text = model.Contents; } }
/// <summary> /// Update new information for Solution Item /// </summary> /// <param name="model"></param> /// <returns></returns> public static int Update(SolutionsModel model) { try { using (DataContentDataContext dc = new DataContentDataContext()) { Solution changeItem = dc.Solutions.Where(a => a.ID == model.ID).SingleOrDefault(); changeItem.Header = model.Header; changeItem.Name = model.Name; changeItem.Contents = model.Contents; changeItem.Type_Solution = model.Type_Solution; changeItem.Link_Image = model.Link_Image; changeItem.Link_Image_Small = model.Link_Image_Small; changeItem.ModifyDate = model.ModifyDate; changeItem.Modifier = model.Modifier; dc.SubmitChanges(); } return 1; } catch (Exception) { return 0; } }
public static List<SolutionsModel> SelectTopService(string catID, int top) { List<SolutionsModel> lst = new List<SolutionsModel>(); try { using (DataContentDataContext dc = new DataContentDataContext()) { var items = (from temp in dc.Solutions where temp.Type_Solution == catID.ToCharArray()[0] select temp).Take(top); foreach (var i in items) { SolutionsModel n = new SolutionsModel(i.ID, i.Name, i.Header, i.Contents, i.Link_Image_Small, i.Link_Image, i.Type_Solution, i.Creater, i.CreateDate, i.Modifier, i.ModifyDate); lst.Add(n); } } return lst; } catch (Exception) { return lst; } }
/// <summary> /// get one Solution Item. /// </summary> /// <param name="model"></param> /// <returns></returns> public static SolutionsModel SelectOne(SolutionsModel model) { try { using (DataContentDataContext dc = new DataContentDataContext()) { Solution i = dc.Solutions.Where(a => a.ID == model.ID).SingleOrDefault(); return new SolutionsModel(i.ID, i.Name, i.Header, i.Contents, i.Link_Image_Small, i.Link_Image, i.Type_Solution, i.Creater, i.CreateDate, i.Modifier, i.ModifyDate); } } catch (Exception) { return new SolutionsModel(); } }
/// <summary> /// Get all Solution Item. /// </summary> /// <returns></returns> public static List<SolutionsModel> SelectAll() { List<SolutionsModel> lst = new List<SolutionsModel>(); try { using (DataContentDataContext dc = new DataContentDataContext()) { var items = from temp in dc.Solutions select temp; foreach (var i in items) { SolutionsModel n = new SolutionsModel(i.ID, i.Name, i.Header, i.Contents, i.Link_Image_Small, i.Link_Image, i.Type_Solution, i.Creater, i.CreateDate, i.Modifier, i.ModifyDate); lst.Add(n); } } return lst; } catch (Exception) { return lst; } }