public static bool Create(Exhibition e) { DBUtilities.Connection(); try { string sql = "Insert into [Exhibitions] (ExhibitionName,ManagerId,StartDate,EndDate,ExhibitionDescription)"; sql += " values (@1,@2,@3,@4,@5)"; SqlCommand cmd = new SqlCommand(sql, DBUtilities.objConnection); cmd.Parameters.AddWithValue("@1",e.ExhibitionName); cmd.Parameters.AddWithValue("@2", e.ManagerId); cmd.Parameters.AddWithValue("@3", e.StartDate); cmd.Parameters.AddWithValue("@4", e.EndDate); cmd.Parameters.AddWithValue("@5", e.ExhibitionDescription); cmd.ExecuteNonQuery(); cmd.Dispose(); return true; } catch (Exception) { return false; } finally { DBUtilities.Close_Connection(); } }
protected void btnAccept_Click(object sender, EventArgs e) { if (Validate_Control()) { Exhibition exhibition = new Exhibition(); exhibition.Id = Id; exhibition.ExhibitionName = txtExhibitionName.Text; exhibition.ManagerId = int.Parse(ddlManagerName.SelectedValue); exhibition.StartDate = DateTime.Parse(txtStartDate.Text); exhibition.EndDate = DateTime.Parse(txtEndDate.Text); exhibition.ExhibitionDescription = txtExhibitionDescription.Text; if (ExhibitionDAO.Update(exhibition)) { Flash.dictFlash.Add("success", String.Format("Update Exhibition [<b>{0}</b>] successfully", exhibition.ExhibitionName)); Response.Redirect("Index.aspx"); } else { Flash.dictFlash.Add("danger", "Error update Exhibition. You should check again."); Response.Redirect("Edit.aspx?ID="+Id); } } }
public static bool Destroy(Exhibition u) { DBUtilities.Connection(); try { string sql = "Delete from [Exhibitions] where Id = @1"; SqlCommand cmd = new SqlCommand(sql, DBUtilities.objConnection); cmd.Parameters.AddWithValue("@1", u.Id); cmd.ExecuteNonQuery(); cmd.Dispose(); return true; } catch (Exception) { return false; } finally { DBUtilities.Close_Connection(); } }
protected void btnAdd_Click(object sender, EventArgs e) { if (Validate_Add()) { User u = (User)Session["current_user"]; Exhibition ex = new Exhibition(); ex.ManagerId = u.Id; ex.StartDate = DateTime.Parse(txtStartDate.Text); ex.EndDate = DateTime.Parse(txtEndDate.Text); ex.ExhibitionName = txtExName.Text; ex.ExhibitionDescription = txtDesc.Text; if (ExhibitionDAO.Create(ex)) { Flash.dictFlash.Add("success", String.Format("Created exhibition [<b>{0}</b>] successfully", ex.ExhibitionName)); Response.Redirect("List.aspx"); } else { Flash.dictFlash.Add("danger", " Cannot create exhibition !!!"); Response.Redirect("List.aspx"); } } }
protected void btnSave_Click(object sender, EventArgs e) { if (Validate_Control()) { Exhibition ex = new Exhibition(); ex.Id = Convert.ToInt32(hdID.Value); ex.ManagerId = Convert.ToInt32(hdManager.Value); ex.ExhibitionDescription = txtEdit.Text; ex.StartDate = DateTime.Parse(txtEditStart.Text); ex.EndDate = DateTime.Parse(txtEditEnd.Text); if (ExhibitionDAO.Update(ex)) Flash.dictFlash.Add("success", "Update successfully"); else Flash.dictFlash.Add("danger", "Update error"); Response.Redirect("List.aspx"); } }
public static Exhibition Find(int Id) { DBUtilities.objConnection = new SqlConnection(DBUtilities.connStr); DataTable dt = new DataTable(); string sql = "Select * from [Exhibitions] where Id = @Id"; SqlDataAdapter adap = new SqlDataAdapter(sql, DBUtilities.objConnection); adap.SelectCommand.Parameters.AddWithValue("@Id", Id); adap.Fill(dt); if (dt.Rows.Count > 0) { Exhibition e = new Exhibition(); e.Id = Convert.ToInt32(dt.Rows[0]["Id"]); e.ManagerId = Convert.ToInt32(dt.Rows[0]["ManagerId"]); e.ExhibitionName = dt.Rows[0]["ExhibitionName"].ToString(); e.StartDate = Convert.ToDateTime(dt.Rows[0]["StartDate"]); e.EndDate = Convert.ToDateTime(dt.Rows[0]["EndDate"]); e.ExhibitionDescription = dt.Rows[0]["ExhibitionDescription"].ToString(); return e; } return null; }
public static bool Update(Exhibition e) { DBUtilities.Connection(); try { string sql = "Update [Exhibitions] set "; Type myType = e.GetType(); IList<PropertyInfo> props = new List<PropertyInfo>(myType.GetProperties()); int i = 1; int j = 1; foreach (PropertyInfo prop in props) { object propValue = prop.GetValue(e, null); if (propValue != null && prop.Name != "Id") { if (j < props.Count) sql += String.Format("{0} = @{1} ,", prop.Name, i); else sql += String.Format("{0} = @{1} where ID= @{2}", prop.Name, i, i + 1); i++; } j++; } i = 1; j = 1; SqlCommand cmd = new SqlCommand(sql, DBUtilities.objConnection); foreach (PropertyInfo prop in props) { object propValue = prop.GetValue(e, null); if (propValue != null && prop.Name != "Id") { if (j < props.Count) cmd.Parameters.AddWithValue(String.Format("@{0}", i), propValue); else { cmd.Parameters.AddWithValue(String.Format("@{0}", i), propValue); cmd.Parameters.AddWithValue(String.Format("@{0}", i + 1), e.Id); } i++; } j++; } cmd.ExecuteNonQuery(); cmd.Dispose(); return true; } catch (Exception) { return false; } finally { DBUtilities.Close_Connection(); } }