public Boolean Update(OccasionallyOrderENT entOccasionallyOrder)
{
OccasionallyOrderDAL occasionallyOrderDAL = new OccasionallyOrderDAL();
if (occasionallyOrderDAL.Update(entOccasionallyOrder))
{
return(true);
}
else
{
this.Message = occasionallyOrderDAL.Message;
return(false);
}
}
public Boolean Update(OccasionallyOrderENT entOccasionallyOrder)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_OccasionallyOrder_UpdateByPK";
objCmd.Parameters.AddWithValue("@OccasionallyOrderID", entOccasionallyOrder.OccasionallyOrderID);
objCmd.Parameters.AddWithValue("@BranchID", entOccasionallyOrder.BranchID);
objCmd.Parameters.AddWithValue("@DistributorID", entOccasionallyOrder.DistributorID);
objCmd.Parameters.AddWithValue("@ProductID", entOccasionallyOrder.ProductID);
objCmd.Parameters.AddWithValue("@CustomerName", entOccasionallyOrder.CustomerName);
objCmd.Parameters.AddWithValue("@MobileNo", entOccasionallyOrder.MobileNo);
objCmd.Parameters.AddWithValue("@Address", entOccasionallyOrder.Address);
objCmd.Parameters.AddWithValue("@Quantity", entOccasionallyOrder.Quantity);
objCmd.Parameters.AddWithValue("@TotalAmount", entOccasionallyOrder.TotalAmount);
objCmd.Parameters.AddWithValue("@OrderDate", entOccasionallyOrder.OrderDate);
objCmd.Parameters.AddWithValue("@BottleIn", entOccasionallyOrder.BottleIn);
objCmd.Parameters.AddWithValue("@Status", entOccasionallyOrder.Status);
objCmd.Parameters.AddWithValue("@UserID", entOccasionallyOrder.UserID);
#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();
}
}
}
}
private void LoadControls(SqlInt32 OccasionallyOrderID)
{
OccasionallyOrderENT entOccasionallyOrder = new OccasionallyOrderENT();
OccasionallyOrderBAL balOccasionallyOrder = new OccasionallyOrderBAL();
entOccasionallyOrder = balOccasionallyOrder.SelectByPK(OccasionallyOrderID);
if (!entOccasionallyOrder.CustomerName.IsNull)
{
txtCustomerName.Text = entOccasionallyOrder.CustomerName.Value.ToString();
}
if (!entOccasionallyOrder.MobileNo.IsNull)
{
txtMobileNo.Text = entOccasionallyOrder.MobileNo.Value.ToString();
}
if (!entOccasionallyOrder.Address.IsNull)
{
txtCustomerAddress.Text = entOccasionallyOrder.Address.Value.ToString();
}
if (!entOccasionallyOrder.BranchID.IsNull)
{
ddlBranchID.SelectedValue = entOccasionallyOrder.BranchID.Value.ToString();
}
if (!entOccasionallyOrder.DistributorID.IsNull)
{
ddlDistributorID.SelectedValue = entOccasionallyOrder.DistributorID.Value.ToString();
}
if (!entOccasionallyOrder.ProductID.IsNull)
{
ddlProductID.SelectedValue = entOccasionallyOrder.ProductID.Value.ToString();
}
if (!entOccasionallyOrder.Quantity.IsNull)
{
txtQuantity.Text = entOccasionallyOrder.Quantity.Value.ToString();
}
if (!entOccasionallyOrder.TotalAmount.IsNull)
{
txtTotalAmount.Text = entOccasionallyOrder.TotalAmount.Value.ToString();
}
if (!entOccasionallyOrder.OrderDate.IsNull)
{
txtOrderDate.Text = entOccasionallyOrder.OrderDate.Value.ToString("yyyy-MM-dd");
}
if (!entOccasionallyOrder.BottleIn.IsNull)
{
txtBottleIn.Text = entOccasionallyOrder.BottleIn.Value.ToString();
}
if (!entOccasionallyOrder.Status.IsNull)
{
ckbStatus.Checked = entOccasionallyOrder.Status.Value;
}
}
public OccasionallyOrderENT SelectByPK(SqlInt32 OccasionallyOrderID)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objcmd = objConn.CreateCommand())
try
{
#region Prepar Command
objcmd.CommandType = CommandType.StoredProcedure;
objcmd.CommandText = "PR_OccasionallyOrder_SelectByPK";
objcmd.Parameters.AddWithValue("@OccasionallyOrderID", OccasionallyOrderID);
#endregion Prepar Command
#region ReadData and Set Controls
OccasionallyOrderENT entOccasionallyOrder = new OccasionallyOrderENT();
using (SqlDataReader objSDR = objcmd.ExecuteReader())
{
while (objSDR.Read())
{
if (!objSDR["OccasionallyOrderID"].Equals(DBNull.Value))
{
entOccasionallyOrder.OccasionallyOrderID = Convert.ToInt32(objSDR["OccasionallyOrderID"]);
}
if (!objSDR["BranchID"].Equals(DBNull.Value))
{
entOccasionallyOrder.BranchID = Convert.ToInt32(objSDR["BranchID"]);
}
if (!objSDR["DistributorID"].Equals(DBNull.Value))
{
entOccasionallyOrder.DistributorID = Convert.ToInt32(objSDR["DistributorID"]);
}
if (!objSDR["ProductID"].Equals(DBNull.Value))
{
entOccasionallyOrder.ProductID = Convert.ToInt32(objSDR["ProductID"]);
}
if (!objSDR["CustomerName"].Equals(DBNull.Value))
{
entOccasionallyOrder.CustomerName = Convert.ToString(objSDR["CustomerName"]);
}
if (!objSDR["MobileNo"].Equals(DBNull.Value))
{
entOccasionallyOrder.MobileNo = Convert.ToString(objSDR["MobileNo"]);
}
if (!objSDR["Address"].Equals(DBNull.Value))
{
entOccasionallyOrder.Address = Convert.ToString(objSDR["Address"]);
}
if (!objSDR["Quantity"].Equals(DBNull.Value))
{
entOccasionallyOrder.Quantity = Convert.ToInt32(objSDR["Quantity"]);
}
if (!objSDR["TotalAmount"].Equals(DBNull.Value))
{
entOccasionallyOrder.TotalAmount = Convert.ToDecimal(objSDR["TotalAmount"]);
}
if (!objSDR["OrderDate"].Equals(DBNull.Value))
{
entOccasionallyOrder.OrderDate = Convert.ToDateTime(objSDR["OrderDate"]);
}
if (!objSDR["BottleIn"].Equals(DBNull.Value))
{
entOccasionallyOrder.BottleIn = Convert.ToInt32(objSDR["BottleIn"]);
}
if (!objSDR["Status"].Equals(DBNull.Value))
{
entOccasionallyOrder.Status = Convert.ToBoolean(objSDR["Status"]);
}
if (!objSDR["UserID"].Equals(DBNull.Value))
{
entOccasionallyOrder.UserID = Convert.ToInt32(objSDR["UserID"]);
}
}
}
return(entOccasionallyOrder);
#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();
}
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
#region Server Side Validation
String strError = String.Empty;
if (txtCustomerName.Text.Trim() == String.Empty)
{
strError += "- Enter Customer Name<br />";
}
if (txtMobileNo.Text.Trim() == String.Empty)
{
strError += "- Enter Mobile No<br />";
}
if (txtCustomerAddress.Text.Trim() == String.Empty)
{
strError += "- Enter Customer Address<br />";
}
if (ddlBranchID.SelectedIndex == 0)
{
strError += "- Select Branch<br />";
}
if (ddlDistributorID.SelectedIndex == 0)
{
strError += "- Select Distributor<br />";
}
if (ddlProductID.SelectedIndex == 0)
{
strError += "- Select Product<br />";
}
if (txtQuantity.Text.Trim() == String.Empty)
{
strError += "- Enter Quantity<br />";
}
if (txtTotalAmount.Text.Trim() == String.Empty)
{
strError += "- Enter Total Amount<br />";
}
if (txtOrderDate.Text.Trim() == String.Empty)
{
strError += "- Enter Order Date<br />";
}
if (txtBottleIn.Text.Trim() == String.Empty)
{
strError += "- Enter In Bottle<br />";
}
#endregion Server Side Validation
OccasionallyOrderENT entOccasionallyOrder = new OccasionallyOrderENT();
OccasionallyOrderBAL balOccasionallyOrder = new OccasionallyOrderBAL();
#region Gather Data
if (txtCustomerName.Text.Trim() != String.Empty)
{
entOccasionallyOrder.CustomerName = txtCustomerName.Text.Trim();
}
if (txtMobileNo.Text.Trim() != String.Empty)
{
entOccasionallyOrder.MobileNo = txtMobileNo.Text.Trim();
}
if (txtCustomerAddress.Text.Trim() != String.Empty)
{
entOccasionallyOrder.Address = txtCustomerAddress.Text.Trim();
}
if (ddlBranchID.SelectedIndex > 0)
{
entOccasionallyOrder.BranchID = Convert.ToInt32(ddlBranchID.SelectedValue);
}
if (ddlDistributorID.SelectedIndex > 0)
{
entOccasionallyOrder.DistributorID = Convert.ToInt32(ddlDistributorID.SelectedValue);
}
if (ddlProductID.SelectedIndex > 0)
{
entOccasionallyOrder.ProductID = Convert.ToInt32(ddlProductID.SelectedValue);
}
if (txtQuantity.Text.Trim() != String.Empty)
{
entOccasionallyOrder.Quantity = Convert.ToInt32(txtQuantity.Text.Trim());
}
if (txtTotalAmount.Text.Trim() != String.Empty)
{
entOccasionallyOrder.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text.Trim());
}
if (txtOrderDate.Text.Trim() != String.Empty)
{
entOccasionallyOrder.OrderDate = Convert.ToDateTime(txtOrderDate.Text.Trim());
}
if (txtBottleIn.Text.Trim() != String.Empty)
{
entOccasionallyOrder.BottleIn = Convert.ToInt32(txtBottleIn.Text.Trim());
}
entOccasionallyOrder.Status = Convert.ToBoolean(ckbStatus.Checked);
entOccasionallyOrder.UserID = Convert.ToInt32(Session["UserID"]);
if (Request.QueryString["OccasionallyOrderID"] == null)
{
balOccasionallyOrder.Insert(entOccasionallyOrder);
lblMessage.Text = "Data Inserted Successfully";
ClearControls();
}
else
{
entOccasionallyOrder.OccasionallyOrderID = Convert.ToInt32(Request.QueryString["OccasionallyOrderID"]);
balOccasionallyOrder.Update(entOccasionallyOrder);
Response.Redirect("~/AdminPanel/OccasionallyOrder/OccasionallyOrderList.aspx");
}
#endregion Gather Data
}
catch (Exception ex)
{
lblErrorMessage.Text = ex.Message.ToString();
}
}
