public void GetClientInfo()
{
try
{
BLAddInvoice blAddCl = new BLAddInvoice();
string ClNm = drpdwnClientNm.SelectedItem.Text;
if (drpdwnClientNm.SelectedItem.Text != "--Select--")
{
SqlDataReader dr = blAddCl.getClientInfo(ClNm);
if (dr.HasRows)
{
while (dr.Read())
{
string add = dr.GetString(0) + "\n" + dr.GetString(1) + "\n" + dr.GetString(2) + "\n" + dr.GetString(3) + "\n" + dr.GetString(4);
txtAddInvce.Text = add;
txtPanNo.Text = dr.GetString(5);
txtBillNo.Text = dr.GetString(6);
}
dr.Close();
}
}
Session["ClNm"] = ClNm;
Session["Add"] = txtAddInvce.Text;
Session["PAN"] = txtPanNo.Text;
Session["BillNo"] = txtBillNo.Text;
}
catch (Exception ex)
{
lblCatchError.Text = ex.Message.ToString();
}
}
protected void ddlCliNm_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
BLAddInvoice blInv = new BLAddInvoice();
string strClientName1 = Convert.ToString(ddlCliNm.SelectedItem.Text);
SqlDataReader dr = blInv.getClIdByName(strClientName1);
if (dr.HasRows)
{
dr.Read();
lblCliId1.Text = dr.GetInt32(0).ToString();
}
dr.Close();
fillgridService();
}
catch (Exception ex)
{
lblCatchError.Text = ex.Message.ToString();
}
}
protected void SaveProjectDetail(int InvoiceId, int mode)
{
try
{
BLAddInvoice blgetIn = new BLAddInvoice();
for (int i = 0; i < dtSelProject.Rows.Count; i++)
{
int projectid = int.Parse(dtSelProject.Rows[i].Field<string>(0));
float proamt = float.Parse(dtSelProject.Rows[i].Field<string>(1));
blgetIn.AddInvoiceDetail(InvoiceId, projectid, proamt);
}
for (int i = 0; i < dtUnselProject.Rows.Count; i++)
{
int ProjectId = int.Parse(dtUnselProject.Rows[i].Field<string>(0));
blgetIn.DelProjectDetail(ProjectId);
}
}
catch (Exception ex)
{
lblCatchError.Text = ex.Message.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
BLAddInvoice blAddCl = new BLAddInvoice();
txtDtInvce.Text = System.DateTime.Now.ToShortDateString();
if ((HttpContext.Current.Session["LoginId"]) == null)
{
Response.Redirect("~/Login.aspx");
}
Session["SelectProject"] = 0;
if (Page.IsPostBack)
{
Session["dtgetselectedRecords"] = null;
}
SqlDataReader dr = blAddCl.getClientInvce();
if (dr.HasRows == true)
{
while (dr.Read())
drpdwnClientNm.Items.Add(dr.GetString(0));
drpdwnClientNm.Items.Insert(0, new ListItem("--Select--", "-1"));
dr.Close();
}
if (!Page.IsPostBack)
{
if (Request.QueryString["Id"] == "1")
{
clnm = Session["ClNm"].ToString();
drpdwnClientNm.SelectedValue = clnm;
txtAddInvce.Text = Session["Add"].ToString();
txtPanNo.Text = Session["PAN"].ToString();
txtBillNo.Text = Session["BillNo"].ToString();
string amt = txtAmtAddInvce.Text.ToString();
Session["TotalAmount"] = amt;
string ClientName = drpdwnClientNm.SelectedValue.ToString();
Session["ClientName"] = ClientName;
}
DataTable dt = Session["dtgetselectedRecords"] as DataTable;
double amt1 = Convert.ToDouble(Session["amt"]);
if (dt != null)
{
GdVwAddInvce.DataSource = dt;
GdVwAddInvce.DataBind();
}
if (dt != null)
{
double amtNew = 0.0;
for (int i = 0; i < dt.Rows.Count; i++)
{
amtNew += double.Parse(dt.Rows[i].Field<string>(4));
}
Session["addedamt"] = amtNew.ToString();
txtAmtAddInvce.Text = amtNew.ToString();
}
SelAllCheckbox();
if (Request.QueryString["InvoiceId"] != null)
{
InvoiceId = int.Parse(Request.QueryString["InvoiceId"]);
Session["InvoiceId"] = InvoiceId;
SqlDataReader drgetInv = blAddCl.getInvoiceForUpdate(InvoiceId);
if (drgetInv.HasRows == true)
{
while (drgetInv.Read())
{
DateTime indate = drgetInv.GetDateTime(2);
txtDtInvce.Text = indate.ToString("dd/MM/yyyy");
int ClId = drgetInv.GetInt32(3);
Session["ClId"] = ClId.ToString();
drpdwnClientNm.SelectedValue = Session["ClientName"].ToString();
GetClientInfo();
txtAmtAddInvce.Text = drgetInv.GetDecimal(4).ToString();
txtBillNo.Text = Session["InvoiceNo"].ToString();
txtRemrk.Text = drgetInv.GetString(7);
if (drgetInv.GetInt32(9) == 1)
chkbxisDel.Checked = true;
else
chkbxisDel.Checked = false;
if (drgetInv.GetInt32(10) == 1)
chkbxAppInv.Checked = true;
else
chkbxAppInv.Checked = false;
}
drgetInv.Close();
}
DataTable dtgetInvDet = blAddCl.GetInvoiceDetailForUpdate(InvoiceId);
GdVwAddInvce.DataSource = dtgetInvDet;
GdVwAddInvce.DataBind();
Session["dtgetselectedRecordsUpdate"] = dtgetInvDet;
SelAllCheckbox();
}
}
else
{
lblCatchError.Text = "";
lblSelProjectMessage.Text = "";
lblResult.Text = "";
}
//if (!Page.IsPostBack)
//{
// if (Request.QueryString["InvoiceId"] != null)
// {
// InvoiceId = int.Parse(Request.QueryString["InvoiceId"]);
// Session["InvoiceId"] = InvoiceId;
// SqlDataReader drgetInv = blAddCl.getInvoiceForUpdate(InvoiceId);
// //SqlDataReader dr = blAddCl.getClientInvce();
// //if (dr.HasRows == true)
// //{
// // while (dr.Read())
// // drpdwnClientNm.Items.Add(dr.GetString(0));
// // drpdwnClientNm.Items.Insert(0, new ListItem("--Select--", "-1"));
// // dr.Close();
// //}
// if (Request.QueryString["Id"] == "1")
// {
// clnm = Session["ClNm"].ToString();
// drpdwnClientNm.SelectedValue = clnm;
// txtAddInvce.Text = Session["Add"].ToString();
// txtPanNo.Text = Session["PAN"].ToString();
// txtBillNo.Text = Session["BillNo"].ToString();
// string amt = txtAmtAddInvce.Text.ToString();
// Session["TotalAmount"] = amt;
// string ClientName = drpdwnClientNm.SelectedValue.ToString();
// Session["ClientName"] = ClientName;
// }
// DataTable dt = Session["dtgetselectedRecords"] as DataTable;
// double amt1 = Convert.ToDouble(Session["amt"]);
// if (dt != null)
// {
// GdVwAddInvce.DataSource = dt;
// GdVwAddInvce.DataBind();
// double amtNew = 0.0;
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// amtNew += double.Parse(dt.Rows[i].Field<string>(4));
// }
// Session["addedamt"] = amtNew.ToString();
// txtAmtAddInvce.Text = amtNew.ToString();
// }
// if (drgetInv.HasRows == true)
// {
// while (drgetInv.Read())
// {
// DateTime indate = drgetInv.GetDateTime(2);
// txtDtInvce.Text = indate.ToString("dd/MM/yyyy");
// int ClId = drgetInv.GetInt32(3);
// Session["ClId"] = ClId.ToString();
// drpdwnClientNm.SelectedValue = Session["ClientName"].ToString();
// GetClientInfo();
// txtAmtAddInvce.Text = drgetInv.GetDecimal(4).ToString();
// txtBillNo.Text = Session["InvoiceNo"].ToString();
// txtRemrk.Text = drgetInv.GetString(7);
// if (drgetInv.GetInt32(9) == 1)
// chkbxisDel.Checked = true;
// else
// chkbxisDel.Checked = false;
// if (drgetInv.GetInt32(10) == 1)
// chkbxAppInv.Checked = true;
// else
// chkbxAppInv.Checked = false;
// }
// drgetInv.Close();
// }
// DataTable dtgetInvDet = blAddCl.GetInvoiceDetailForUpdate(InvoiceId);
// GdVwAddInvce.DataSource = dtgetInvDet;
// GdVwAddInvce.DataBind();
// Session["dtgetselectedRecordsUpdate"] = dtgetInvDet;
// }
// SelAllCheckbox();
//}
//else
//{
// //Session["dtgetselectedRecords"] = null;
// lblCatchError.Text = "";
// lblSelProjectMessage.Text = "";
// lblResult.Text = "";
//}
}
catch (Exception ex)
{
lblCatchError.Text = ex.Message.ToString();
}
}
protected void drpdwnClientNm_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
int ClientId = 0;
string ClNm = drpdwnClientNm.SelectedItem.Text;
BLAddInvoice blAddCl = new BLAddInvoice();
GetClientInfo();
DataTable dtCleintDet = new DataTable();
dtCleintDet.Columns.Add("Address");
dtCleintDet.Columns.Add("PAN");
dtCleintDet.Columns.Add("BillNo");
string add = txtAddInvce.Text;
string pan = txtPanNo.Text;
string billno = txtBillNo.Text;
dtCleintDet.Rows.Add(add, pan, billno);
Session["ClNm"] = ClNm;
Session["Add"] = txtAddInvce.Text;
Session["PAN"] = txtPanNo.Text;
Session["BillNo"] = txtBillNo.Text;
SqlDataReader dr1 = blAddCl.getClIdByName(ClNm);
if (dr1.HasRows)
{
dr1.Read();
ClientId = dr1.GetInt32(0);
dr1.Close();
}
Session["ClId"] = ClientId;
}
catch (Exception ex)
{
lblCatchError.Text = ex.Message.ToString();
}
}
protected void btnSvPrvInv_Click(object sender, EventArgs e)
{
int ClId = 0;
try
{
// Session["InvoiceId"] = null;
int mode = 0, Invoiceid = 0;
BLAddInvoice blgetIn = new BLAddInvoice();
SqlDataReader dr = blgetIn.GetInvoiceId1();
if (dr.HasRows)
{
dr.Read();
Invoiceid = dr.GetInt32(0);
dr.Close();
}
Invoiceid++;
string InvoiceNo = Session["BillNo"] + Invoiceid.ToString();
DateTime date = Convert.ToDateTime(txtDtInvce.Text);
ClId = Convert.ToInt32(Session["ClId"]);
decimal amt = decimal.Parse(txtAmtAddInvce.Text);
decimal OtherChrge = Convert.ToDecimal(0);
decimal TotAmt = Convert.ToDecimal(txtAmtAddInvce.Text);
string remark = txtRemrk.Text;
string status = "In Process";
int isdel = 0;
if (chkbxisDel.Checked)
isdel = 1;
else
isdel = 0;
int app = 0;
if (chkbxAppInv.Checked)
app = 1;
else
app = 0;
if (GdVwAddInvce.Rows.Count == 0)
{
lblSelProjectMessage.Text = "Please Select At Least One Project";
}
else
{
fillSelUnselectedProjects();
int InvId;
if (Session["InvoiceId"] != null)
{
InvoiceNo = txtBillNo.Text;
InvId = int.Parse(Session["InvoiceId"].ToString());
mode = 1;
if (dtSelProject.Rows.Count == 0)
{
lblSelProjectMessage.Text = "Please Select At Least One Project";
}
else
{
blgetIn.AddInvoice(InvId, InvoiceNo, date, ClId, amt, OtherChrge, TotAmt, remark, status, isdel, app, mode);
SaveProjectDetail(InvId, mode);
HiddenFieldInvoiceId.Value = Convert.ToString(InvId);
lblResult.Visible = true;
lblResult.Text = "Invoice Details are Updated Successfully";
//ClientScript.RegisterStartupScript(this.GetType(), "newWindow", String.Format("<script>window.open('{0}');</script>", "Invoice.aspx?InvoiceID=" + InvId));
Generate_Invoice_and_Annexure();
//Session["InvoiceId"] = null;
clearfilelds();
}
}
else
{
if (dtSelProject.Rows.Count == 0)
{
lblSelProjectMessage.Text = "please select atleast one project";
}
else
{
blgetIn.AddInvoice(Invoiceid, InvoiceNo, date, ClId, amt, OtherChrge, TotAmt, remark, status, isdel, app, mode);
SaveProjectDetail(Invoiceid, mode);
HiddenFieldInvoiceId.Value = Convert.ToString(Invoiceid);
lblResult.Visible = true;
lblResult.Text = "Invoice Details are Added Successfully";
//ClientScript.RegisterStartupScript(this.GetType(), "newWindow", String.Format("<script>window.open('{0}');</script>", "Invoice.aspx?InvoiceID=" + Invoiceid));
Generate_Invoice_and_Annexure();
clearfilelds();
}
}
}
}
catch (Exception ex)
{
lblCatchError.Text = ex.Message.ToString();
}
string amount = txtAmtAddInvce.Text;
decimal TotAmt1 = Convert.ToDecimal(txtAmtAddInvce.Text);
}