protected void btnAccept_Click(object sender, EventArgs e) { if (Validate_Control()) { InstutiteOfFineArt.Models.Award a = new InstutiteOfFineArt.Models.Award(); a.AwardName = txtAwardName.Text; a.CompetitionId = Convert.ToInt32(drlCompetitionId.SelectedValue); a.PaintingId = Convert.ToInt32(txtPatingID.Value); if (rdb1st.Checked) a.AwardRank = "1st"; else if (rdb2nd.Checked) a.AwardRank = "2nd"; else a.AwardRank = "3rd"; a.AwardDescription = txtAwardDesc.Text; if (AwardDAO.Create(a)) { Flash.dictFlash.Add("success", String.Format("Created Award [<b>{0}</b>] successfully", a.AwardName)); Response.Redirect("/awards"); } else { Flash.dictFlash.Add("danger", "[<b>Award name</b>] are already used"); Response.Redirect("New.aspx"); } } }
public static bool Create(Award a) { DBUtilities.Connection(); try { string sql = "Insert into Awards (AwardName,AwardRank,AwardDescription,PaintingId,CompetitionId)"; sql += " values (@1,@2,@3,@4,@5)"; SqlCommand cmd = new SqlCommand(sql, DBUtilities.objConnection); cmd.Parameters.AddWithValue("@1", a.AwardName); cmd.Parameters.AddWithValue("@2", a.AwardRank); cmd.Parameters.AddWithValue("@3", a.AwardDescription); cmd.Parameters.AddWithValue("@4", a.PaintingId); cmd.Parameters.AddWithValue("@5", a.CompetitionId); cmd.ExecuteNonQuery(); cmd.Dispose(); return true; } catch (Exception) { return false; } finally { DBUtilities.Close_Connection(); } }
public static Award Find(int id) { DBUtilities.objConnection = new SqlConnection(DBUtilities.connStr); DataTable dt = new DataTable(); string sql = "Select * from Awards where Id = @Id"; SqlDataAdapter adap = new SqlDataAdapter(sql, DBUtilities.objConnection); adap.SelectCommand.Parameters.AddWithValue("@Id", id); adap.Fill(dt); if (dt.Rows.Count > 0) { Award a = new Award(); a.Id = Convert.ToInt32(dt.Rows[0]["Id"]); a.AwardName = dt.Rows[0]["AwardName"].ToString(); a.AwardRank = dt.Rows[0]["AwardRank"].ToString(); a.AwardDescription = dt.Rows[0]["AwardDescription"].ToString(); a.PaintingId = Convert.ToInt32(dt.Rows[0]["PaintingId"]); a.CompetitionId = Convert.ToInt32(dt.Rows[0]["CompetitionId"]); return a; } return null; }
public static bool Destroy(Award a) { DBUtilities.Connection(); try { string sql = "Delete from Awards where Id = @1"; SqlCommand cmd = new SqlCommand(sql, DBUtilities.objConnection); cmd.Parameters.AddWithValue("@1", a.Id); cmd.ExecuteNonQuery(); cmd.Dispose(); return true; } catch (Exception) { return false; } finally { DBUtilities.Close_Connection(); } }
protected void btnAccept_Click(object sender, EventArgs e) { Award a = new Award(); a.CompetitionId = Convert.ToInt32(hdID.Value); a.PaintingId = Convert.ToInt32(hdIDPaint.Value); a.AwardName = txtAdName.Text; if (rdb1st.Checked) a.AwardRank = "1st"; else if (rdb2nd.Checked) a.AwardRank = "2nd"; else a.AwardRank = "3rd"; a.AwardDescription = txtAwardDesc.Text; if (Check_Paint_Award(a.CompetitionId, a.PaintingId, a.AwardRank)) { if (AwardDAO.Create(a)) Flash.dictFlash.Add("success", "Set award successfully"); else Flash.dictFlash.Add("danger", "Set award error"); } }
public static bool Update(Award a) { DBUtilities.Connection(); try { string sql = "Update Awards set "; Type myType = a.GetType(); IList<PropertyInfo> props = new List<PropertyInfo>(myType.GetProperties()); int i = 1; int j = 1; foreach (PropertyInfo prop in props) { object propValue = prop.GetValue(a, 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(a, 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), a.Id); } i++; } j++; } cmd.ExecuteNonQuery(); cmd.Dispose(); return true; } catch (Exception) { return false; } finally { DBUtilities.Close_Connection(); } }