protected void GetMsData(object sender, EventArgs e)
{
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
string MsWbSlipNo = DropDownMsWbSlipNo.Text;
string makeSQL = " select ITEM_ID, WB_SLIP_NO, FIRST_WT, SECOND_WT, ITEM_WEIGHT from MS_SALES_INTER_DIV_MASTER where WB_SLIP_NO = '" + MsWbSlipNo + "'";
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++)
{
DropDownItemID.Text = dt.Rows[i]["ITEM_ID"].ToString();
Text1stWeightMs.Text = dt.Rows[i]["FIRST_WT"].ToString();
Text2ndWeightMs.Text = dt.Rows[i]["SECOND_WT"].ToString();
TextMatWeightMs.Text = dt.Rows[i]["ITEM_WEIGHT"].ToString();
}
TextMfWbSlipNo.Focus();
conn.Close();
CheckSlipNo.Text = "";
alert_box.Visible = false;
}
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 SlipNo = Convert.ToInt32(TextMfWbSlipNo.Text);
int VehicleID = Convert.ToInt32(DropDownVehicleID.Text);
int ItemID = Convert.ToInt32(DropDownItemID.Text);
int ItemBinID = Convert.ToInt32(Request.Form[DropDownItemBinID.UniqueID]);
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 Mat1stWeightMf = Convert.ToDouble(TextMat1stWeightMf.Text.Trim());
double Mat2ndWeightMf = Convert.ToDouble(TextMat2ndWeightMf.Text.Trim());
double MatWeightMf = Convert.ToDouble(TextMatWeightMf.Text.Trim());
double MatWeightMs = Convert.ToDouble(TextMatWeightMs.Text.Trim());
double WeightVariance = 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[15];
objPrm[0] = cmdi.Parameters.Add("NoSlipID", SlipNo);
objPrm[1] = cmdi.Parameters.Add("NoVehicleID", VehicleID);
objPrm[2] = cmdi.Parameters.Add("NoItemID", ItemID);
objPrm[3] = cmdi.Parameters.Add("NoItemBinID", ItemBinID);
objPrm[4] = cmdi.Parameters.Add("NoMat1stWeightMf", Mat1stWeightMf);
objPrm[5] = cmdi.Parameters.Add("NoMat2ndWeightMf", Mat2ndWeightMf);
objPrm[6] = cmdi.Parameters.Add("NoMatWeightMf", MatWeightMf);
objPrm[7] = cmdi.Parameters.Add("NoMatWeightMs", MatWeightMs);
objPrm[8] = cmdi.Parameters.Add("NoWeightVariance", WeightVariance);
objPrm[9] = cmdi.Parameters.Add("EntryDate", EntryDateNew);
objPrm[10] = cmdi.Parameters.Add("TextRemarks", TextRemarks.Text);
objPrm[11] = cmdi.Parameters.Add("u_date", u_date);
objPrm[12] = cmdi.Parameters.Add("NoCuserID", userID);
objPrm[13] = cmdi.Parameters.Add("TextIsActive", ISActive);
objPrm[14] = 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();
TextMfWbSlipNo.Focus();
Display();
DisplaySummary();
PendingReceiving();
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
}
catch
{
Response.Redirect("~/ParameterError.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(TextMfWbSlipNo.Text);
int ItemID = Convert.ToInt32(DropDownItemID.Text);
int ItemBinID = Convert.ToInt32(Request.Form[DropDownItemBinID.UniqueID]);
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 Mat1stWeightMf = Convert.ToDouble(TextMat1stWeightMf.Text.Trim());
double Mat2ndWeightMf = Convert.ToDouble(TextMat2ndWeightMf.Text.Trim());
double MatWeightMf = Convert.ToDouble(TextMatWeightMf.Text.Trim());
double MatWeightMs = Convert.ToDouble(TextMatWeightMs.Text.Trim());
double WeightVariance = MatWeightMf - MatWeightMs;
string get_transfer_id = "select MF_PURCHASE_TRANS_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_PURCHASE_TRANSFER_MASTER (TRANSFER_ID, WB_SLIP_NO, VEHICLE_ID, ITEM_ID, ITEM_BIN_ID, FIRST_WT_MF, SECOND_WT_MF, NET_WT_MF, NET_WT_MS, VARIANCE, REMARKS, WB_SLIP_NO_MS, ENTRY_DATE, CREATE_DATE, C_USER_ID, IS_ACTIVE, DIVISION_ID) values ( :NoTransferID, :NoSlipID, :NoVehicleID, :NoItemID, :NoItemBinID, :TextMat1stWeightMf, :TextMat2ndWeightMf, :TextMatWeightMf, :TextMatWeightMs, :TextWeightVariance, :TextRemarks, :TextMsWbSlipNo, 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[16];
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("NoItemID", ItemID);
objPrm[4] = cmdi.Parameters.Add("NoItemBinID", ItemBinID);
objPrm[5] = cmdi.Parameters.Add("TextMat1stWeightMf", Mat1stWeightMf);
objPrm[6] = cmdi.Parameters.Add("TextMat2ndWeightMf", Mat2ndWeightMf);
objPrm[7] = cmdi.Parameters.Add("TextMatWeightMf", MatWeightMf);
objPrm[8] = cmdi.Parameters.Add("TextMatWeightMs", MatWeightMs);
objPrm[9] = cmdi.Parameters.Add("TextWeightVariance", WeightVariance);
objPrm[10] = cmdi.Parameters.Add("EntryDate", EntryDateNew);
objPrm[11] = cmdi.Parameters.Add("TextRemarks", TextRemarks.Text);
objPrm[12] = cmdi.Parameters.Add("TextMsWbSlipNo", DropDownMsWbSlipNo.Text);
objPrm[13] = cmdi.Parameters.Add("c_date", c_date);
objPrm[14] = cmdi.Parameters.Add("NoCuserID", userID);
objPrm[15] = cmdi.Parameters.Add("TextIsActive", ISActive);
cmdi.ExecuteNonQuery();
cmdi.Parameters.Clear();
cmdi.Dispose();
string update_user = "******";
cmdi = new OracleCommand(update_user, conn);
OracleParameter[] objPr = new OracleParameter[4];
objPr[0] = cmdi.Parameters.Add("IsReceived", "Received");
objPr[1] = cmdi.Parameters.Add("c_date", c_date);
objPr[2] = cmdi.Parameters.Add("NoCuserID", userID);
objPr[3] = cmdi.Parameters.Add("TextMsWbSlipNo", DropDownMsWbSlipNo.Text);
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();
TextMfWbSlipNo.Focus();
Display();
DisplaySummary();
PendingReceiving();
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
// }
// catch
// {
// Response.Redirect("~/ParameterError.aspx");
// }
}
