protected void btngetreport_Click(object sender, EventArgs e)
{
try
{
if (Rdboutward.SelectedValue == "Outward")
{
DataTable dt = OutwardDetail.Get_OutwardDetails(txtoutwardno1.Text.ToString().Trim(), "Outward", "G", Convert.ToInt32(strFY), Convert.ToDateTime("2011/2/2"), Convert.ToDateTime("2012/3/3")).Tables[0];
GrdOD.DataSource = dt;
GrdOD.DataBind();
}//[Idv_Chetana_Get_OutwardDetails]
else
if (Rdboutward.SelectedValue == "Invoice")
{
DataTable dt = OutwardDetail.Get_OutwardDetails(txtoutwardno1.Text.ToString().Trim(), "ss", "I", Convert.ToInt32(strFY), Convert.ToDateTime("2011/2/2"), Convert.ToDateTime("2012/3/3")).Tables[0];
GrdOD.DataSource = dt;
GrdOD.DataBind();
}
else
{
DataTable dt = OutwardDetail.Get_OutwardDetails(txtoutwardno1.Text.ToString().Trim(), "ss", "D", Convert.ToInt32(strFY), Convert.ToDateTime("2011/2/2"), Convert.ToDateTime("2012/3/3")).Tables[0];
GrdOD.DataSource = dt;
GrdOD.DataBind();
}
}
catch { }
}
protected void btnadd_Click(object sender, EventArgs e)
{
try
{
if (RdbtnSelect.SelectedValue == "Invoice")
{
flag = "I";
TFlag = 'I';
DataTable dt1 = new DataTable();
dt1 = OutwardDetail.GetCustN_Invoice(Convert.ToDecimal(Txtno.Text.Trim()), Convert.ToInt32(strFY)).Tables[0];
if (dt1.Rows.Count != 0)
{
lblCustName.Text = Convert.ToString(dt1.Rows[0]["CustName"]);
lblArea.Text = Convert.ToString(dt1.Rows[0]["AreaName"]);
Adddata();
}
else
{
btnSave.Visible = false;
message("Records Not Available");
Txtno.Focus();
}
}
if (RdbtnSelect.SelectedValue == "Document")
{
flag = "D";
TFlag = 'D';
DataTable dt2 = new DataTable();
try
{
dt2 = OutwardDetail.GetCustN_Doc(Convert.ToInt32(Txtno.Text.Trim()), Convert.ToInt32(strFY)).Tables[0];
if (dt2.Rows.Count != 0)
{
lblCustName.Text = Convert.ToString(dt2.Rows[0]["CustName"]);
lblArea.Text = Convert.ToString(dt2.Rows[0]["AreaName"]);
Adddata();
//btngetRec.Focus();
}
else
{
btnSave.Visible = false;
message("Records Not Available");
Txtno.Focus();
}
}
catch { message("Plase Enter Correct DC Number"); }
}
}
catch
{
}
}
public void BindOutWard()
{
if (Request.QueryString["d"] != null && Request.QueryString["sd"] != null)
{
DataTable dt = OutwardDetail.Get_OutwardDetails(Request.QueryString["d"].ToString().Trim(), Request.QueryString["sd"].ToString().Trim(), Request.QueryString["IOD"].ToString().Trim()
, Convert.ToInt32(Request.QueryString["FY"].ToString().Trim())).Tables[0];
DataView dv = new DataView(dt);
ReportDocument rd = new ReportDocument();
rd.Load(Server.MapPath("../Report/OutWardReport.rpt"));
rd.Database.Tables[0].SetDataSource(dv);
Printoutward.ReportSource = rd;
}
}
protected void GrdOD_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
OutwardDetail objodd = new OutwardDetail();
OutDetailID = Convert.ToInt32(((Label)GrdOD.Rows[e.RowIndex].FindControl("lbldetailid")).Text);
try
{
if (OutDetailID != 0)
{
objodd.OdDAutoId = OutDetailID;
objodd.IsActive = false;
objodd.InvoiceNo = ((Label)GrdOD.Rows[e.RowIndex].FindControl("LblInvoiceNo")).Text.Trim();
objodd.CustomerName = ((Label)GrdOD.Rows[e.RowIndex].FindControl("LblCustN")).Text.Trim();
objodd.CustArea = ((Label)GrdOD.Rows[e.RowIndex].FindControl("LblArea")).Text.Trim();
objodd.FY = Convert.ToInt32(strFY);
objodd.Save();
}
DataTable dt3 = new DataTable();
dt3 = (DataTable)Session["tempODData"];
dt3.Rows[e.RowIndex].Delete();
GrdOD.DataSource = dt3;
GrdOD.DataBind();
Session["tempODData"] = dt3;
if (dt3.Rows.Count == 0)
{
btnSave.Visible = false;
}
else
{
btnSave.Visible = true;
}
}
catch { }
}
protected void btnSave_Click(object sender, EventArgs e)
{
ODdate = txtOutwardDate.Text.Split('/')[2] + "/" + txtOutwardDate.Text.Split('/')[1] + "/" + txtOutwardDate.Text.Split('/')[0];
ddt = Convert.ToDateTime(ODdate);
if (Session["UserName"] != null)
{
if (flag != "")
{
try
{
OutwardMaster objodm = new OutwardMaster();
OutwardDetail objodd = new OutwardDetail();
objodm.OdMAutoId = 0;
objodm.OutWardDate = ddt;
objodm.IsActive = true;
objodm.CreatedBy = Session["UserName"].ToString();
objodm.FY = Convert.ToInt32(strFY);
objodm.HandOverTo = TxtEmp.Text.Trim();
objodm.Remarks = TxtRemark.Text.Trim();
objodm.Save(out DocNo, out OdMID);
//Txtdocno.Text = Convert.ToString(DocNo);
foreach (GridViewRow Row in GrdOD.Rows)
{
objodd.OdDAutoId = 0;
objodd.OdMAutoId = OdMID;
objodd.InvoiceOrDC = ((Label)Row.FindControl("LblFlag")).Text.Trim();
objodd.InvoiceNo = ((Label)Row.FindControl("LblInvoiceNo")).Text.Trim();
objodd.CustomerName = ((Label)Row.FindControl("LblCustN")).Text.Trim();
objodd.CustArea = ((Label)Row.FindControl("LblArea")).Text.Trim();
objodd.IsActive = true;
objodd.FY = Convert.ToInt32(strFY);
//if (RdbtnSelect.SelectedValue == "Invoice")
//{
// TFlag = 'I';
// objodd.InvoiceNo = (Txtno.Text.Trim());
//}
//if (RdbtnSelect.SelectedValue == "Document")
//{
// TFlag = 'D';
// objodd.InvoiceNo = (Txtno.Text.Trim());
//}
objodd.Save();
}
MessageBox(Constants.save + "\\r\\n Document No: " + DocNo);
//MessageBox(Constants.save);
//loder("Last saved Document no. : " + Txtdocno.Text);
TxtEmp.Text = "";
Txtno.Text = "";
txtOutwardDate.Text = DateTime.Now.ToString("dd/MM/yyyy");
Session["tempODData"] = null;
btnSave.Visible = false;
GrdOD.DataBind();
}
catch
{
}
}
}
}
protected void btnadd_Click(object sender, EventArgs e)
{
btnForceAdd.Visible = false;
try
{
if (RdbtnSelect.SelectedValue == "Invoice")
{
flag = "I";
TFlag = 'I';
DataTable dt1 = new DataTable();
dt1 = OutwardDetail.GetCustN_Invoice(Convert.ToDecimal(Txtno.Text.Trim()), Convert.ToInt32(strFY)).Tables[0];
if (dt1.Rows.Count > 0)
{
if (dt1.Rows[0]["Exist"].ToString().Trim() == "no")
{
lblCustName.Text = Convert.ToString(dt1.Rows[0]["CustName"]);
lblArea.Text = Convert.ToString(dt1.Rows[0]["AreaName"]);
Adddata(Txtno.Text.Trim());
Txtno.Focus();
}
else
{
message("Invoice No has already been added to OUT Ward Entry. Document No for the same is "
+ dt1.Rows[0]["RefOut"]);
Txtno.Focus();
}
}
else
{
btnSave.Visible = false;
message("Records Not Available");
Txtno.Focus();
}
}
if (RdbtnSelect.SelectedValue == "Document")
{
flag = "D";
TFlag = 'D';
DataTable dt2 = new DataTable();
try
{
dt2 = OutwardDetail.GetCustN_Doc(Convert.ToInt32(Txtno.Text.Trim()), Convert.ToInt32(strFY)).Tables[0];
if (dt2.Rows.Count > 0)
{
if (dt2.Rows[0]["Exist"].ToString().Trim() == "no")
{
lblCustName.Text = Convert.ToString(dt2.Rows[0]["CustName"]);
lblArea.Text = Convert.ToString(dt2.Rows[0]["AreaName"]);
Adddata(Txtno.Text.Trim());
Txtno.Focus();
} //btngetRec.Focus();
else
{
message("DC No has already been added to OUT Ward Entry. New Document No can be "
+ dt2.Rows[0]["NewDCNo"] + " ");
lblCustName.Text = Convert.ToString(dt2.Rows[0]["CustName"]);
lblArea.Text = Convert.ToString(dt2.Rows[0]["AreaName"]);
lblSelectedDoc.Text = dt2.Rows[0]["NewDCNo"].ToString();
btnForceAdd.Visible = true;
lblMsg.Visible = true;
lblSelectedDoc.Visible = true;
btnForceAdd.Focus();
}
}
else
{
btnSave.Visible = false;
message("Records Not Available");
Txtno.Focus();
}
}
catch (Exception ex) { message("Plase Enter Correct DC Number "); }
}
// TNo = Convert.ToDecimal(Txtno.Text.Trim());
// TCustName = lblCustName.Text.Trim();
// TAreaName = lblArea.Text.Trim();
// DataTable dt = new DataTable();
// if (Session["tempODData"] != null)
// {
// Session["tempODData"] = fillTempODData();
// dt = (DataTable)Session["tempODData"];
// }
// else
// {
// Session["tempODData"] = fillTempODData();
// dt = (DataTable)Session["tempODData"];
// }
// GrdOD.DataSource = dt;
// GrdOD.DataBind();
//// txtOutwardDate.Text = DateTime.Now.ToString("dd/MM/yyyy");
// Txtno.Text = "";
// lblCustName.Text = "";
// lblArea.Text = "";
// RdbtnSelect.Focus();
}
catch (Exception ex) { message("Plase Enter Correct DC Number " + ex.Message.ToString()); }
}