private void LoadControls(SqlInt32 BranchID) { BranchENT entBranch = new BranchENT(); BranchBAL balBranch = new BranchBAL(); entBranch = balBranch.SelectByPK(BranchID); if (!entBranch.BranchName.IsNull) { txtBranchName.Text = entBranch.BranchName.Value.ToString(); } if (!entBranch.MobileNo.IsNull) { txtMobileNo.Text = entBranch.MobileNo.Value.ToString(); } if (!entBranch.Address.IsNull) { txtBranchAddress.Text = entBranch.Address.Value.ToString(); } if (!entBranch.ManagerName.IsNull) { txtManagerName.Text = entBranch.ManagerName.Value.ToString(); } if (!entBranch.ManagerMobileNo.IsNull) { txtManagerMobileNo.Text = entBranch.ManagerMobileNo.Value.ToString(); } }
public Boolean Update(BranchENT entBranch) { BranchDAL branchDAL = new BranchDAL(); if (branchDAL.Update(entBranch)) { return(true); } else { this.Message = branchDAL.Message; return(false); } }
public Boolean Update(BranchENT entBranch) { using (SqlConnection objConn = new SqlConnection(ConnectionString)) { objConn.Open(); using (SqlCommand objCmd = objConn.CreateCommand()) try { #region Prepare Command objCmd.CommandType = CommandType.StoredProcedure; objCmd.CommandText = "PR_Branch_UpdateByPK"; objCmd.Parameters.AddWithValue("@BranchID", entBranch.BranchID); objCmd.Parameters.AddWithValue("@BranchName", entBranch.BranchName); objCmd.Parameters.AddWithValue("@MobileNo", entBranch.MobileNo); objCmd.Parameters.AddWithValue("@Address", entBranch.Address); objCmd.Parameters.AddWithValue("@UserID", entBranch.UserID); objCmd.Parameters.AddWithValue("@ManagerName", entBranch.ManagerName); objCmd.Parameters.AddWithValue("@ManagerMobileNo", entBranch.ManagerMobileNo); #endregion Prepare Command objCmd.ExecuteNonQuery(); return(true); } catch (SqlException sqlex) { Message = sqlex.InnerException.Message.ToString(); return(false); } catch (Exception ex) { Message = ex.InnerException.Message.ToString(); return(false); } finally { if (objConn.State == ConnectionState.Open) { objConn.Close(); } } } }
protected void btnSave_Click(object sender, EventArgs e) { try { #region Server Side Validation String strError = String.Empty; if (txtBranchName.Text.Trim() == String.Empty) { strError += "- Enter Branch Name<br />"; } if (txtMobileNo.Text.Trim() == String.Empty) { strError += "- Enter Mobile No<br />"; } if (txtBranchAddress.Text.Trim() == String.Empty) { strError += "- Enter Branch Address<br />"; } if (txtManagerName.Text.Trim() == String.Empty) { strError += "- Enter Manager Name<br />"; } if (txtManagerMobileNo.Text.Trim() == String.Empty) { strError += "- Enter Manager MobileNo<br />"; } #endregion Server Side Validation BranchENT entBranch = new BranchENT(); BranchBAL balBranch = new BranchBAL(); #region Gather Data if (txtBranchName.Text.Trim() != String.Empty) { entBranch.BranchName = txtBranchName.Text.Trim(); } if (txtMobileNo.Text.Trim() != String.Empty) { entBranch.MobileNo = txtMobileNo.Text.Trim(); } if (txtBranchAddress.Text.Trim() != String.Empty) { entBranch.Address = txtBranchAddress.Text.Trim(); } if (txtManagerName.Text.Trim() != String.Empty) { entBranch.ManagerName = txtManagerName.Text.Trim(); } if (txtManagerMobileNo.Text.Trim() != String.Empty) { entBranch.ManagerMobileNo = txtManagerMobileNo.Text.Trim(); } entBranch.UserID = Convert.ToInt32(Session["UserID"]); if (Request.QueryString["BranchID"] == null) { balBranch.Insert(entBranch); lblMessage.Text = "Data Inserted Successfully"; ClearControls(); } else { entBranch.BranchID = Convert.ToInt32(Request.QueryString["BranchID"]); balBranch.Update(entBranch); Response.Redirect("~/AdminPanel/Branch/BranchList.aspx"); } #endregion Gather Data } catch (Exception ex) { lblErrorMessage.Text = ex.Message.ToString(); } }
public BranchENT SelectByPK(SqlInt32 BranchID) { using (SqlConnection objConn = new SqlConnection(ConnectionString)) { objConn.Open(); using (SqlCommand objcmd = objConn.CreateCommand()) try { #region Prepar Command objcmd.CommandType = CommandType.StoredProcedure; objcmd.CommandText = "PR_Branch_SelectByPK"; objcmd.Parameters.AddWithValue("@BranchID", BranchID); #endregion Prepar Command #region ReadData and Set Controls BranchENT entBranch = new BranchENT(); using (SqlDataReader objSDR = objcmd.ExecuteReader()) { while (objSDR.Read()) { if (!objSDR["BranchID"].Equals(DBNull.Value)) { entBranch.BranchID = Convert.ToInt32(objSDR["BranchID"]); } if (!objSDR["UserID"].Equals(DBNull.Value)) { entBranch.UserID = Convert.ToInt32(objSDR["UserID"]); } if (!objSDR["BranchName"].Equals(DBNull.Value)) { entBranch.BranchName = Convert.ToString(objSDR["BranchName"]); } if (!objSDR["MobileNo"].Equals(DBNull.Value)) { entBranch.MobileNo = Convert.ToString(objSDR["MobileNo"]); } if (!objSDR["Address"].Equals(DBNull.Value)) { entBranch.Address = Convert.ToString(objSDR["Address"]); } if (!objSDR["ManagerName"].Equals(DBNull.Value)) { entBranch.ManagerName = Convert.ToString(objSDR["ManagerName"]); } if (!objSDR["ManagerMobileNo"].Equals(DBNull.Value)) { entBranch.ManagerMobileNo = Convert.ToString(objSDR["ManagerMobileNo"]); } } } return(entBranch); #endregion ReadData and Set Controls } catch (SqlException sqlex) { Message = sqlex.InnerException.Message.ToString(); return(null); } catch (Exception ex) { Message = ex.InnerException.Message.ToString(); return(null); } finally { if (objConn.State == ConnectionState.Open) { objConn.Close(); } } } }