public BloodGroupENT SelectByPK(SqlInt32 BloodGroupID) { using (SqlConnection objConn = new SqlConnection(ConnectionString)) { objConn.Open(); using (SqlCommand objCmd = objConn.CreateCommand()) { try { #region Prepare Command objCmd.CommandType = CommandType.StoredProcedure; objCmd.CommandText = "PR_BloodGroup_SelectByPK"; objCmd.Parameters.AddWithValue("@BloodGroupID", BloodGroupID); #endregion Prepare Command #region ReadData and Set Controls BloodGroupENT entBloodGroup = new BloodGroupENT(); using (SqlDataReader objSDR = objCmd.ExecuteReader()) { while (objSDR.Read()) { if (!objSDR["BloodGroupID"].Equals(DBNull.Value)) { entBloodGroup.BloodGroupID = Convert.ToInt32(objSDR["BloodGroupID"]); } if (!objSDR["BloodGroupName"].Equals(DBNull.Value)) { entBloodGroup.BloodGroupName = Convert.ToString(objSDR["BloodGroupName"]); } } } return(entBloodGroup); #endregion ReadData and Set Controls } catch (SqlException sqlex) { Message = sqlex.Message.ToString(); return(null); } catch (Exception ex) { Message = ex.Message.ToString(); return(null); } finally { if (objConn.State == ConnectionState.Open) { objConn.Close(); } } } } }
protected void btnSave_Click(object sender, EventArgs e) { #region Server Side Validation lblError.Text = ""; if (txtBloodGroupName.Text.Trim().ToUpper() == "") { lblError.Text += "Enter BloodGroup Name <br/>"; } if (lblError.Text != "") { return; } #endregion Server Side Validation #region Collecting Data BloodGroupENT entBloodGroup = new BloodGroupENT(); if (txtBloodGroupName.Text.Trim().ToUpper() != "") { entBloodGroup.BloodGroupName = txtBloodGroupName.Text.Trim().ToUpper(); } BloodGroupBAL balBloodGroup = new BloodGroupBAL(); #endregion Collecting Data if (Request.QueryString["BloodGroupID"] == null) { #region insertingData if (balBloodGroup.Insert(entBloodGroup)) { Response.Redirect("~/AdminPanel/BloodGroup/BloodGroupList.aspx"); } else { lblError.Text = balBloodGroup.Message; } #endregion insertingData } else { #region updatingData entBloodGroup.BloodGroupID = Convert.ToInt32(Request.QueryString["BloodGroupID"]); if (balBloodGroup.Update(entBloodGroup)) { Response.Redirect("~/AdminPanel/BloodGroup/BloodGroupList.aspx"); } else { lblError.Text = balBloodGroup.Message; } #endregion updatingData } }
public Boolean Update(BloodGroupENT entBloodGroup) { BloodGroupDAL dalBloodGroup = new BloodGroupDAL(); if (dalBloodGroup.Update(entBloodGroup)) { return(true); } else { Message = dalBloodGroup.Message; return(false); } }
public Boolean Insert(BloodGroupENT entBloodGroup) { using (SqlConnection objConn = new SqlConnection(ConnectionString)) { objConn.Open(); using (SqlCommand objCmd = objConn.CreateCommand()) { try { #region Prepare Command objCmd.CommandType = CommandType.StoredProcedure; objCmd.CommandText = "PR_BloodGroup_Insert"; objCmd.Parameters.Add("@BloodGroupID", SqlDbType.Int).Direction = ParameterDirection.Output; objCmd.Parameters.AddWithValue("@BloodGroupName", SqlDbType.VarChar).Value = entBloodGroup.BloodGroupName; #endregion Prepare Command objCmd.ExecuteNonQuery(); if (objCmd.Parameters["@BloodGroupID"] != null) { entBloodGroup.BloodGroupID = Convert.ToInt32(objCmd.Parameters["@BloodGroupID"].Value); } return(true); } catch (SqlException sqlex) { Message = sqlex.Message.ToString(); return(false); } catch (Exception ex) { Message = ex.Message.ToString(); return(false); } finally { if (objConn.State == ConnectionState.Open) { objConn.Close(); } } } } }
private void fillControls(SqlInt32 BloodGroupID) { BloodGroupENT entBloodGroup = new BloodGroupENT(); BloodGroupBAL balBloodGroup = new BloodGroupBAL(); entBloodGroup = balBloodGroup.SelectByPK(BloodGroupID); if (entBloodGroup != null) { if (!entBloodGroup.BloodGroupName.IsNull) { txtBloodGroupName.Text = entBloodGroup.BloodGroupName.Value.ToString(); } } else { lblError.Text = balBloodGroup.Message; } }
public Boolean Update(BloodGroupENT entBloodGroup) { using (SqlConnection objConn = new SqlConnection(ConnectionString)) { objConn.Open(); using (SqlCommand objCmd = objConn.CreateCommand()) { try { #region Prepare Command objCmd.CommandType = CommandType.StoredProcedure; objCmd.CommandText = "PR_BloodGroup_UpdateByPK"; objCmd.Parameters.AddWithValue("@BloodGroupID", entBloodGroup.BloodGroupID); objCmd.Parameters.AddWithValue("@BloodGroupName", entBloodGroup.BloodGroupName); #endregion Prepare Command objCmd.ExecuteNonQuery(); return(true); } catch (SqlException sqlex) { Message = sqlex.Message.ToString(); return(false); } catch (Exception ex) { Message = ex.Message.ToString(); return(false); } finally { if (objConn.State == ConnectionState.Open) { objConn.Close(); } } } } }