public void TextWbSlipNo_TextChanged(object sender, EventArgs e)
{
string SlipNo = TextWbSlipNo.Text;
string MatchEmpIDPattern = "^([0-9]{6})$";
if (SlipNo != null)
{
if (Regex.IsMatch(SlipNo, MatchEmpIDPattern))
{
alert_box.Visible = false;
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "select WB_SLIP_NO from MF_MATERIAL_TRANSFER_MASTER where WB_SLIP_NO = '" + Convert.ToInt32(SlipNo) + "'";
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
CheckSlipNo.Text = "<label class='control-label'><i class='fa fa-times-circle-o'></i> Slip Number is not available</label>";
CheckSlipNo.ForeColor = System.Drawing.Color.Red;
TextWbSlipNo.Focus();
BtnAdd.Attributes.Add("aria-disabled", "false");
BtnAdd.Attributes.Add("class", "btn btn-primary disabled");
}
else
{
CheckSlipNo.Text = "<label class='control-label'><i class='fa fa fa-check'></i> Slip Number is available</label>";
CheckSlipNo.ForeColor = System.Drawing.Color.Green;
BtnAdd.Attributes.Add("aria-disabled", "true");
BtnAdd.Attributes.Add("class", "btn btn-primary active");
}
}
else
{
CheckSlipNo.Text = "<label class='control-label'><i class='fa fa-hand-o-left'></i> Enter Slip Number is 6 digit only</label>";
CheckSlipNo.ForeColor = System.Drawing.Color.Red;
TextWbSlipNo.Focus();
BtnAdd.Attributes.Add("aria-disabled", "false");
BtnAdd.Attributes.Add("class", "btn btn-primary disabled");
}
}
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
try
{
if (IS_EDIT_ACTIVE == "Enable")
{
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
int userID = Convert.ToInt32(Session["USER_ID"]);
int TransferID = Convert.ToInt32(TextTransferID.Text);
int VehicleID = Convert.ToInt32(DropDownVehicleID.Text);
int MaterialID = Convert.ToInt32(DropDownMaterialID.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");
double MatWeightMf = Convert.ToDouble(TextMatWeightMf.Text.Trim());
double MatWeightMs = Convert.ToDouble(TextMatWeightMs.Text.Trim());
double WeightDifference = MatWeightMf - MatWeightMs;
string u_date = System.DateTime.Now.ToString("dd-MM-yyyy h:mm:ss tt");
// Transfer master update
string update_user = "******";
cmdi = new OracleCommand(update_user, conn);
OracleParameter[] objPrm = new OracleParameter[12];
objPrm[0] = cmdi.Parameters.Add("NoSlipID", TextWbSlipNo.Text);
objPrm[1] = cmdi.Parameters.Add("NoVehicleID", VehicleID);
objPrm[2] = cmdi.Parameters.Add("NoMaterialID", MaterialID);
objPrm[3] = cmdi.Parameters.Add("NoMatWeightMf", MatWeightMf);
objPrm[4] = cmdi.Parameters.Add("NoMatWeightMs", MatWeightMs);
objPrm[5] = cmdi.Parameters.Add("NoWeightDifference", WeightDifference);
objPrm[6] = cmdi.Parameters.Add("TextRemarks", TextRemarks.Text);
objPrm[7] = cmdi.Parameters.Add("EntryDate", EntryDateNew);
objPrm[8] = cmdi.Parameters.Add("u_date", u_date);
objPrm[9] = cmdi.Parameters.Add("NoCuserID", userID);
objPrm[10] = cmdi.Parameters.Add("TextIsActive", ISActive);
objPrm[11] = cmdi.Parameters.Add("NoTransferID", TransferID);
cmdi.ExecuteNonQuery();
cmdi.Parameters.Clear();
cmdi.Dispose();
conn.Close();
alert_box.Visible = true;
alert_box.Controls.Add(new LiteralControl("Transfer Data Update successfully"));
alert_box.Attributes.Add("class", "alert alert-success alert-dismissible");
clearText();
TextWbSlipNo.Focus();
Display();
DisplaySummary();
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
}
catch
{
Response.Redirect("~/ParameterError.aspx");
}
}
// public virtual void Select(bool directed, bool forward){}
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 dtID = new DataTable();
DataSet ds = new DataSet();
string makeVehicleSQL = " SELECT * FROM MF_VEHICLE WHERE IS_ACTIVE = 'Enable' ORDER BY VEHICLE_NO ASC";
ds = ExecuteBySqlString(makeVehicleSQL);
dtID = (DataTable)ds.Tables[0];
DropDownVehicleID.DataSource = dtID;
DropDownVehicleID.DataValueField = "VEHICLE_ID";
DropDownVehicleID.DataTextField = "VEHICLE_NO";
DropDownVehicleID.DataBind();
DropDownVehicleID.Items.Insert(0, new ListItem("Select Vehicle Number ", "0"));
DataTable dtMaterialID = new DataTable();
DataSet dsi = new DataSet();
string makeMaterialSQL = " SELECT MATERIAL_ID, MATERIAL_NAME || ' - ' || MATERIAL_CODE AS MATERIAL_FULL_NAME FROM MF_MATERIAL WHERE IS_ACTIVE = 'Enable' ORDER BY MATERIAL_ID ASC";
dsi = ExecuteBySqlString(makeMaterialSQL);
dtMaterialID = (DataTable)dsi.Tables[0];
DropDownMaterialID.DataSource = dtMaterialID;
DropDownMaterialID.DataValueField = "MATERIAL_ID";
DropDownMaterialID.DataTextField = "MATERIAL_FULL_NAME";
DropDownMaterialID.DataBind();
DropDownMaterialID.Items.Insert(0, new ListItem("Select Material", "0"));
DropDownMaterialID1.DataSource = dtMaterialID;
DropDownMaterialID1.DataValueField = "MATERIAL_ID";
DropDownMaterialID1.DataTextField = "MATERIAL_FULL_NAME";
DropDownMaterialID1.DataBind();
DropDownMaterialID1.Items.Insert(0, new ListItem("Select Material", "0"));
// TextWbSlipNo.Focus();
// Page.SetFocus(TextWbSlipNo);
// TextWbSlipNo.Select();
// this.ActiveControl = TextWbSlipNo;
TextWbSlipNo.Focus();
TextWbSlipNo.Attributes.Add("onfocus", "this.select(); this.onfocus = null;");
// TextWbSlipNo.Attributes.Add("onfocus", "selectText();");
Display();
DisplaySummary();
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 VehicleID = Convert.ToInt32(DropDownVehicleID.Text);
int SlipNo = Convert.ToInt32(TextWbSlipNo.Text);
int MaterialID = Convert.ToInt32(DropDownMaterialID.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");
double MatWeightMf = Convert.ToDouble(TextMatWeightMf.Text.Trim());
double MatWeightMs = Convert.ToDouble(TextMatWeightMs.Text.Trim());
double WeightDifference = MatWeightMf - MatWeightMs;
string get_transfer_id = "select MF_MAT_TRANSFER_MASTERID_SEQ.nextval from dual";
cmdsp = new OracleCommand(get_transfer_id, conn);
int newTransferID = Int16.Parse(cmdsp.ExecuteScalar().ToString());
string insert_Transfer = "insert into MF_MATERIAL_TRANSFER_MASTER (TRANSFER_ID, WB_SLIP_NO, VEHICLE_ID, MATERIAL_ID, WT_AS_PER_MF, WT_AS_PER_MS, DIFFERENCE, REMARKS, ENTRY_DATE, CREATE_DATE, C_USER_ID, IS_ACTIVE, DIVISION_ID) values ( :NoTransferID, :NoSlipID, :NoVehicleID, :NoMaterialID, :TextMatWeightMf, :TextMatWeightMs, :TextWeightDifference, :TextRemarks, TO_DATE(:EntryDate, 'DD/MM/YYYY'), TO_DATE(:c_date, 'DD-MM-YYYY HH:MI:SS AM'), :NoCuserID, :TextIsActive, 5)";
cmdi = new OracleCommand(insert_Transfer, conn);
OracleParameter[] objPrm = new OracleParameter[12];
objPrm[0] = cmdi.Parameters.Add("NoTransferID", newTransferID);
objPrm[1] = cmdi.Parameters.Add("NoSlipID", SlipNo);
objPrm[2] = cmdi.Parameters.Add("NoVehicleID", VehicleID);
objPrm[3] = cmdi.Parameters.Add("NoMaterialID", MaterialID);
objPrm[4] = cmdi.Parameters.Add("TextMatWeightMf", MatWeightMf);
objPrm[5] = cmdi.Parameters.Add("TextMatWeightMs", MatWeightMs);
objPrm[6] = cmdi.Parameters.Add("TextWeightDifference", WeightDifference);
objPrm[7] = cmdi.Parameters.Add("EntryDate", EntryDateNew);
objPrm[8] = cmdi.Parameters.Add("TextRemarks", TextRemarks.Text);
objPrm[9] = cmdi.Parameters.Add("c_date", c_date);
objPrm[10] = cmdi.Parameters.Add("NoCuserID", userID);
objPrm[11] = 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 Transfer Data successfully"));
alert_box.Attributes.Add("class", "alert alert-success alert-dismissible");
clearText();
TextWbSlipNo.Focus();
Display();
DisplaySummary();
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
}
catch
{
Response.Redirect("~/ParameterError.aspx");
}
}
