private void Search()
{
SqlInt32 BranchID = SqlInt32.Null;
SqlString CustomerName = SqlString.Null;
SqlInt32 DistributorID = SqlInt32.Null;
SqlInt32 ProductID = SqlInt32.Null;
SqlDateTime FromDate = SqlDateTime.Null;
SqlDateTime ToDate = SqlDateTime.Null;
if (ddlBranchID.SelectedIndex > 0)
{
BranchID = Convert.ToInt32(ddlBranchID.SelectedValue);
}
if (ddlCustomerID.Text.Trim() != "")
{
CustomerName = Convert.ToString(ddlCustomerID.Text.Trim());
}
if (ddlDistributorID.SelectedIndex > 0)
{
DistributorID = Convert.ToInt32(ddlDistributorID.SelectedValue);
}
if (ddlProductID.SelectedIndex > 0)
{
ProductID = Convert.ToInt32(ddlProductID.SelectedValue);
}
if (txtfromdate.Text.Trim() != "")
{
FromDate = DateTime.Parse(txtfromdate.Text.Trim());
}
if (txttodate.Text.Trim() != "")
{
ToDate = DateTime.Parse(txttodate.Text.Trim());
}
OccasionallyOrderBAL balOccasionallyOrder = new OccasionallyOrderBAL();
DataTable dtOccasionallyOrder = balOccasionallyOrder.OccasionallyOrderSelectSearch(BranchID, CustomerName, DistributorID, ProductID, FromDate, ToDate);
if (dtOccasionallyOrder != null && dtOccasionallyOrder.Rows.Count > 0)
{
gvOccasionallyOrder.DataSource = dtOccasionallyOrder;
gvOccasionallyOrder.DataBind();
}
else
{
gvOccasionallyOrder.DataSource = null;
gvOccasionallyOrder.DataBind();
}
}
private void FillOccasionallyOrderGridView()
{
if (Session["UserID"] != null)
{
OccasionallyOrderBAL balOccasionallyOrder = new OccasionallyOrderBAL();
DataTable dtOccasionallyOrder = balOccasionallyOrder.SelectAll();
if (dtOccasionallyOrder != null && dtOccasionallyOrder.Rows.Count > 0)
{
gvOccasionallyOrder.DataSource = dtOccasionallyOrder;
gvOccasionallyOrder.DataBind();
}
}
}
protected void gvOccasionallyOrder_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "DeleteRecord" && e.CommandArgument != null)
{
OccasionallyOrderBAL balOccasionallyOrder = new OccasionallyOrderBAL();
if (balOccasionallyOrder.Delete(Convert.ToInt32(e.CommandArgument)))
{
FillOccasionallyOrderGridView();
}
else
{
lblMessage.Text = balOccasionallyOrder.Message;
}
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message.ToString();
}
}
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;
}
}
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();
}
}