protected void BtnUpdate_Click(object sender, EventArgs e)
{
if (IS_EDIT_ACTIVE == "Enable")
{
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
int userID = Convert.ToInt32(Session["USER_ID"]);
string Production_ID = TextProductionID.Text;
int ShiftID = Convert.ToInt32(DropDownShiftID.Text);
int SupervisorID = Convert.ToInt32(DropDownSupervisorID.Text);
int MachineID = Convert.ToInt32(DropDownMachineID.Text);
double ItemWeight = Convert.ToDouble(TextItemWeight.Text);
int ItemID = Convert.ToInt32(DropDownItemID.Text);
int SubItemID = Convert.ToInt32(DropDownSubItemID.Text);
string ItemName = DropDownItemID.SelectedItem.Text;
string SubItemName = "";
if (SubItemID == 0)
{
SubItemID = 0; SubItemName = "";
}
else
{
SubItemID = Convert.ToInt32(DropDownSubItemID.Text); SubItemName = DropDownSubItemID.SelectedItem.Text;
}
string ISActive = CheckIsActive.Checked ? "Enable" : "Disable";
string u_date = System.DateTime.Now.ToString("dd-MM-yyyy h:mm:ss tt");
string MakeEntryDate = EntryDate.Text;
string[] MakeEntryDateSplit = MakeEntryDate.Split('-');
String EntryDateTemp = MakeEntryDateSplit[0].Replace("/", "-");
DateTime EntryDateNewD = DateTime.ParseExact(EntryDateTemp, "dd-MM-yyyy", CultureInfo.InvariantCulture);
string EntryDateNew = EntryDateNewD.ToString("dd-MM-yyyy");
// update production jw master
string update_production = "update PF_PRODUCTION_JW set SHIFT_ID = :NoShiftID, MACHINE_ID = :NoMachineID, SUPERVISOR_ID = :NoSupervisorID, ITEM_ID = :NoItemID, SUB_ITEM_ID = :NoSubItemID, ITEM_WEIGHT = :TextItemWeight, ENTRY_DATE = TO_DATE(:TextEntryDate, 'DD-MM-YYYY'), UPDATE_DATE = TO_DATE(:u_date, 'DD-MM-YYYY HH:MI:SS AM'), U_USER_ID = :NoCuserID, IS_ACTIVE = :TextIsActive where PRODUCTION_JW_ID = :NoProductionID ";
cmdu = new OracleCommand(update_production, conn);
OracleParameter[] objPrm = new OracleParameter[11];
objPrm[0] = cmdu.Parameters.Add("NoShiftID", ShiftID);
objPrm[1] = cmdu.Parameters.Add("NoMachineID", MachineID);
objPrm[2] = cmdu.Parameters.Add("NoSupervisorID", SupervisorID);
objPrm[3] = cmdu.Parameters.Add("NoItemID", ItemID);
objPrm[4] = cmdu.Parameters.Add("NoSubItemID", SubItemID);
objPrm[5] = cmdu.Parameters.Add("TextItemWeight", ItemWeight);
objPrm[6] = cmdu.Parameters.Add("TextEntryDate", EntryDateNew);
objPrm[7] = cmdu.Parameters.Add("u_date", u_date);
objPrm[8] = cmdu.Parameters.Add("NoCuserID", userID);
objPrm[9] = cmdu.Parameters.Add("TextIsActive", ISActive);
objPrm[10] = cmdu.Parameters.Add("NoProductionID", Production_ID);
cmdu.ExecuteNonQuery();
cmdu.Parameters.Clear();
cmdu.Dispose();
conn.Close();
alert_box.Visible = true;
alert_box.Controls.Add(new LiteralControl("Job Work (Production) Data Update Successfully"));
alert_box.Attributes.Add("class", "alert alert-success alert-dismissible");
clearText();
DropDownShiftID.Focus();
Display();
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["USER_NAME"] != null)
{
string requestedFile = Path.GetFileName(Request.Path);
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
string makeSQL = " SELECT NUPP.IS_PAGE_ACTIVE, NUPP.IS_ADD_ACTIVE, NUPP.IS_EDIT_ACTIVE, NUPP.IS_DELETE_ACTIVE, NUPP.IS_VIEW_ACTIVE, NUPP.IS_REPORT_ACTIVE FROM NRC_USER_PAGE_PERMISSION NUPP LEFT JOIN NRC_USER_PAGES NUP ON NUP.USER_PAGE_ID = NUPP.USER_PAGE_ID WHERE NUPP.USER_ID = '" + Session["USER_ID"] + "' AND NUP.IS_ACTIVE = 'Enable' AND NUP.PAGE_URL = '" + requestedFile + "' ";
cmdl = new OracleCommand(makeSQL);
oradata = new OracleDataAdapter(cmdl.CommandText, conn);
dt = new DataTable();
oradata.Fill(dt);
RowCount = dt.Rows.Count;
for (int i = 0; i < RowCount; i++)
{
IS_PAGE_ACTIVE = dt.Rows[i]["IS_PAGE_ACTIVE"].ToString();
IS_ADD_ACTIVE = dt.Rows[i]["IS_ADD_ACTIVE"].ToString();
IS_EDIT_ACTIVE = dt.Rows[i]["IS_EDIT_ACTIVE"].ToString();
IS_DELETE_ACTIVE = dt.Rows[i]["IS_DELETE_ACTIVE"].ToString();
IS_VIEW_ACTIVE = dt.Rows[i]["IS_VIEW_ACTIVE"].ToString();
IS_REPORT_ACTIVE = dt.Rows[i]["IS_REPORT_ACTIVE"].ToString();
}
if (IS_PAGE_ACTIVE == "Enable")
{
if (!IsPostBack)
{
DataTable dtShiftID = new DataTable();
DataSet ds = new DataSet();
string makeShiftSQL = " SELECT * FROM PF_PRODUCTION_SHIFT WHERE IS_ACTIVE = 'Enable' ORDER BY SHIFT_NAME ASC";
ds = ExecuteBySqlString(makeShiftSQL);
dtShiftID = (DataTable)ds.Tables[0];
DropDownShiftID.DataSource = dtShiftID;
DropDownShiftID.DataValueField = "SHIFT_ID";
DropDownShiftID.DataTextField = "SHIFT_NAME";
DropDownShiftID.DataBind();
DropDownShiftID.Items.Insert(0, new ListItem("Select Shift", "0"));
DataTable dtMachineID = new DataTable();
DataSet dsl = new DataSet();
string makeMachineSQL = " SELECT * FROM PF_PRODUCTION_MACHINE WHERE IS_ACTIVE = 'Enable' ORDER BY MACHINE_ID ASC";
dsl = ExecuteBySqlString(makeMachineSQL);
dtMachineID = (DataTable)dsl.Tables[0];
DropDownMachineID.DataSource = dtMachineID;
DropDownMachineID.DataValueField = "MACHINE_ID";
DropDownMachineID.DataTextField = "MACHINE_NUMBER";
DropDownMachineID.DataBind();
DropDownMachineID.Items.Insert(0, new ListItem("Select Machine Number", "0"));
DataTable dtSupervisorID = new DataTable();
DataSet dsd = new DataSet();
string makeSupervisorSQL = " SELECT * FROM PF_SUPERVISOR WHERE IS_ACTIVE = 'Enable' ORDER BY SUPERVISOR_NAME ASC";
dsd = ExecuteBySqlString(makeSupervisorSQL);
dtSupervisorID = (DataTable)dsd.Tables[0];
DropDownSupervisorID.DataSource = dtSupervisorID;
DropDownSupervisorID.DataValueField = "SUPERVISOR_ID";
DropDownSupervisorID.DataTextField = "SUPERVISOR_NAME";
DropDownSupervisorID.DataBind();
DropDownSupervisorID.Items.Insert(0, new ListItem("Select Supervisor", "0"));
DataTable dtItemID = new DataTable();
DataSet dsi = new DataSet();
string makeDropDownItemSQL = " SELECT * FROM PF_ITEM WHERE IS_ACTIVE = 'Enable' ORDER BY ITEM_ID ASC";
dsi = ExecuteBySqlString(makeDropDownItemSQL);
dtItemID = (DataTable)dsi.Tables[0];
DropDownItemID.DataSource = dtItemID;
DropDownItemID.DataValueField = "ITEM_ID";
DropDownItemID.DataTextField = "ITEM_NAME";
DropDownItemID.DataBind();
DropDownItemID.Items.Insert(0, new ListItem("Select Item", "0"));
DropDownItemID1.DataSource = dtItemID;
DropDownItemID1.DataValueField = "ITEM_ID";
DropDownItemID1.DataTextField = "ITEM_NAME";
DropDownItemID1.DataBind();
DropDownItemID1.Items.Insert(0, new ListItem("All Item", "0"));
DataTable dtSubItemID = new DataTable();
DataSet dss = new DataSet();
string makeDropDownSubItemSQL = " SELECT * FROM PF_SUB_ITEM WHERE IS_ACTIVE = 'Enable' ORDER BY SUB_ITEM_ID ASC";
dss = ExecuteBySqlString(makeDropDownSubItemSQL);
dtSubItemID = (DataTable)dss.Tables[0];
DropDownSubItemID.DataSource = dtSubItemID;
DropDownSubItemID.DataValueField = "SUB_ITEM_ID";
DropDownSubItemID.DataTextField = "SUB_ITEM_NAME";
DropDownSubItemID.DataBind();
DropDownSubItemID.Items.Insert(0, new ListItem("Select Sub Item", "0"));
Display();
DropDownShiftID.Focus();
alert_box.Visible = false;
}
IsLoad = false;
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
}
else
{
Response.Redirect("~/Default.aspx");
}
}
public void BtnAdd_Click(object sender, EventArgs e)
{
try
{
if (IS_ADD_ACTIVE == "Enable")
{
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
int userID = Convert.ToInt32(Session["USER_ID"]);
int ShiftID = Convert.ToInt32(DropDownShiftID.Text);
int MachineID = Convert.ToInt32(DropDownMachineID.Text);
int SupervisorID = Convert.ToInt32(DropDownSupervisorID.Text);
double ItemWeight = Convert.ToDouble(TextItemWeight.Text);
int ItemID = Convert.ToInt32(DropDownItemID.Text);
int SubItemID = Convert.ToInt32(DropDownSubItemID.Text);
string ItemName = DropDownItemID.SelectedItem.Text;
string SubItemName = "";
if (SubItemID == 0)
{
SubItemID = 0;
SubItemName = "";
}
else
{
SubItemID = Convert.ToInt32(DropDownSubItemID.Text);
SubItemName = DropDownSubItemID.SelectedItem.Text;
}
string ISActive = CheckIsActive.Checked ? "Enable" : "Disable";
string MakeEntryDate = EntryDate.Text;
string[] MakeEntryDateSplit = MakeEntryDate.Split('-');
String EntryDateTemp = MakeEntryDateSplit[0].Replace("/", "-");
DateTime EntryDateNewD = DateTime.ParseExact(EntryDateTemp, "dd-MM-yyyy", CultureInfo.InvariantCulture);
string EntryDateNew = EntryDateNewD.ToString("dd-MM-yyyy");
string c_date = System.DateTime.Now.ToString("dd-MM-yyyy h:mm:ss tt");
string get_user_production_id = "select PF_PRODUCTION_JWID_SEQ.nextval from dual";
cmdu = new OracleCommand(get_user_production_id, conn);
int newProductionID = Int16.Parse(cmdu.ExecuteScalar().ToString());
string insert_production = "insert into PF_PRODUCTION_JW (PRODUCTION_JW_ID, SHIFT_ID, MACHINE_ID, SUPERVISOR_ID, ITEM_ID, SUB_ITEM_ID, ITEM_WEIGHT, ENTRY_DATE, CREATE_DATE, C_USER_ID, IS_ACTIVE, DIVISION_ID ) values ( 'JW' || LPAD(:NoProductionID, 6, '0'), :NoShiftID, :NoMachineID, :NoSupervisorID, :NoItemID, :NoSubItemID, :TextItemWeight, TO_DATE(:EntryDate, 'DD/MM/YYYY'), TO_DATE(:c_date, 'DD-MM-YYYY HH:MI:SS AM'), :NoCuserID, :TextIsActive, 3)";
cmdi = new OracleCommand(insert_production, conn);
OracleParameter[] objPrm = new OracleParameter[11];
objPrm[0] = cmdi.Parameters.Add("NoProductionID", newProductionID);
objPrm[1] = cmdi.Parameters.Add("NoShiftID", ShiftID);
objPrm[2] = cmdi.Parameters.Add("NoMachineID", MachineID);
objPrm[3] = cmdi.Parameters.Add("NoSupervisorID", SupervisorID);
objPrm[4] = cmdi.Parameters.Add("NoItemID", ItemID);
objPrm[5] = cmdi.Parameters.Add("NoSubItemID", SubItemID);
objPrm[6] = cmdi.Parameters.Add("TextItemWeight", ItemWeight);
objPrm[7] = cmdi.Parameters.Add("EntryDate", EntryDateNew);
objPrm[8] = cmdi.Parameters.Add("c_date", c_date);
objPrm[9] = cmdi.Parameters.Add("NoCuserID", userID);
objPrm[10] = cmdi.Parameters.Add("TextIsActive", ISActive);
cmdi.ExecuteNonQuery();
cmdi.Parameters.Clear();
cmdi.Dispose();
conn.Close();
alert_box.Visible = true;
alert_box.Controls.Add(new LiteralControl("Insert New Job Work (Production) Successfully"));
alert_box.Attributes.Add("class", "alert alert-success alert-dismissible");
clearText();
Display();
DropDownShiftID.Focus();
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
}
catch
{
Response.Redirect("~/ParameterError.aspx");
}
}
