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();
}
}
public Int32 Insert(JobworkOrderENT entJobworkOrder)
{
using (SqlConnection objConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand objcmd = objConnection.CreateCommand())
{
try
{
objConnection.Open();
#region Prepare Command
objcmd.CommandType = CommandType.StoredProcedure;
objcmd.CommandText = "PR_JobworkOrder_Insert";
objcmd.Parameters.AddWithValue("@JobworkOrderID", SqlDbType.Int).Direction = ParameterDirection.Output;
objcmd.Parameters.AddWithValue("@CustomerID", entJobworkOrder.CustomerID);
objcmd.Parameters.AddWithValue("@ProductID", entJobworkOrder.ProductID);
objcmd.Parameters.AddWithValue("@Gross", entJobworkOrder.Gross);
objcmd.Parameters.AddWithValue("@Rate", entJobworkOrder.Rate);
objcmd.Parameters.AddWithValue("@IssueDate", entJobworkOrder.IssueDate);
objcmd.Parameters.AddWithValue("@ReturnDate", entJobworkOrder.ReturnDate);
objcmd.Parameters.AddWithValue("@UserID", entJobworkOrder.UserID);
objcmd.Parameters.AddWithValue("@CreationDate", entJobworkOrder.CreationDate);
#endregion Prepare Command
#region ReadData And SetData
objcmd.ExecuteNonQuery();
Int32 JobworkOrderID = Convert.ToInt32(objcmd.Parameters["@JobworkOrderID"].Value.ToString());
return(JobworkOrderID);
#endregion ReadData And SetData
}
catch (SqlException Sqlex)
{
Message = Sqlex.Message.ToString();
return(0);
}
catch (Exception ex)
{
Message = ex.Message.ToString();
return(0);
}
finally
{
if (objConnection.State == ConnectionState.Open)
{
objConnection.Close();
}
}
}
}
}
public Boolean Update(JobworkOrderENT entJobworkOrder)
{
using (SqlConnection objConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand objcmd = objConnection.CreateCommand())
{
try
{
objConnection.Open();
#region Prepare Command
objcmd.CommandType = CommandType.StoredProcedure;
objcmd.CommandText = "PR_JobworkOrder_UpdateByPK";
objcmd.Parameters.AddWithValue("@JobworkOrderID", entJobworkOrder.JobworkOrderID);
objcmd.Parameters.AddWithValue("@CustomerID", entJobworkOrder.CustomerID);
objcmd.Parameters.AddWithValue("@ProductID", entJobworkOrder.ProductID);
objcmd.Parameters.AddWithValue("@Gross", entJobworkOrder.Gross);
objcmd.Parameters.AddWithValue("@Rate", entJobworkOrder.Rate);
objcmd.Parameters.AddWithValue("@IssueDate", entJobworkOrder.IssueDate);
objcmd.Parameters.AddWithValue("@ReturnDate", entJobworkOrder.ReturnDate);
objcmd.Parameters.AddWithValue("@UserID", entJobworkOrder.UserID);
#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(JobworkOrderENT entJobworkOrder)
{
JobworkOrderDAL JobworkOrderDAL = new JobworkOrderDAL();
if (JobworkOrderDAL.Update(entJobworkOrder))
{
return(true);
}
else
{
this.Message = JobworkOrderDAL.Message;
return(false);
}
}
public Int32 Insert(JobworkOrderENT entJobworkOrder)
{
JobworkOrderDAL JobworkOrderDAL = new JobworkOrderDAL();
Int32 JobworkOrderID = JobworkOrderDAL.Insert(entJobworkOrder);
if (JobworkOrderID > 0)
{
return(JobworkOrderID);
}
else
{
this.Message = JobworkOrderDAL.Message;
return(0);
}
}
public JobworkOrderENT SelectByPK(SqlInt32 JobworkOrderID)
{
using (SqlConnection objConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand objcmd = objConnection.CreateCommand())
{
try
{
objConnection.Open();
#region Prepare Command
objcmd.CommandType = CommandType.StoredProcedure;
objcmd.CommandText = "PR_JobworkOrder_SelectByPK";
objcmd.Parameters.AddWithValue("@JobworkOrderID", JobworkOrderID.ToString());
#endregion Prepare Command
#region ReadData And SetData
JobworkOrderENT entJobworkOrder = new JobworkOrderENT();
using (SqlDataReader objSDR = objcmd.ExecuteReader())
{
while (objSDR.Read())
{
if (!objSDR["CustomerID"].Equals(DBNull.Value))
{
entJobworkOrder.CustomerID = Convert.ToInt32(objSDR["CustomerID"]);
}
if (!objSDR["ProductID"].Equals(DBNull.Value))
{
entJobworkOrder.ProductID = Convert.ToInt32(objSDR["ProductID"]);
}
if (!objSDR["Gross"].Equals(DBNull.Value))
{
entJobworkOrder.Gross = Convert.ToInt32(objSDR["Gross"]);
}
if (!objSDR["Rate"].Equals(DBNull.Value))
{
entJobworkOrder.Rate = Convert.ToInt32(objSDR["Rate"]);
}
if (!objSDR["IssueDate"].Equals(DBNull.Value))
{
entJobworkOrder.IssueDate = Convert.ToDateTime(objSDR["IssueDate"]);
}
if (!objSDR["ReturnDate"].Equals(DBNull.Value))
{
entJobworkOrder.ReturnDate = Convert.ToDateTime(objSDR["ReturnDate"]);
}
}
}
return(entJobworkOrder);
#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();
}
}
}
}
}
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
}
