private void LoadControls(SqlInt32 JobworkOrderID)
{
JobworkOrderENT entJobworkOrder = new JobworkOrderENT();
JobworkOrderBAL balJobworkOrder = new JobworkOrderBAL();
entJobworkOrder = balJobworkOrder.SelectByPK(JobworkOrderID);
if (!entJobworkOrder.CustomerID.IsNull)
{
ddlCustomer.SelectedValue = entJobworkOrder.CustomerID.Value.ToString();
}
if (!entJobworkOrder.ProductID.IsNull)
{
ddlProduct.Text = entJobworkOrder.ProductID.Value.ToString();
}
if (!entJobworkOrder.Gross.IsNull)
{
txtGross.Text = entJobworkOrder.Gross.Value.ToString();
}
if (!entJobworkOrder.Rate.IsNull)
{
txtRate.Text = entJobworkOrder.Rate.Value.ToString();
}
if (!entJobworkOrder.IssueDate.IsNull)
{
txtIssueDate.Text = entJobworkOrder.IssueDate.Value.ToString();
}
if (!entJobworkOrder.ReturnDate.IsNull)
{
txtReturnDate.Text = entJobworkOrder.ReturnDate.Value.ToString();
}
}
protected void gvJobworkOrder_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "DeleteRecord" && e.CommandArgument != null)
{
JobworkOrderBAL balJobworkOrder = new JobworkOrderBAL();
if (balJobworkOrder.Delete(Convert.ToInt32(e.CommandArgument)))
{
FillJobworkOrderGridView(Convert.ToInt32(Session["UserID"]));
}
else
{
lblMessage.Text = balJobworkOrder.Message;
}
}
}
private void FillJobworkOrderGridView(SqlInt32 UserID)
{
JobworkOrderBAL balJobworkOrder = new JobworkOrderBAL();
DataTable dtJobworkOrder = balJobworkOrder.SelectAll(UserID);
if (dtJobworkOrder != null && dtJobworkOrder.Rows.Count > 0)
{
gvJobworkOrder.DataSource = dtJobworkOrder;
gvJobworkOrder.DataBind();
lblMessage.Text = "No Of Record : " + dtJobworkOrder.Rows.Count.ToString();
}
else
{
lblMessage.Text = "No Data Here";
gvJobworkOrder.DataSource = null;
gvJobworkOrder.DataBind();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
#region ServerSide Validation
#endregion ServerSide Validations
JobworkOrderENT entJobworkOrder = new JobworkOrderENT();
JobworkOrderBAL balJobworkOrder = new JobworkOrderBAL();
JobworkReturnENT entJobworkReturn = new JobworkReturnENT();
JobworkReturnBAL balJobworkReturn = new JobworkReturnBAL();
#region Gather Data
if (ddlCustomer.SelectedIndex > 0)
{
entJobworkOrder.CustomerID = Convert.ToInt32(ddlCustomer.SelectedValue);
entJobworkReturn.CustomerID = Convert.ToInt32(ddlCustomer.SelectedValue);
}
if (ddlProduct.SelectedIndex > 0)
{
entJobworkOrder.ProductID = Convert.ToInt32(ddlProduct.SelectedValue);
entJobworkReturn.ProductID = Convert.ToInt32(ddlProduct.SelectedValue);
}
if (txtGross.Text.Trim() != String.Empty)
{
entJobworkOrder.Gross = Convert.ToInt32(txtGross.Text.Trim());
entJobworkReturn.IssueGross = Convert.ToInt32(txtGross.Text.Trim());
entJobworkReturn.PendingGross = Convert.ToInt32(txtGross.Text.Trim());
}
if (txtRate.Text.Trim() != String.Empty)
{
entJobworkOrder.Rate = Convert.ToInt32(txtRate.Text.Trim());
}
if (txtIssueDate.Text.Trim() != String.Empty)
{
entJobworkOrder.IssueDate = Convert.ToDateTime(txtIssueDate.Text.Trim());
}
if (txtReturnDate.Text.Trim() != String.Empty)
{
entJobworkOrder.ReturnDate = Convert.ToDateTime(txtReturnDate.Text.Trim());
}
entJobworkReturn.ReturnGross = 0;
entJobworkOrder.CreationDate = DateTime.Now;
entJobworkReturn.CreationDate = DateTime.Now;
entJobworkOrder.UserID = Convert.ToInt32(Session["UserID"]);
entJobworkReturn.UserID = Convert.ToInt32(Session["UserID"]);
if (Request.QueryString["JobworkOrderID"] == null)
{
Int32 JobworkOrderID = balJobworkOrder.Insert(entJobworkOrder);
if (JobworkOrderID > 0)
{
entJobworkReturn.JobworkOrderID = JobworkOrderID;
}
balJobworkReturn.Insert(entJobworkReturn);
lblMessage.Text = "Data Insert SuccessFully";
ClearControl();
}
else
{
entJobworkOrder.JobworkOrderID = Convert.ToInt32(Request.QueryString["JobworkOrderID"]);
balJobworkOrder.Update(entJobworkOrder);
Response.Redirect("~/AdminPanel/JobworkOrder/JobworkOrderList.aspx");
}
#endregion Gather Data
}