protected void Button3_Click(object sender, EventArgs e)
{
string ro_no = rono;
string qrychk = "Select Lifted_Qty,Cumulative_Qty,Pending_Qty from dbo.TO_Allot_Lift where RO_No='" + ro_no + "' and Distt_Id='" + distid + "'";
obj = new LARO(ComObj);
DataSet dschk = obj.selectAny(qrychk);
if (dschk == null)
{
}
else
{
if (dschk.Tables[0].Rows.Count == 0)
{
}
else
{
DataRow drlr = dschk.Tables[0].Rows[0];
txtallotlift.Text = drlr["Lifted_Qty"].ToString();
TextBox1.Text = drlr["Cumulative_Qty"].ToString();
TextBox2.Text = drlr["Pending_Qty"].ToString();
}
}
}
void GetTOTransport()
{
string mrono = ddlrono.SelectedItem.ToString();
string ttid = ddltransport.SelectedValue;
string qryTO = "Select TO_Allot_Lift.Locked,TO_Allot_Lift.RO_NO,TO_Allot_Lift.Transporter_ID,Transporter_Table.Transporter_Name as Transporter_Name from dbo.TO_Allot_Lift left join dbo.Transporter_Table on TO_Allot_Lift.Transporter_ID=Transporter_Table.Transporter_ID where TO_Allot_Lift.Distt_Id='" + distid + "'and TO_Allot_Lift.RO_NO='" + mrono + "'";
obj = new LARO(ComObj);
DataSet dsto = obj.selectAny(qryTO);
if (dsto.Tables[0].Rows.Count == 0)
{
ddltransport.Enabled = true;
ddltransport.BackColor = System.Drawing.Color.White;
GetTransport();
}
else
{
DataRow drchk = dsto.Tables[0].Rows[0];
string Status = drchk["Locked"].ToString();
string mdro = drchk["RO_NO"].ToString();
//ddltransport.SelectedValue = drchk["Transporter_ID"].ToString();
ddltransport.SelectedItem.Text = drchk["Transporter_Name"].ToString();
//ddltransport.Enabled = false;
//ddltransport.BackColor = System.Drawing.Color.Wheat;
}
}
void GetData()
{
obj = new LARO(ComObj);
string qryall = "SELECT Transport_Order_againstRo.Transporter_Name,Transporter_Table.Transporter_Name as Transporter,TO_Allot_Lift.Lifted_Qty,RO_of_FCI.Commodity AS Expr1,Transport_Order_againstRo.Cumulative_Qty as Cumulative_Qty , RO_of_FCI.Distt_Id, RO_of_FCI.RO_No, RO_of_FCI.RO_Validity, RO_of_FCI.RO_date, RO_of_FCI.RO_qty,RO_of_FCI.RO_district, RO_of_FCI.Scheme as Scheme, RO_of_FCI.Rate, RO_of_FCI.Amount, RO_of_FCI.Allot_month,RO_of_FCI.Allot_year, RO_of_FCI.DD_chk_no, RO_of_FCI.DD_chk_date, RO_of_FCI.Remarks, RO_of_FCI.Created_date,RO_of_FCI.updated_date, RO_of_FCI.deleted_date, RO_of_FCI.Balance_Qty,tbl_MetaData_STORAGE_COMMODITY .Commodity_Name as Commodity_Name,tbl_MetaData_SCHEME.Scheme_Name as Scheme_Name From dbo.RO_of_FCI Left JOIN tbl_MetaData_STORAGE_COMMODITY ON RO_of_FCI.Commodity = tbl_MetaData_STORAGE_COMMODITY .Commodity_Id left join Transport_Order_againstRo on RO_of_FCI.RO_No=Transport_Order_againstRo.RO_No left join dbo.tbl_MetaData_SCHEME on RO_of_FCI.Scheme=tbl_MetaData_SCHEME.Scheme_id left join dbo.TO_Allot_Lift on RO_of_FCI.RO_No=TO_Allot_Lift.RO_No left join dbo.Transporter_Table on Transport_Order_againstRo.Transporter_Name=Transporter_Table.Transporter_ID where RO_of_FCI.RO_No='" + txtrono.Text + "' and RO_of_FCI.Distt_Id='" + distid + "'";
DataSet ds = obj.selectAny(qryall);
DataRow dr = ds.Tables[0].Rows[0];
string rdate = dr["RO_Validity"].ToString();
string rodate = getdate(rdate);
txtrodate.Text = rodate;
txtrodate.ReadOnly = true;
txtrodate.BackColor = System.Drawing.Color.Wheat;
lblcomdty.Text = dr["Expr1"].ToString();
lblsch.Text = dr["Scheme"].ToString();
txtcommodity.Text = dr["Commodity_Name"].ToString();
txtcommodity.ReadOnly = true;
txtcommodity.BackColor = System.Drawing.Color.Wheat;
txtscheme.Text = dr["Scheme_Name"].ToString();
txtscheme.ReadOnly = true;
txtscheme.BackColor = System.Drawing.Color.Wheat;
txtroqty.Text = dr["RO_qty"].ToString();
txtroqty.ReadOnly = true;
txtroqty.BackColor = System.Drawing.Color.Wheat;
//ddltransport.SelectedItem.Text = dr["Transporter"].ToString();
ddltransport.SelectedValue = dr["Transporter_Name"].ToString();
//ddltransport.Enabled = false;
ddltransport.BackColor = System.Drawing.Color.Wheat;
//txtrobalance.Text = dr["Balance_Qty"].ToString();
GetROBAlance();
}
void GetDataLARO()
{
obj = new LARO(ComObj);
string qryall = "SELECT Lift_A_RO.Commodity AS Expr1, Lift_A_RO.Distt_Id,Lift_A_RO.RO_Validity, Lift_A_RO.RO_No, Lift_A_RO.RO_date, Lift_A_RO.RO_qty,Lift_A_RO.RO_district, Lift_A_RO.Scheme as Scheme, Lift_A_RO.Rate, Lift_A_RO.Amount, Lift_A_RO.Allot_month,Lift_A_RO.Allot_year, Lift_A_RO.DD_chk_no, Lift_A_RO.DD_chk_date, Lift_A_RO.Remarks, Lift_A_RO.Created_date,Lift_A_RO.updated_date, Lift_A_RO.deleted_date, Lift_A_RO.Balance_Qty,dbo.tbl_MetaData_STORAGE_COMMODITY .Commodity_Name as Commodity_Name From dbo.Lift_A_RO Left JOIN dbo.tbl_MetaData_STORAGE_COMMODITY ON Lift_A_RO.Commodity = dbo.tbl_MetaData_STORAGE_COMMODITY .Commodity_Id where Lift_A_RO.RO_No='" + Ro_No + "' and Lift_A_RO.Distt_Id='" + distid + "'";
DataSet ds = obj.selectAny(qryall);
DataRow dr = ds.Tables[0].Rows[0];
}
void GetFCIdist()
{
obj = new LARO(ComObj);
string qry = "select districtsmp.district_name as dist_name,DepoCode.district_code as dist_code From dbo.DepoCode left join pds.districtsmp on upper(DepoCode.district)=upper( districtsmp.district_name) group by districtsmp.district_name, DepoCode.district_code";
DataSet ds = obj.selectAny(qry);
ddlfcidist.DataSource = ds.Tables[0];
ddlfcidist.DataTextField = "dist_name";
ddlfcidist.DataValueField = "dist_code";
ddlfcidist.DataBind();
ddlfcidist.Items.Insert(0, "--Select--");
}
void GetGunny()
{
obj = new LARO(ComObj);
string qry = "SELECT * FROM dbo.tbl_MetaData_GunnyBags_Type";
DataSet ds = obj.selectAny(qry);
ddlgtype.DataSource = ds.Tables[0];
ddlgtype.DataTextField = "Gunny_Bags_Type";
ddlgtype.DataValueField = "Gunny_Bags_Type_Id";
ddlgtype.DataBind();
ddlgtype.Items.Insert(0, "--Select--");
}
void GetFCIdepot()
{
string dtype = ddldepottype.SelectedItem.ToString();
string dcode = ddlfcidist.SelectedValue;
obj = new LARO(ComObj);
string qry = "select distinct(DepoName) as depo_name ,DepoCode as depo_code,type From dbo.DepoCode where district_code='" + dcode + "'";
DataSet ds = obj.selectAny(qry);
ddlfcidepo.DataSource = ds.Tables[0];
ddlfcidepo.DataTextField = "depo_name";
ddlfcidepo.DataValueField = "depo_code";
ddlfcidepo.DataBind();
ddlfcidepo.Items.Insert(0, "--Select--");
}
void GetData()
{
string distid = ddldistrictmp.SelectedValue;
if (ddlrono.SelectedItem.Text != "--Select--")
{
obj = new LARO(ComObj);
string qryall = "SELECT RO_of_FCI.Commodity , RO_of_FCI.Distt_Id,RO_of_FCI.RO_Validity, RO_of_FCI.RO_No, RO_of_FCI.RO_date, RO_of_FCI.RO_qty,RO_of_FCI.RO_district, RO_of_FCI.Scheme as Scheme, RO_of_FCI.Rate, RO_of_FCI.Amount, RO_of_FCI.Allot_month,RO_of_FCI.Allot_year, RO_of_FCI.DD_chk_no, RO_of_FCI.DD_chk_date, RO_of_FCI.Remarks, RO_of_FCI.Created_date,RO_of_FCI.updated_date, RO_of_FCI.deleted_date, RO_of_FCI.Balance_Qty,dbo.tbl_MetaData_STORAGE_COMMODITY .Commodity_Name as Commodity_Name,dbo.tbl_MetaData_SCHEME.Scheme_Name as Scheme_Name From dbo.RO_of_FCI Left JOIN dbo.tbl_MetaData_STORAGE_COMMODITY ON RO_of_FCI.Commodity = dbo.tbl_MetaData_STORAGE_COMMODITY .Commodity_Id left join dbo.tbl_MetaData_SCHEME on RO_of_FCI.Scheme=dbo.tbl_MetaData_SCHEME.Scheme_id where RO_of_FCI.RO_No='" + ddlrono.SelectedItem + "' and RO_of_FCI.Distt_Id='" + distid + "'";
DataSet ds = obj.selectAny(qryall);
DataRow dr = ds.Tables[0].Rows[0];
string rdate = dr["RO_date"].ToString();
string rodate = getdate(rdate);
txtrodate.Text = rodate;
txtrodate.ReadOnly = true;
txtrodate.BackColor = System.Drawing.Color.Wheat;
roqty = dr["RO_qty"].ToString();
txtroqty.Text = System.Math.Round(CheckNull(dr["RO_qty"].ToString()), 5).ToString();
txtroqty.ReadOnly = true;
txtcomdty.Text = dr["Commodity_Name"].ToString();
txtcomdty.ReadOnly = true;
txtcomdty.BackColor = System.Drawing.Color.Wheat;
txtscheme.Text = dr["Scheme_Name"].ToString();
lblscheme.Text = dr["Scheme"].ToString();
lblcomdty.Text = dr["Commodity"].ToString();
txtscheme.ReadOnly = true;
txtscheme.BackColor = System.Drawing.Color.Wheat;
txtbalqty.Text = System.Math.Round(CheckNull(dr["Balance_Qty"].ToString()), 5).ToString();
txtbalqty.ReadOnly = true;
txtbalqty.BackColor = System.Drawing.Color.Wheat;
lblmonth.Text = dr["Allot_month"].ToString();
lblyear.Text = dr["Allot_year"].ToString();
}
else
{
txtrodate.Text = "";
txtroqty.Text = "";
txtcomdty.Text = "";
txtbalqty.Text = "";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
string ro_no = rono;
string qrychk = "Select Sum(Qty_Send) as Lifted from dbo.Lift_A_RO where RO_No='" + ro_no + "' and Dist_Id='" + distid + "'";
obj = new LARO(ComObj);
DataSet dschk = obj.selectAny(qrychk);
if (dschk == null)
{
}
else
{
if (dschk.Tables[0].Rows.Count == 0)
{
}
else
{
DataRow drlr = dschk.Tables[0].Rows[0];
txtgliftqty.Text = drlr["Lifted"].ToString();
}
}
}
void GetROBAlance()
{
string ro_no = rono;
string qrychk = "Select Balance_Qty from dbo.RO_Of_FCI where RO_No='" + ro_no + "' and Distt_Id='" + distid + "'";
obj = new LARO(ComObj);
DataSet dschk = obj.selectAny(qrychk);
if (dschk == null)
{
}
else
{
if (dschk.Tables[0].Rows.Count == 0)
{
}
else
{
DataRow drlr = dschk.Tables[0].Rows[0];
txtrobalance.Text = drlr["Balance_Qty"].ToString();
}
}
}
protected void dgridchallan_SelectedIndexChanged(object sender, EventArgs e)
{
string ro_no = dgridchallan.SelectedRow.Cells[1].Text;
string to_no = dgridchallan.SelectedRow.Cells[2].Text;
int month = int.Parse(DateTime.Today.Month.ToString());
int year = int.Parse(DateTime.Today.Year.ToString());
string qty = dgridchallan.SelectedRow.Cells[4].Text;
string id = dgridchallan.SelectedRow.Cells[8].Text;
decimal mqtys = CheckNull(qty);
string qrychk = "Select * from dbo.Lift_A_RO where RO_No='" + ro_no + "' and Dist_Id='" + distid + "' and TO_Number='" + to_no + "' and Month=" + month + " and Year=" + year;
obj = new LARO(ComObj);
DataSet dschk = obj.selectAny(qrychk);
if (dschk == null)
{
}
else
{
if (dschk.Tables[0].Rows.Count == 0)
{
string qrydlt = "delete from dbo.Transport_Order_againstRo where RO_No='" + ro_no + "' and Distt_Id='" + distid + "' and TO_Number='" + to_no + "' and Month=" + month + " and Year=" + year + "and Trunsuction_Id='" + id + "'";
cmd.CommandText = qrydlt;
try
{
con.Open();
cmd.Connection = con;
cmd.ExecuteNonQuery();
string qrygetb = "Select Cumulative_Qty,Pending_Qty from dbo.TO_Allot_Lift where RO_No='" + ro_no + "' and Distt_Id='" + distid + "' and Month=" + month + " and Year=" + year;
obj = new LARO(ComObj);
DataSet dsbal = obj.selectAny(qrygetb);
if (dsbal == null)
{
}
else
{
if (dsbal.Tables[0].Rows.Count == 0)
{
}
else
{
DataRow drbal = dsbal.Tables[0].Rows[0];
string bal = drbal["Cumulative_Qty"].ToString();
string pbal = drbal["Pending_Qty"].ToString();
decimal uqty = CheckNull(bal) - mqtys;
decimal upqty = CheckNull(pbal) + mqtys;
string updatebal = "Update dbo.TO_Allot_Lift set Cumulative_Qty=" + uqty + ",Pending_Qty=" + upqty + " where RO_No='" + ro_no + "' and Distt_Id='" + distid + "'and Month=" + month + " and Year=" + year;
cmd.CommandText = updatebal;
cmd.ExecuteNonQuery();
Label3.Visible = true;
Label3.Text = "Record Deleted Successfully........";
Label3.ForeColor = System.Drawing.Color.OrangeRed;
fillgrid();
GetData();
}
}
}
catch (Exception ex)
{
Label3.Visible = true;
Label3.Text = ex.Message;
}
finally
{
}
}
else
{
Label3.Visible = true;
Label3.Text = "Sorry You Can't Delete This Transport Order, It has been lifted !";
}
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
string mroto = ddlrono.SelectedValue;
string mtonoRO = txttorderno.Text;
int month = int.Parse(DateTime.Today.Month.ToString());
int year = int.Parse(DateTime.Today.Year.ToString());
//string qryTODR = "Select * from dbo.Transport_Order_againstRo where RO_No='" + mroto + "' and Distt_Id='" + distid + "' and TO_Number='" + mtonoRO + "'";
//obj = new LARO(ComObj);
//DataSet dstoDR = obj.selectAny(qryTODR);
//if (dstoDR.Tables[0].Rows.Count == 0)
//{
if (ddlrono.SelectedItem.Text == "--Select--" || ddltransport.SelectedItem.Text == "--Select--" || ddlfcidepo.SelectedItem.Text == "--Select--")
{
Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('Please Select The RO Number And Transporter Name /FCI Depot'); </script> ");
}
else
{
DateTime fdate = new DateTime();
DateTime tdate = new DateTime();
string fromdate = getmmddyy(txtrodate.Text);
string todate = getDate_MDY(DaintyDate1.Text);
fdate = DateTime.Parse(fromdate.ToString());
//string todate = getDate_MDY(DaintyDate1.Text);
tdate = Convert.ToDateTime(todate);
string validity = get_days(tdate, fdate);
if (int.Parse(validity) < 0)
{
string RO_NO = ddlrono.SelectedValue;
Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('Validity has been expired'); </script> ");
//string qrytoupdate = "Update dbo.TO_Allot_Lift set Locked='N' where RO_No='" + RO_NO + "' and Distt_Id='" + distid + "'";
string qrytoupdate = "Update dbo.RO_of_FCI set IsExpire='Y' where RO_No='" + RO_NO + "'and Distt_Id='" + distid + "'";
cmd.CommandText = qrytoupdate;
cmd.Connection = con;
try
{
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
con.Close();
}
}
else
{
//int bqty = CheckNullInt(txtbalqty.Text);
//int sqty = CheckNullInt(txtsendqty.Text);
//if (sqty > bqty || sqty == 0)
//{
// Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('Sending Qty Should Not Be Greater Than Pending Qty or 0'); </script> ");
//}
//else
//{
string mrono = ddlrono.SelectedItem.ToString();
decimal mroqty = CheckNull(txtroqty.Text);
string mrdate = DateTime.Today.Date.ToString();
string mtono = txttorderno.Text;
string mtodate = getDate_MDY(DaintyDate1.Text);
string mtaname = ddltransport.SelectedValue;
decimal miqty = CheckNull(txtsendqty.Text);
decimal mcumqty = CheckNull(txtcumlqty.Text);
decimal mpqty = CheckNull(txtbalqty.Text);
// string mcdate = getDate_MDY(DateTime.Today.Date.ToString());
string fcidist = ddlfcidist.SelectedValue;
string fcidepo = ddlfcidepo.SelectedValue;
string udate = "";
string ddate = "";
//int balamt = int.Parse((txtbalqty.Text)) - int.Parse((txtsendqty.Text));
//string Balance_Qty = balamt.ToString();
//decimal balqty = CheckNull(Balance_Qty);
decimal cumqty = CheckNull(txtcumlqty.Text);
decimal sendqty = CheckNull(txtsendqty.Text);
decimal tcumqty = cumqty + sendqty;
string mtid = ddltransport.SelectedValue;
string todist = ddldistrict.SelectedValue;
string toissuecenter = ddlissue.SelectedValue;
string lift = "N";
decimal mliftqty = 0;
decimal mpendqty = CheckNull(txtsendqty.Text);
string notrans = "N";
string ip = Request.ServerVariables["REMOTE_ADDR"].ToString();
string opid = Session["OperatorIDDM"].ToString();
string state = Session["State_Id"].ToString();
string tid = "";
if (ddltransport.SelectedItem.Text == "--Select--")
{
Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('Please Select The Transporter..'); </script> ");
}
else
{
//string uquery = "update dbo.RO_of_FCI set Balance_Qty=" + balqty + "where RO_No='" + mrono + "' and Distt_Id='" + distid + "'";
//DataRow drto = dsto.Tables[0].Rows[0];
con.Open();
SqlTransaction trns;
trns = con.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted);
cmd.Transaction = trns;
try
{
dt = (DataTable)Session["dt"];
cmd.Connection = con;
int count = dt.Rows.Count;
if (count > 0)
{
string crdate = DateTime.Today.Date.ToString();
int i = 0;
while (i < count)
{
if (i == 0)
{
mobj = new MoveChallan(ComObj);
string qrey = "select max(Trunsuction_Id) as Trunsuction_Id from dbo.Transport_Order_againstRo where Distt_Id='" + distid + "' and Month=" + month + "";
DataSet ds = mobj.selectAny(qrey);
if (ds == null)
{
}
else
{
DataRow dr = ds.Tables[0].Rows[0];
transuct = dr["Trunsuction_Id"].ToString();
if (transuct == "")
{
transuct = distid + month.ToString() + "0001";
}
else
{
transnum = Convert.ToInt64(transuct);
transnum = transnum + 1;
transuct = transnum.ToString();
}
}
}
else
{
transnum = int.Parse(tid) + 1;
transuct = transnum.ToString();
}
tid = transuct;
disqty = disqty + CheckNull(dt.Rows[i][2].ToString());
decimal balamt = CheckNull(txtbalqty.Text) - CheckNull(disqty.ToString());
string qry = "insert into dbo.Transport_Order_againstRo(State_Id,Distt_Id,RO_No,RO_qty,RO_Validity,TO_Number,TO_Date,Transporter_Name,Commodity_ID,Scheme_ID,FCI_district,FCI_depot,toDistrict,toIssueCenter,Quantity,Cumulative_Qty,Pending_Qty,Month,Year,Trunsuction_Id,IsLifted,Created_date,updated_date,deleted_date,IP_Address,OperatorID,NoTransaction)values('" + state + "','" + distid + "','" + mrono + "'," + mroqty + ",'" + mrdate + "','" + mtono + "','" + mtodate + "','" + mtaname + "','" + lblcomdty.Text + "','" + lblsch.Text + "','" + fcidist + "','" + fcidepo + "','" + dt.Rows[i][5] + "','" + dt.Rows[i][6] + "'," + dt.Rows[i][2] + "," + mliftqty + "," + dt.Rows[i][2] + "," + month + "," + year + ",'" + tid + "','" + lift + "',getdate(),'" + udate + "','" + ddate + "','" + ip + "','" + opid + "','" + notrans + "')";
cmd.CommandText = qry;
cmd.Transaction = trns;
cmd.ExecuteNonQuery();
i = i + 1;
}
}
else
{
}
string mmto = txttorderno.Text;
string qryTO = "Select * from dbo.TO_Allot_Lift where RO_No='" + mrono + "' and Distt_Id='" + distid + "'";
obj = new LARO(ComObj);
DataSet dsto = obj.selectAny(qryTO);
if (dsto.Tables[0].Rows.Count == 0)
{
string locked = "Y";
decimal liftqty = 0;
decimal pqty = CheckNull(txtbalqty.Text) - CheckNull(disqty.ToString());
decimal ttcum = CheckNull(txtcumlqty.Text) + disqty;
string qrytoinsert = "insert into dbo.TO_Allot_Lift(State_Id,Distt_Id,RO_No,RO_qty,RO_Validity,Transporter_ID,Cumulative_Qty,Pending_Qty,Lifted_Qty,Month,Year,Created_date,Locked,IP_Address,OperatorID)values('" + state + "','" + distid + "','" + mrono + "'," + mroqty + ",'" + mrdate + "','" + mtid + "'," + ttcum + "," + pqty + "," + liftqty + "," + month + "," + year + ",getdate(),'" + locked + "','" + ip + "','" + opid + "')";
cmd.CommandText = qrytoinsert;
cmd.Transaction = trns;
cmd.ExecuteNonQuery();
}
else
{
decimal pqty = CheckNull(txtbalqty.Text) - CheckNull(disqty.ToString());
decimal ttcum = CheckNull(txtcumlqty.Text) + disqty;
string qrytoupdate = "Update dbo.TO_Allot_Lift set RO_qty=" + mroqty + ",Cumulative_Qty=" + ttcum + ",Pending_Qty=" + pqty + ",Month=" + month + ",Year=" + year + ",Created_date=getdate() where RO_No='" + mrono + "' and Distt_Id='" + distid + "'";
cmd.CommandText = qrytoupdate;
cmd.Transaction = trns;
cmd.ExecuteNonQuery();
}
trns.Commit();
Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('Data Saved Successfully...'); </script> ");
btnsave.Enabled = false;
fillgrid();
}
catch (Exception ex)
{
trns.Rollback();
Label1.Visible = true;
Label1.Text = ex.Message;
}
finally
{
con.Close();
ComObj.CloseConnection();
}
}
con.Open();
//}
}
}
//}
//else
//{
// Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('Transport Order Number Already Exist ..... '); </script> ");
//}
}
void GetData()
{
if (ddlrono.SelectedItem.Text != "--Select--")
{
obj = new LARO(ComObj);
string qryall = "SELECT TO_Allot_Lift.Lifted_Qty,RO_of_FCI.Commodity AS Expr1,Transport_Order_againstRo.Cumulative_Qty as Cumulative_Qty , RO_of_FCI.Distt_Id, RO_of_FCI.RO_No, RO_of_FCI.RO_Validity, RO_of_FCI.RO_date, RO_of_FCI.RO_qty,RO_of_FCI.RO_district, RO_of_FCI.Scheme as Scheme, RO_of_FCI.Rate, RO_of_FCI.Amount, RO_of_FCI.Allot_month,RO_of_FCI.Allot_year, RO_of_FCI.DD_chk_no, RO_of_FCI.DD_chk_date, RO_of_FCI.Remarks, RO_of_FCI.Created_date,RO_of_FCI.updated_date, RO_of_FCI.deleted_date, RO_of_FCI.Balance_Qty,tbl_MetaData_STORAGE_COMMODITY .Commodity_Name as Commodity_Name,tbl_MetaData_SCHEME.Scheme_Name as Scheme_Name From dbo.RO_of_FCI Left JOIN tbl_MetaData_STORAGE_COMMODITY ON RO_of_FCI.Commodity = tbl_MetaData_STORAGE_COMMODITY .Commodity_Id left join Transport_Order_againstRo on RO_of_FCI.RO_No=Transport_Order_againstRo.RO_No left join dbo.tbl_MetaData_SCHEME on RO_of_FCI.Scheme=tbl_MetaData_SCHEME.Scheme_id left join dbo.TO_Allot_Lift on RO_of_FCI.RO_No=TO_Allot_Lift.RO_No where RO_of_FCI.RO_No='" + ddlrono.SelectedItem + "' and RO_of_FCI.Distt_Id='" + distid + "'";
DataSet ds = obj.selectAny(qryall);
DataRow dr = ds.Tables[0].Rows[0];
string rdate = dr["RO_Validity"].ToString();
string rodate = getdate(rdate);
txtrodate.Text = rodate;
txtrodate.ReadOnly = true;
//txtrodate.BackColor = System.Drawing.Color.Wheat;
lblcomdty.Text = dr["Expr1"].ToString();
lblsch.Text = dr["Scheme"].ToString();
roqty = dr["RO_qty"].ToString();
txtroqty.Text = dr["RO_qty"].ToString();
txtroqty.ReadOnly = true;
// txtroqty.BackColor = System.Drawing.Color.Wheat;
txtbalqty.Text = dr["Balance_Qty"].ToString();
txtbalqty.ReadOnly = true;
// txtbalqty.BackColor = System.Drawing.Color.Wheat;
txtcumlqty.Text = dr["Cumulative_Qty"].ToString();
txtcommodity.Text = dr["Commodity_Name"].ToString();
txtcommodity.ReadOnly = true;
//txtcommodity.BackColor = System.Drawing.Color.Wheat;
txtscheme.Text = dr["Scheme_Name"].ToString();
txtscheme.ReadOnly = true;
//txtscheme.BackColor = System.Drawing.Color.Wheat;
txtliftqty.Text = dr["Lifted_Qty"].ToString();
txtliftqty.ReadOnly = true;
//txtliftqty.BackColor = System.Drawing.Color.Wheat;
//txtbalqty.Text = dr["Pending_Qty"].ToString();
string cumqtyqry = "Select Cumulative_Qty ,Pending_Qty from dbo.TO_Allot_Lift where RO_No='" + ddlrono.SelectedItem + "' and Distt_Id='" + distid + "'";
DataSet dscq = obj.selectAny(cumqtyqry);
if (dscq.Tables[0].Rows.Count == 0)
{
txtcumlqty.Text = "0";
txtcumlqty.ReadOnly = true;
// txtcumlqty.BackColor = System.Drawing.Color.Wheat;
lbltoqty.Text = txtbalqty.Text;
}
else
{
DataRow drcq = dscq.Tables[0].Rows[0];
txtcumlqty.Text = drcq["Cumulative_Qty"].ToString();
txtbalqty.Text = drcq["Pending_Qty"].ToString();
txtcumlqty.ReadOnly = true;
lbltoqty.Text = drcq["Pending_Qty"].ToString();
decimal chkp = CheckNull(drcq["Pending_Qty"].ToString());
if (chkp == 0)
{
lbltoqty.Text = txtbalqty.Text;
}
else
{
lbltoqty.Text = drcq["Pending_Qty"].ToString();
}
//txtcumlqty.BackColor = System.Drawing.Color.Wheat;
}
}
else
{
txtrodate.Text = "";
txtroqty.Text = "";
txtbalqty.Text = "";
txtcumlqty.Text = "";
txtroqty.Text = "";
txtrodate.Text = "";
txtbalqty.Text = "";
txtcommodity.Text = "";
txtscheme.Text = "";
ddlrono.Focus();
}
}
void GetData()
{
obj = new LARO(ComObj);
string qryall = "SELECT RO_of_FCI.Commodity AS Expr1, RO_of_FCI.Distt_Id,RO_of_FCI.RO_Validity, RO_of_FCI.RO_No, RO_of_FCI.RO_date, RO_of_FCI.RO_qty,RO_of_FCI.RO_district, RO_of_FCI.Scheme as Scheme, RO_of_FCI.Rate, RO_of_FCI.Amount, RO_of_FCI.Allot_month,RO_of_FCI.Allot_year, RO_of_FCI.DD_chk_no, RO_of_FCI.DD_chk_date, RO_of_FCI.Remarks, RO_of_FCI.Created_date,RO_of_FCI.updated_date, RO_of_FCI.deleted_date, RO_of_FCI.Balance_Qty,dbo.tbl_MetaData_STORAGE_COMMODITY .Commodity_Name as Commodity_Name,dbo.tbl_MetaData_SCHEME.Scheme_Name as Scheme_Name FROM dbo.RO_of_FCI Left JOIN dbo.tbl_MetaData_STORAGE_COMMODITY ON RO_of_FCI.Commodity = dbo.tbl_MetaData_STORAGE_COMMODITY .Commodity_Id left join dbo.tbl_MetaData_SCHEME on RO_of_FCI.Scheme=dbo.tbl_MetaData_SCHEME.Scheme_Id where RO_of_FCI.RO_No='" + Ro_No + "' and RO_of_FCI.Distt_Id='" + distid + "'";
DataSet ds = obj.selectAny(qryall);
DataRow dr = ds.Tables[0].Rows[0];
txtrono.Text = Ro_No;
txtrono.Enabled = false;
//txtrono.BackColor = System.Drawing.Color.Wheat;
string rdate = dr["RO_date"].ToString();
string rodate = getdate(rdate);
txtrodate.Text = rodate;
txtrodate.ReadOnly = true;
// txtrodate.BackColor = System.Drawing.Color.Wheat;
roqty = dr["RO_qty"].ToString();
txtroqty.Text = dr["RO_qty"].ToString();
txtroqty.ReadOnly = true;
// txtroqty.BackColor = System.Drawing.Color.Wheat;
txtcomdty.Text = dr["Commodity_Name"].ToString();
txtcomdty.ReadOnly = true;
// txtcomdty.BackColor = System.Drawing.Color.Wheat;
txtscheme.Text = dr["Scheme_Name"].ToString();
txtscheme.ReadOnly = true;
// txtscheme.BackColor = System.Drawing.Color.Wheat;
txtbalqty.Text = System.Math.Round(CheckNull(dr["Balance_Qty"].ToString()), 5).ToString();
txtbalqty.ReadOnly = true;
// txtbalqty.BackColor = System.Drawing.Color.Wheat;
obj = new LARO(ComObj);
string qrylaro = "SELECT DepoCode.DepoName,Lift_A_RO.*,dbo.tbl_MetaData_STORAGE_COMMODITY .Commodity_Name as Commodity_Name,dbo.tbl_MetaData_SCHEME.Scheme_Name as Scheme_Name ,Transporter_Table.Transporter_Name as Transporter_Name,districtsmp.district_name as district_name ,tbl_MetaData_DEPOT.DepotName as DepotName FROM dbo.Lift_A_RO left join dbo.tbl_MetaData_STORAGE_COMMODITY on Lift_A_RO.Commodity=dbo.tbl_MetaData_STORAGE_COMMODITY .Commodity_Id left join dbo.tbl_MetaData_SCHEME on Lift_A_RO.Scheme=dbo.tbl_MetaData_SCHEME .Scheme_Id left join dbo.Transporter_Table on Lift_A_RO.Transporter=Transporter_Table.Transporter_ID left join pds.districtsmp on Lift_A_RO.Send_District= districtsmp.district_code left join dbo.tbl_MetaData_DEPOT on Lift_A_RO.Issue_center=dbo.tbl_MetaData_DEPOT.DepotID left join dbo.DepoCode on Lift_A_RO.FCIdepo=DepoCode.DepoCode where Dist_Id='" + distid + "'and Ro_No='" + Ro_No + "'and Challan_No='" + challan + "'";
DataSet dsl = obj.selectAny(qrylaro);
DataRow drl = dsl.Tables[0].Rows[0];
ddldistrict.SelectedItem.Text = drl["district_name"].ToString();
ddldepottype.SelectedItem.Text = drl["FCIdepotype"].ToString();
ddldistrict.SelectedValue = drl["Send_District"].ToString();
ddlfcidist.SelectedItem.Text = drl["FCIdistrict"].ToString();
//ddlfcidist.SelectedValue = drl["FCIdistrict"].ToString();
ddlfcidepo.SelectedItem.Text = drl["DepoName"].ToString();
//ddlfcidepo.SelectedValue = drl["FCIdepo"].ToString();
ddlissue.SelectedItem.Text = drl["DepotName"].ToString();
ddlissue.SelectedValue = drl["Issue_center"].ToString();
txttrans.SelectedItem.Text = drl["Transporter_Name"].ToString();
txttrans.SelectedValue = drl["Transporter"].ToString();
txtvehno.Text = drl["Vehicle_No"].ToString();
txttonumber.Text = drl["TO_Number"].ToString();
txtchallan.Text = drl["Challan_No"].ToString();
txtchallan.ReadOnly = true;
// txtchallan.BackColor = System.Drawing.Color.Wheat;
challandate.Text = getdateg(drl["Challan_Date"].ToString());
txtqtysend.Text = System.Math.Round(CheckNull(drl["Qty_send"].ToString()), 5).ToString();
lblfqty.Text = drl["Qty_send"].ToString();
txtnobags.Text = drl["No_of_Bags"].ToString();
ddlcropyear.SelectedItem.Text = drl["Crop_year"].ToString();
ddlcategory.SelectedItem.Text = drl["Category"].ToString();
txtmoisture.Text = drl["Moisture"].ToString();
string time = drl["Dispatch_Time"].ToString();
string hh = time.Substring(0, 2);
string mm = time.Substring(3, 2);
string ampm = time.Substring(6, 2);
ddlhour.SelectedItem.Text = hh;
ddlminute.SelectedItem.Text = mm;
ddlampm.SelectedItem.Text = ampm;
}
protected void btnsave_Click(object sender, EventArgs e)
{
string mroto = ddlrono.SelectedValue;
string mtonoRO = txttorderno.Text;
string qryTODR = "Select * from dbo.Transport_Order_againstRo where RO_No='" + mroto + "' and Distt_Id='" + distid + "' and TO_Number='" + mtonoRO + "'";
obj = new LARO(ComObj);
DataSet dstoDR = obj.selectAny(qryTODR);
if (dstoDR.Tables[0].Rows.Count == 0)
{
if (ddlrono.SelectedItem.Text == "--Select--" || ddltransport.SelectedItem.Text == "--Select--")
{
Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('Please Select The RO Number And Transporter Name '); </script> ");
}
else
{
DateTime fdate = new DateTime();
DateTime tdate = new DateTime();
string fromdate = getmmddyy(txtrodate.Text);
string todate = getmmddyy(DaintyDate1.Text);
//string todate = getDate_MDY(DaintyDate1.Text);
fdate = DateTime.Parse(fromdate.ToString());
tdate = DateTime.Parse(todate.ToString());
//string todate = getDate_MDY(DaintyDate1.Text);
//tdate = Convert.ToDateTime(todate);
string validity = get_days(tdate, fdate);
if (int.Parse(validity) < 0)
{
string RO_NO = ddlrono.SelectedValue;
Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('Validity has been expired'); </script> ");
string qrytoupdate = "Update dbo.TO_Allot_Lift set Locked='N' where RO_No='" + RO_NO + "' and Distt_Id='" + distid + "'";
cmd.CommandText = qrytoupdate;
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
else
{
int bqty = CheckNullInt(txtbalqty.Text);
int sqty = CheckNullInt(txtsendqty.Text);
if (sqty > bqty || sqty == 0)
{
Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('Sending Qty Should Not Be Greater Than Pending Qty or 0'); </script> ");
}
else
{
string mrono = ddlrono.SelectedItem.ToString();
float mroqty = CheckNull(txtroqty.Text);
string mrdate = DateTime.Today.Date.ToString();
string mtono = txttorderno.Text;
string mtodate = getDate_MDY(DaintyDate1.Text);
string mtaname = ddltransport.SelectedValue;
float miqty = CheckNull(txtsendqty.Text);
float mcumqty = CheckNull(txtcumlqty.Text);
float mpqty = CheckNull(txtbalqty.Text);
// string mcdate = getDate_MDY(DateTime.Today.Date.ToString());
int month = int.Parse(DateTime.Today.Month.ToString());
int year = int.Parse(DateTime.Today.Year.ToString());
string udate = "";
string ddate = "";
string tid = "1";
int balamt = int.Parse((txtbalqty.Text)) - int.Parse((txtsendqty.Text));
string Balance_Qty = balamt.ToString();
float balqty = CheckNull(Balance_Qty);
float cumqty = CheckNull(txtcumlqty.Text);
float sendqty = CheckNull(txtsendqty.Text);
float tcumqty = cumqty + sendqty;
string mtid = ddltransport.SelectedValue;
string todist = ddldistrict.SelectedValue;
string toissuecenter = ddlissue.SelectedValue;
string lift = "N";
if (ddltransport.SelectedItem.Text == "--Select--")
{
Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('Please Select The Transporter..'); </script> ");
}
else
{
string qry = "insert into dbo.Transport_Order_againstRo(Distt_Id,RO_No,RO_qty,RO_Validity,TO_Number,TO_Date,Transporter_Name,toDistrict,toIssueCenter,Quantity,Cumulative_Qty,Pending_Qty,Month,Year,Trunsuction_Id,IsLifted,Created_date,updated_date,deleted_date)values('" + distid + "','" + mrono + "'," + mroqty + ",'" + mrdate + "','" + mtono + "','" + mtodate + "','" + mtaname + "','" + todist + "','" + toissuecenter + "'," + miqty + "," + tcumqty + "," + balamt + "," + month + "," + year + ",'" + tid + "','" + lift + "',getdate(),'" + udate + "','" + ddate + "')";
cmd.CommandText = qry;
cmd.Connection = con;
//string uquery = "update dbo.RO_of_FCI set Balance_Qty=" + balqty + "where RO_No='" + mrono + "' and Distt_Id='" + distid + "'";
//DataRow drto = dsto.Tables[0].Rows[0];
try
{
con.Open();
int count = cmd.ExecuteNonQuery();
if (count == 1)
{
//cmd.CommandText = uquery;
//cmd.ExecuteNonQuery();
string qryTO = "Select * from dbo.TO_Allot_Lift where RO_No='" + mrono + "' and Distt_Id='" + distid + "'";
obj = new LARO(ComObj);
DataSet dsto = obj.selectAny(qryTO);
if (dsto.Tables[0].Rows.Count == 0)
{
string locked = "Y";
float liftqty = 0;
float pqty = CheckNull(txtbalqty.Text) - CheckNull(txtsendqty.Text);
string qrytoinsert = "insert into dbo.TO_Allot_Lift(Distt_Id,RO_No,RO_qty,RO_Validity,Transporter_ID,Cumulative_Qty,Pending_Qty,Lifted_Qty,Month,Year,Created_date,Locked)values('" + distid + "','" + mrono + "'," + mroqty + ",'" + mrdate + "','" + mtid + "'," + tcumqty + "," + pqty + "," + liftqty + "," + month + "," + year + ",getdate(),'" + locked + "')";
cmd.CommandText = qrytoinsert;
cmd.ExecuteNonQuery();
}
else
{
float pqty = CheckNull(txtbalqty.Text) - CheckNull(txtsendqty.Text);
string qrytoupdate = "Update dbo.TO_Allot_Lift set RO_qty=" + mroqty + ",Cumulative_Qty=" + tcumqty + ",Pending_Qty=" + pqty + ",Month=" + month + ",Year=" + year + ",Created_date='" + udate + "'where RO_No='" + mrono + "' and Distt_Id='" + distid + "'";
cmd.CommandText = qrytoupdate;
cmd.ExecuteNonQuery();
}
}
Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('Data Saved Successfully...'); </script> ");
btnsave.Enabled = false;
fillgrid();
}
catch (Exception ex)
{
Label1.Visible = true;
Label1.Text = ex.Message;
}
finally
{
con.Close();
ComObj.CloseConnection();
}
}
con.Open();
}
}
}
}
else
{
Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('Transport Order Number Already Exist ..... '); </script> ");
}
}
