public Boolean Insert(JobworkReturnENT entJobworkReturn)
{
using (SqlConnection objConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand objcmd = objConnection.CreateCommand())
{
try
{
objConnection.Open();
#region Prepare Command
objcmd.CommandType = CommandType.StoredProcedure;
objcmd.CommandText = "PR_JobworkReturn_Insert";
objcmd.Parameters.AddWithValue("@JobworkOrderID", entJobworkReturn.JobworkOrderID);
objcmd.Parameters.AddWithValue("@CustomerID", entJobworkReturn.CustomerID);
objcmd.Parameters.AddWithValue("@ProductID", entJobworkReturn.ProductID);
objcmd.Parameters.AddWithValue("@IssueGross", entJobworkReturn.IssueGross);
objcmd.Parameters.AddWithValue("@ReturnGross", entJobworkReturn.ReturnGross);
objcmd.Parameters.AddWithValue("@PendingGross", entJobworkReturn.PendingGross);
objcmd.Parameters.AddWithValue("@CompleteGross", entJobworkReturn.CompleteGross);
objcmd.Parameters.AddWithValue("@UserID", entJobworkReturn.UserID);
objcmd.Parameters.AddWithValue("@CreationDate", entJobworkReturn.CreationDate);
#endregion Prepare Command
#region ReadData And SetData
objcmd.ExecuteNonQuery();
return(true);
#endregion ReadData And SetData
}
catch (SqlException Sqlex)
{
Message = Sqlex.Message.ToString();
return(false);
}
catch (Exception ex)
{
Message = ex.Message.ToString();
return(false);
}
finally
{
if (objConnection.State == ConnectionState.Open)
{
objConnection.Close();
}
}
}
}
}
public Boolean Update(JobworkReturnENT entJobworkReturn)
{
JobworkReturnDAL dalJobworkReturn = new JobworkReturnDAL();
if (dalJobworkReturn.Update(entJobworkReturn))
{
return(true);
}
else
{
this.Message = dalJobworkReturn.Message;
return(false);
}
}
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
}
public JobworkReturnENT SelectByPK(SqlInt32 JobworkReturnID)
{
using (SqlConnection objConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand objcmd = objConnection.CreateCommand())
{
try
{
objConnection.Open();
#region Prepare Command
objcmd.CommandType = CommandType.StoredProcedure;
objcmd.CommandText = "PR_JobworkReturn_SelectByPK";
objcmd.Parameters.AddWithValue("@JobworkReturnID", JobworkReturnID.ToString());
#endregion Prepare Command
#region ReadData And SetData
JobworkReturnENT entJobworkReturn = new JobworkReturnENT();
using (SqlDataReader objSDR = objcmd.ExecuteReader())
{
while (objSDR.Read())
{
if (!objSDR["JobworkReturnID"].Equals(DBNull.Value))
{
entJobworkReturn.JobworkReturnID = Convert.ToInt32(objSDR["JobworkReturnID"]);
}
if (!objSDR["JobworkOrderID"].Equals(DBNull.Value))
{
entJobworkReturn.JobworkOrderID = Convert.ToInt32(objSDR["JobworkOrderID"]);
}
if (!objSDR["CustomerID"].Equals(DBNull.Value))
{
entJobworkReturn.CustomerID = Convert.ToInt32(objSDR["CustomerID"]);
}
if (!objSDR["ProductID"].Equals(DBNull.Value))
{
entJobworkReturn.ProductID = Convert.ToInt32(objSDR["ProductID"]);
}
if (!objSDR["IssueGross"].Equals(DBNull.Value))
{
entJobworkReturn.IssueGross = Convert.ToInt32(objSDR["IssueGross"]);
}
if (!objSDR["ReturnGross"].Equals(DBNull.Value))
{
entJobworkReturn.ReturnGross = Convert.ToInt32(objSDR["ReturnGross"]);
}
if (!objSDR["PendingGross"].Equals(DBNull.Value))
{
entJobworkReturn.PendingGross = Convert.ToInt32(objSDR["PendingGross"]);
}
if (!objSDR["CompleteGross"].Equals(DBNull.Value))
{
entJobworkReturn.CompleteGross = Convert.ToInt32(objSDR["CompleteGross"]);
}
}
}
return(entJobworkReturn);
#endregion ReadData And SetData
}
catch (SqlException Sqlex)
{
Message = Sqlex.Message.ToString();
return(null);
}
catch (Exception ex)
{
Message = ex.Message.ToString();
return(null);
}
finally
{
if (objConnection.State == ConnectionState.Open)
{
objConnection.Close();
}
}
}
}
}