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();
}
}
}
}
