protected void btnSave_Click(object sender, EventArgs e)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
if (ddlracknumber.SelectedValue == "0" || ddlracknumber.SelectedItem.Text == "--Select--")
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Please Select Rack Number ....'); </script> ");
return;
}
if (ddlIssuecenter.SelectedValue == "0" || ddlIssuecenter.SelectedItem.Text == "--Select--")
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Please Select Issue Center ....'); </script> ");
return;
}
if (txtRecdQty.Text == "")
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Please Enter Receiving Quantity ....'); </script> ");
return;
}
if (txtRecdBags.Text == "")
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Please Enter Receiving Bags ....'); </script> ");
return;
}
if (DaintyDate1.Text == "")
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Please Enter Receiving Date ....'); </script> ");
return;
}
if (ddlchallan.SelectedValue == "0" || ddlchallan.SelectedItem.Text == "--Select--")
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Please Select Challan Number ....'); </script> ");
return;
}
double sendqty = Convert.ToDouble(txtsendQty.Text);
Int32 sendbags = Convert.ToInt32(txtsendbags.Text);
Int32 recdbags = Convert.ToInt32(txtRecdBags.Text);
double recdQty = Convert.ToDouble(txtRecdQty.Text);
if (recdQty > sendqty || recdbags > sendbags)
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Received Bags or Quantity will not more than Sending Bags or Quantity ....'); </script> ");
return;
}
string racknum = ddlracknumber.SelectedItem.Text;
string sendIC = ddlIssuecenter.SelectedValue;
string challan = ddlchallan.SelectedItem.Text;
string std = getDate_MDY(DaintyDate1.Text);
//DateTime std = DateTime.Parse(getDate_MDY(DaintyDate1.Text));
string ip = Request.ServerVariables["REMOTE_ADDR"].ToString();
string opid = Session["OperatorIDDM"].ToString();
GetFirstfour = result = "";
length = 0;
GetFirstfour = ddlchallan.SelectedItem.ToString();
length = GetFirstfour.Length;
if (length > 4)
{
result = GetFirstfour.Substring(0, 4);
}
if (result == "MORK")
{
string Update = "";
distid = Session["dist_id"].ToString();
try
{
Update = "BEGIN TRY; SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED BEGIN TRANSACTION " +
"Update DeliveryChallan_MO Set IsReceived='Y',RSDRecd_Qty='" + txtRecdQty.Text + "',RSDRecd_Bags='" + txtRecdBags.Text + "',RSDRecd_Date='" + std + "',RSDCreatedDate=GETDATE() where FrmDist='" + distid + "' and DC_MO='" + ddlchallan.SelectedItem.ToString() + "' and Rack_No='" + ddlracknumber.SelectedItem.ToString() + "' and CropYear='" + lblcropyear.Text + "' and Issued_Date='" + hdfChallanDate.Value + "';";
Update += "Insert into QtyReceived_RackDispatchPoint (Racknumber ,sendingDist ,sendingIssueCenter ,TruckChallan ,CropYear ,sendBags ,SendQty ,RecdBags ,RecdQty ,RecdDate ,IP_Address ,Created_date ,OperatorID,Commodity,RecDist,IsReceived) values('" + racknum + "','" + distid + "','" + sendIC + "','" + challan + "','" + lblcropyear.Text + "','" + txtsendbags.Text + "','" + txtsendQty.Text + "','" + txtRecdBags.Text + "','" + txtRecdQty.Text + "','" + std + "','" + ip + "',getdate(),'" + opid + "','" + hdfComdty.Value + "','" + hdfRecDist.Value + "','N');";
Update += "COMMIT end TRY BEGIN CATCH IF @@TRANCOUNT > 0 ROLLBACK;DECLARE @ErrorMessage NVARCHAR(4000);DECLARE @ErrorSeverity INT;DECLARE @ErrorState INT;SELECT @ErrorMessage = ERROR_MESSAGE(), @ErrorSeverity = ERROR_SEVERITY(), @ErrorState = ERROR_STATE(); RAISERROR (@ErrorMessage, @ErrorSeverity,@ErrorState ); END CATCH;";
cmd = new SqlCommand(Update, con);
int count = cmd.ExecuteNonQuery();
if (count > 0)
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Data Saved Sucessfully ....'); </script> ");
DaintyDate1.Text = "";
txtRecdQty.Text = "";
txtRecdBags.Text = "";
btnSave.Enabled = false;
}
else
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Data Not Save For Movement Order'); </script> ");
}
}
catch
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Data Not Save For Movement Order'); </script> ");
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
else
{
string insquy = "Insert into QtyReceived_RackDispatchPoint (Racknumber ,sendingDist ,sendingIssueCenter ,TruckChallan ,CropYear ,sendBags ,SendQty ,RecdBags ,RecdQty ,RecdDate ,IP_Address ,Created_date ,OperatorID) values('" + racknum + "','" + distid + "','" + sendIC + "','" + challan + "','" + lblcropyear.Text + "','" + txtsendbags.Text + "','" + txtsendQty.Text + "','" + txtRecdBags.Text + "','" + txtRecdQty.Text + "','" + std + "','" + ip + "',getdate(),'" + opid + "')";
SqlCommand cmdins = new SqlCommand(insquy, con);
try
{
int x = cmdins.ExecuteNonQuery();
if (x == 0)
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Not Saved, Might be Some Error ....'); </script> ");
}
else
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Data Saved Sucessfully ....'); </script> ");
DaintyDate1.Text = "";
txtRecdQty.Text = "";
txtRecdBags.Text = "";
btnSave.Enabled = false;
}
}
catch
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Not Saved, Might be Some Error ....'); </script> ");
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
if (ddlrackno.SelectedValue == "0" || ddlrackno.SelectedItem.Text == "--Select--")
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Select Rack Number....'); </script> ");
return;
}
if (ddlcommodity.SelectedValue == "0" || ddlcommodity.SelectedItem.Text == "--Select--")
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Select Commodity Type....'); </script> ");
return;
}
if (ddlgodown.SelectedValue == "0" || ddlgodown.SelectedItem.Text == "--Select--")
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Select Godown Name....'); </script> ");
return;
}
if (ddlcropyear.SelectedItem.Text == "--Select--")
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Select Crop Year..'); </script> ");
return;
}
if (txtbagno.Text == "0" || txtbagno.Text == "")
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Bags Should not be 0 or Blank..'); </script> ");
return;
}
if (txtquant.Text == "0" || txtquant.Text == "")
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Quantity Should not be 0 or Blank..'); </script> ");
return;
}
if (txttruckno.Text == "")
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Please Enter Truck Number..'); </script> ");
return;
}
//if (txttrukchlnno.Text == "")
//{
// Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Please Enter Challan Number.'); </script> ");
// return;
//}
if (DaintyDate1.Text == "")
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Please Select Receiving Date.'); </script> ");
return;
}
if (ddlChallanNo.Visible == true)
{
if (ddlChallanNo.SelectedValue == "0" || ddlChallanNo.SelectedItem.Text == "--Select--")
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Please Select Challan Number'); </script> ");
return;
}
else
{
txttrukchlnno.Text = ddlChallanNo.SelectedItem.ToString();
}
}
else
{
if (txttrukchlnno.Text == "")
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Please Enter Challan Number.'); </script> ");
return;
}
}
string duplichallan = "Select DC_MO from Return_from_Rack where DC_MO = '" + txttrukchlnno.Text.Trim() + "' and Issue_Center = '" + issueid + "' and FrmDist = '" + distid + "' ";
SqlCommand cmdchallan = new SqlCommand(duplichallan, con);
SqlDataReader drchallan;
drchallan = cmdchallan.ExecuteReader();
if (drchallan.Read())
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Duplicate Challan Number Not Accepted..'); </script> ");
drchallan.Close();
return;
}
drchallan.Close();
string challannum = txttrukchlnno.Text.Trim();
string Racknum = ddlrackno.SelectedItem.Text;
string commodity = ddlcommodity.SelectedValue;
string scheme = ddlscheme.SelectedValue;
string GodownName = ddlgodown.SelectedValue;
string cropyear = ddlcropyear.SelectedItem.Text;
string Quantity = txtquant.Text.Trim();
string Bags = txtbagno.Text.Trim();
string TruckNumber = txttruckno.Text.Trim();
string Recevingdate = getDate_MDY(DaintyDate1.Text);
string IPadd = Request.ServerVariables["REMOTE_ADDR"].ToString();
string opid = Session["OperatorId"].ToString();
string InseQry = "";
if (ddlChallanNo.Visible == true)
{
GetFirstfour = result = "";
length = 0;
GetFirstfour = ddlChallanNo.SelectedItem.ToString();
length = GetFirstfour.Length;
if (length > 4)
{
result = GetFirstfour.Substring(0, 4);
}
if (result == "MORK")
{
InseQry = "BEGIN TRY; SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED BEGIN TRANSACTION " +
"Update DeliveryChallan_MO Set RRDRecd_Qty='" + Quantity + "',RRDRecd_Bags='" + Bags + "',RRDRecd_Date='" + Recevingdate + "',RRDCreated=GETDATE() where Rack_No='" + ddlrackno.SelectedItem.ToString() + "' and DC_MO='" + ddlChallanNo.SelectedItem.ToString() + "' and FrmDist='" + distid + "' and STO_No='" + hdfSTO_No.Value + "';";
InseQry += "Insert into Return_From_Rack (DC_MO,Rack_No,STO_No,FrmDist,Commodity,CropYear,Scheme,Issue_Center,Godown,Quantity,Bags,Truck_No,Recd_Date,CreatedDate,IP,OperatorID,Remark) Values ('" + challannum + "','" + Racknum + "','" + hdfSTO_No.Value + "','" + distid + "','" + commodity + "','" + cropyear + "','" + scheme + "','" + issueid + "','" + GodownName + "','" + Quantity + "','" + Bags + "','" + TruckNumber + "','" + Recevingdate + "',GETDATE(),'" + IPadd + "','" + opid + "','" + txtremark.Text + "');";
InseQry += "COMMIT end TRY BEGIN CATCH IF @@TRANCOUNT > 0 ROLLBACK;DECLARE @ErrorMessage NVARCHAR(4000);DECLARE @ErrorSeverity INT;DECLARE @ErrorState INT;SELECT @ErrorMessage = ERROR_MESSAGE(), @ErrorSeverity = ERROR_SEVERITY(), @ErrorState = ERROR_STATE(); RAISERROR (@ErrorMessage, @ErrorSeverity,@ErrorState ); END CATCH;";
}
}
else
{
InseQry += "Insert into Return_From_Rack (DC_MO,Rack_No,STO_No,FrmDist,Commodity,CropYear,Scheme,Issue_Center,Godown,Quantity,Bags,Truck_No,Recd_Date,CreatedDate,IP,OperatorID,Remark) Values ('" + challannum + "','" + Racknum + "','" + hdfSTO_No.Value + "','" + distid + "','" + commodity + "','" + cropyear + "','" + scheme + "','" + issueid + "','" + GodownName + "','" + Quantity + "','" + Bags + "','" + TruckNumber + "','" + Recevingdate + "',GETDATE(),'" + IPadd + "','" + opid + "','" + txtremark.Text + "');";
//InseQry = "Insert into Return_From_Rack (DistrictId,IssueCenter ,Challan_No,RackNumber ,Commodity ,Scheme ,GodownName ,CropYear ,Quantity,Bags ,TruckNumber ,ReceivingDate ,IPaddress ,UserId ,CreatedDate) Values ('" + distid + "','" + issueid + "','" + challannum + "','" + Racknum + "','" + commodity + "','" + scheme + "','" + GodownName + "','" + cropyear + "','" + Quantity + "','" + Bags + "','" + TruckNumber + "','" + Recevingdate + "','" + IPadd + "','" + opid + "',getdate())";
}
SqlCommand cmdins = new SqlCommand(InseQry, con);
try
{
int x = cmdins.ExecuteNonQuery();
if (x > 0)
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Data Saved.'); </script> ");
btnsubmit.Enabled = false;
}
else
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Problem Occured.'); </script> ");
return;
}
}
catch (Exception ex)
{
Label11.Text = ex.ToString();
}
}