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"); } }