protected void gvJobworkReturn_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "DeleteRecord" && e.CommandArgument != null)
{
JobworkReturnBAL balJobworkReturn = new JobworkReturnBAL();
if (balJobworkReturn.Delete(Convert.ToInt32(e.CommandArgument)))
{
FillJobworkReturnGridView(Convert.ToInt32(Session["UserID"]));
}
else
{
lblMessage.Text = balJobworkReturn.Message;
}
}
}
private void FillJobworkReturnGridView(SqlInt32 CustomerID)
{
JobworkReturnBAL balJobworkReturn = new JobworkReturnBAL();
DataTable dtJobworkReturn = balJobworkReturn.SelectByCustomerName(CustomerID);
if (dtJobworkReturn != null && dtJobworkReturn.Rows.Count > 0)
{
gvJobworkReturn.DataSource = dtJobworkReturn;
gvJobworkReturn.DataBind();
lblMessage.Text = "No Of Record : " + dtJobworkReturn.Rows.Count.ToString();
}
else
{
lblMessage.Text = "No Data Here";
gvJobworkReturn.DataSource = null;
gvJobworkReturn.DataBind();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Page.Validate();
if (Page.IsValid)
{
try
{
JobworkReturnBAL balJobworkReturn = new JobworkReturnBAL();
JobworkReturnENT entJobworkReturn = new JobworkReturnENT();
#region 15.1 Validate Fields
String ErrorMsg = String.Empty;
if (ddlCustomer.SelectedIndex <= 0 || ddlCustomer.SelectedValue == "-99")
{
ErrorMsg += " Order Name";
}
if (ErrorMsg != String.Empty)
{
lblMessage.Text = ErrorMsg;
lblMessage.ForeColor = Color.Red;
return;
}
#endregion 15.1 Validate Fields
#region 15.2 Gather Data
foreach (GridViewRow row in gvJobworkReturn.Rows)
{
//entJobworkReturn.JobworkReturnID = 23;
entJobworkReturn.JobworkReturnID = Convert.ToInt32(((HiddenField)row.Cells[6].FindControl("hfJobworkReturnID")).Value);
entJobworkReturn = balJobworkReturn.SelectByPK(entJobworkReturn.JobworkReturnID);
TextBox txt = (TextBox)row.Cells[6].FindControl("txtCompleteGross");
string txtCompleteGross = txt.Text;
if (txtCompleteGross.Trim() != String.Empty)
{
entJobworkReturn.CompleteGross = Convert.ToInt32(txtCompleteGross);
}
else
{
entJobworkReturn.CompleteGross = 0;
}
// entJobworkReturn.JobworkOrderID = Convert.ToInt32((txtCompleteGross.FindControl("hfJobWorkOrderID") as HiddenField).Value);
//if (txtCompleteGross.Text.Trim() != String.Empty)
// entJobworkReturn.CompleteGross = Convert.ToInt32(txtCompleteGross.Text);
//entJobworkReturn.JobworkOrderID = Convert.ToInt32(((HiddenField)gvJobworkReturn.SelectedRow.FindControl("hfJobWorkOrderID")).Value);
//entJobworkReturn.JobworkOrderID = entJobworkReturn.JobworkOrderID;
//if (ddlCustomer.SelectedIndex > 0)
// entJobworkReturn.CustomerID = Convert.ToInt32(ddlCustomer.SelectedValue);
//entJobworkReturn.ProductID = entJobworkReturn.ProductID;
//entJobworkReturn.IssueGross = entJobworkReturn.IssueGross;
//entJobworkReturn.ReturnGross = entJobworkReturn.ReturnGross;
//entJobworkReturn.PendingGross = entJobworkReturn.PendingGross;
entJobworkReturn.UserID = Convert.ToInt32(Session["UserID"]);
entJobworkReturn.CreationDate = DateTime.Now;
balJobworkReturn.Update(entJobworkReturn);
}
#endregion 15.2 Gather Data
#region 15.3 Insert,Update,Copy
if (Page.RouteData.Values["JobworkReturnID"] == null)
{
FillJobworkReturnGridView(Convert.ToInt32(ddlCustomer.SelectedValue));
}
#endregion 15.3 Insert,Update,Copy
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
//lblMessage.CssClass = CSSClass.alertdanger;
lblMessage.ForeColor = Color.Red;
}
}
}
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
}
