protected void BtnSave_Click(object sender, EventArgs e)
{
db.insert("insert into enquirymaster values('" + lblenquiryno.Text + "' ,'" + drpindentno.SelectedItem.ToString() + "' ,'" + drpcompany.SelectedValue + "' ,'" + txtdate.Text + "' ,'" + txtnarration.Text + "' ,'" + lblTotalAmt.Text + "' ,'" + Session["UserName"].ToString() + "' ,'" + Session["mob"].ToString() + "')");
foreach (GridViewRow gvrow in GrdRequisition.Rows)
{
TextBox txtqty = gvrow.FindControl("txtqty") as TextBox;
DropDownList ddlsupplier = gvrow.FindControl("ddlsupplier") as DropDownList;
DropDownList ddlsupplier2 = gvrow.FindControl("ddlsupplier2") as DropDownList;
DropDownList ddlsupplier3 = gvrow.FindControl("ddlsupplier3") as DropDownList;
DropDownList ddlsupplier4 = gvrow.FindControl("ddlsupplier4") as DropDownList;
DropDownList ddlsupplier5 = gvrow.FindControl("ddlsupplier5") as DropDownList;
DropDownList ddlsupplier6 = gvrow.FindControl("ddlsupplier6") as DropDownList;
TextBox txtremark = gvrow.FindControl("txtremark") as TextBox;
TextBox txtitem = gvrow.FindControl("TxtItemName") as TextBox;
TextBox txtitemname = gvrow.FindControl("txtParticulars") as TextBox;
if (ddlsupplier.SelectedItem.Text != "Select Supplier")
{
db.insert("insert into Enquirydetails values( '" + txtitemname.Text + "','" + txtitem.Text + "' , '" + txtqty.Text + "' ,'" + ddlsupplier.SelectedItem.Text + "' , '" + txtremark.Text + "' ,'" + "" + "' , '" + lblenquiryno.Text + "','" + drpindentno.SelectedItem.ToString() + "' ,'" + "open" + "')");
}
if (ddlsupplier2.SelectedItem.Text != "Select Supplier")
{
db.insert("insert into Enquirydetails values( '" + txtitemname.Text + "','" + txtitem.Text + "' , '" + txtqty.Text + "' ,'" + ddlsupplier2.SelectedItem.Text + "','" + txtremark.Text + "' ,'" + "" + "' , '" + lblenquiryno.Text + "','" + drpindentno.SelectedItem.ToString() + "' ,'" + "open" + "')");
}
if (ddlsupplier3.SelectedItem.Text != "Select Supplier")
{
db.insert("insert into Enquirydetails values( '" + txtitemname.Text + "','" + txtitem.Text + "' , '" + txtqty.Text + "' ,'" + ddlsupplier3.SelectedItem.Text + "','" + txtremark.Text + "' ,'" + "" + "' , '" + lblenquiryno.Text + "','" + drpindentno.SelectedItem.ToString() + "' ,'" + "open" + "')");
}
if (ddlsupplier4.SelectedItem.Text != "Select Supplier")
{
db.insert("insert into Enquirydetails values( '" + txtitemname.Text + "','" + txtitem.Text + "' , '" + txtqty.Text + "' ,'" + ddlsupplier4.SelectedItem.Text + "','" + txtremark.Text + "' ,'" + "" + "' , '" + lblenquiryno.Text + "','" + drpindentno.SelectedItem.ToString() + "' ,'" + "open" + "')");
}
if (ddlsupplier5.SelectedItem.Text != "Select Supplier")
{
db.insert("insert into Enquirydetails values( '" + txtitemname.Text + "','" + txtitem.Text + "' , '" + txtqty.Text + "' ,'" + ddlsupplier5.SelectedItem.Text + "','" + txtremark.Text + "' ,'" + "" + "' , '" + lblenquiryno.Text + "','" + drpindentno.SelectedItem.ToString() + "' ,'" + "open" + "')");
}
if (ddlsupplier6.SelectedItem.Text != "Select Supplier")
{
db.insert("insert into Enquirydetails values( '" + txtitemname.Text + "','" + txtitem.Text + "' , '" + txtqty.Text + "' ,'" + ddlsupplier6.SelectedItem.Text + "','" + txtremark.Text + "' ,'" + "" + "' , '" + lblenquiryno.Text + "','" + drpindentno.SelectedItem.ToString() + "' ,'" + "open" + "')");
}
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertBox", "alert('Enquiry Genrated Successfully ');", true);
GrdRequisition.DataSource = "";
GrdRequisition.DataBind();
ReportGrid.DataSource = db.Displaygrid("select distinct(Enquirydetails.supplier) , (enquirymaster.id) as #, Enquirydetails.reamrk , enquirymaster.date , enquirymaster.enno from Enquirydetails inner join enquirymaster on enquirymaster.enno=Enquirydetails.enno order by enquirymaster.enno desc ");
ReportGrid.DataBind();
}
}
protected void drpindentno_SelectedIndexChanged(object sender, EventArgs e)
{
string abc = drpindentno.SelectedValue;
string[] tokens = abc.Split('=');
int projectid = Convert.ToInt32(db.getDb_Value("select IsCostCentre from RequisitionCafeteria where RequisitionCafeId = '" + drpindentno.SelectedValue + "'"));
string projectno = db.getDbstatus_Value("select ProjectName from Project_master where id='" + projectid + "' ");
lblenquiryno.Text = "ENQ" + "/" + projectno + "/" + "00" + ENNO.ToString();
GrdRequisition.DataSource = db.Displaygrid(" select IM.ItemName, ID.ItemDesc, RCD.Qty as Qty from RequisitionCafeDtls RCD inner join ItemMaster IM on RCD.ItemId=IM.ItemId left join ItemCategory IC on IC.CategoryId=IM.CategoryId left join SubCategory SC on SC.SubCategoryId=IM.SubcategoryId left join ItemDetails ID on ID.ItemDetailsId=RCD.ItemDetailsId left join UnitConversionDtls UCD on UCD.UnitConvDtlsId=RCD.UnitConvDtlsId Left join StockLocation SL on IM.StockLocationID=SL.StockLocationID left join TemplateDetails TM on RCD.TemplateID=TM.TemplateDtlsID left join SuplierMaster SM on RCD.VendorId=SM.SuplierId left Join PriorityMaster PM on RCD.PriorityID=PM.PriorityID left Join UnitMaster UM on RCD.UnitConvDtlsId=UM.UnitId where RCD.RequisitionCafeId='" + drpindentno.SelectedValue + "'");
GrdRequisition.DataBind();
}
protected void BtnSave_Click(object sender, EventArgs e)
{
foreach (GridViewRow gvrow in GrdRequisition.Rows)
{
TextBox txtparticular = (TextBox)gvrow.FindControl("TxtItemName");
TextBox txtrate = (TextBox)gvrow.FindControl("txtrate");
TextBox txtqty = (TextBox)gvrow.FindControl("txtqty");
TextBox txtamount = (TextBox)gvrow.FindControl("txtamount");
TextBox itemname = (TextBox)gvrow.FindControl("txtparti1");
TextBox cgstper = (TextBox)gvrow.FindControl("GrdtxtCGSTPer");
TextBox cgstamt = (TextBox)gvrow.FindControl("GrdtxtCGSTAmt");
TextBox sgstper = (TextBox)gvrow.FindControl("GrdtxtSGSTPer");
TextBox sgstamt = (TextBox)gvrow.FindControl("GrdtxtSGSTAmt");
TextBox igstper = (TextBox)gvrow.FindControl("GrdtxtIGSTPer");
TextBox igstamt = (TextBox)gvrow.FindControl("GrdtxtIGSTAmt");
TextBox txtgst = (TextBox)gvrow.FindControl("GrdtxtPerVAT");
// string particular = txtparticular.Text;
double a = double.Parse(txtamount.Text);
db.insert("insert into Supplierenquiryitem values( '" + est.Text + "' ,'" + drpenquiry.SelectedValue + "' , '" + itemname.Text + "','" + txtparticular.Text + " ' , '" + txtqty.Text + " ' ,'" + txtrate.Text + "' ,'" + Math.Round(a) + "' ,'" + drpsupplier.SelectedValue + "' ,'" + cgstper.Text + "' ,'" + cgstamt.Text + "' ,'" + sgstper.Text + "' ,'" + sgstamt.Text + "' ,'" + igstper.Text + "' ,'" + igstamt.Text + "' ,'" + txtgst.Text + "')");
}
db.insert("insert into supplierenquirydetails values('" + est.Text + "','" + drpenquiry.SelectedValue + "' ,'" + txtdate.Text + "' ,'" + drpsupplier.SelectedValue + "' ,'" + txtSubTotal.Text + "' ,'" + 0 + "' ,'" + 0 + "' ,'" + 0 + "' ,'" + 0 + "' ,'" + txtvatper.Text + "' ,'" + txtSGSTPer.Text + "' ,'" + txtIGSTPer.Text + "' ,'" + txtvatamt.Text + "' ,'" + txtSGSTAmt.Text + "' ,'" + txtIGSTAmt.Text + "' ,'" + txtNetTotal.Text + "' ,'" + Session["UserName"].ToString() + "' ,'" + Session["mob"].ToString() + "' ,'" + txtnarration.Text + "')");
db.insert("update Enquirydetails set status='" + "close" + "' where supplier='" + drpsupplier.SelectedValue + "'");
lblSuppname.Text = drpsupplier.SelectedItem.ToString();
lblenno.Text = drpenquiry.SelectedItem.ToString();
// lblnarration.Text = txtnarration.Text;
lblsuppadd.Text = db.getDbstatus_Value("select Address from SuplierMaster where SuplierName='" + drpsupplier.SelectedValue + "' ");
lblsuppcontact.Text = db.getDbstatus_Value("select MobileNo from SuplierMaster where SuplierName='" + drpsupplier.SelectedValue + "' ");
clear();
ScriptManager.RegisterStartupScript(this, this.GetType(), "PrintAftersave", "PrintAftersave();", true);
GrdRequisition.DataSource = "";
GrdRequisition.DataBind();
ReportGrid.DataSource = db.Displaygrid(" select enqid as ENQ_No , id as #, supplier as Supplier from supplierenquirydetails order by id desc");
ReportGrid.DataBind();
bindsupplier();
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Record Save Succesfully ');", true);
// Response.Write(" ");
}
protected void ReportGrid_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
switch (e.CommandName)
{
case ("Delete"):
{
ViewState["DeleteID"] = Convert.ToInt32(e.CommandArgument);
string enq = db.getDbstatus_Value("select enno from enquirymaster where id='" + ViewState["DeleteID"] + "' ");
string supplier = db.getDbstatus_Value("select supplier from Enquirydetails where enno='" + enq + "'");
db.insert(" delete Enquirydetails where supplier='" + supplier + "' and enno='" + enq + "'");
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertBox", "alert('Record Deleted Successfully ');", true);
}
break;
case ("Select"):
{
string enq = db.getDbstatus_Value("select enno from enquirymaster where id='" + Convert.ToInt32(e.CommandArgument) + "' ");
GridViewRow gvr = (GridViewRow)((Control)e.CommandSource).NamingContainer;
int rowIndex = gvr.RowIndex;
lblenquiryno.Text = enq.ToString();
// int rowIndex = Convert.ToInt32(e.CommandArgument);
GridViewRow row = ReportGrid.Rows[rowIndex];
//Fetch value of Country
string supplier = ReportGrid.Rows[rowIndex].Cells[4].Text;
GrdRequisition.DataSource = db.Displaygrid("select itemname as Itemname , particulars as ItemDesc , qty as Qty, reamrk as Remark from Enquirydetails where enno='" + enq + "' and supplier='" + supplier + "' ");
GrdRequisition.DataBind();
DataSet ds = new DataSet();
ds = db.dgv_display("select itemname as Itemname , particulars as ItemDesc , qty as Qty, reamrk as Remark ,supplier from Enquirydetails where enno='" + enq + "' and supplier='" + supplier + "' ");
for (int g = 0; g < ds.Tables[0].Rows.Count; g++)
{
DropDownList ddlItemDescription = GrdRequisition.Rows[g].FindControl("ddlsupplier") as DropDownList;
ddlItemDescription.SelectedValue = ds.Tables[0].Rows[g]["supplier"].ToString();
}
}
break;
case ("Print"):
{
DataTable dt = new DataTable();
ViewState["printid"] = Convert.ToInt32(e.CommandArgument);
GridViewRow gvr = (GridViewRow)((Control)e.CommandSource).NamingContainer;
int rowIndex = gvr.RowIndex;
// int rowIndex = Convert.ToInt32(e.CommandArgument);
GridViewRow row = ReportGrid.Rows[rowIndex];
//Fetch value of Country
string supplier = ReportGrid.Rows[rowIndex].Cells[4].Text;
string enq = db.getDbstatus_Value("select enno from enquirymaster where id='" + ViewState["printid"] + "' ");
grdprint.DataSource = db.Displaygrid("select itemname as Itemname , particulars as Particular , qty as Qty, reamrk as Remark from Enquirydetails where enno='" + enq + "' and supplier='" + supplier + "' ");
grdprint.DataBind();
lblenno.Text = enq.ToString();
lblsuppadd.Text = db.getDbstatus_Value("select Address from SuplierMaster where SuplierName='" + supplier + "' ");
lblsuppcontact.Text = db.getDbstatus_Value("select MobileNo from SuplierMaster where SuplierName='" + supplier + "' ");
lblSuppname.Text = supplier.ToString();
image.ImageUrl = db.getDbstatus_Value("select CLogo from CompanyMaster where CompanyId='" + "1" + "'");
lblcontactperson.Text = db.getDbstatus_Value("select contactname from enquirymaster where id='" + ViewState["printid"] + "' ");
lblcontactno.Text = db.getDbstatus_Value("select contctmob from enquirymaster where id='" + ViewState["printid"] + "' ");
ScriptManager.RegisterStartupScript(this, this.GetType(), "PrintPanel", "PrintPanel();", true);
}
break;
}
}
catch (Exception ex)
{
}
}
protected void drpenquiry_SelectedIndexChanged(object sender, EventArgs e)
{
GrdRequisition.DataSource = db.Displaygrid(" select Enquirydetails.* from Enquirydetails where Enquirydetails.enno ='" + drpenquiry.SelectedValue + "' and Enquirydetails.supplier='" + drpsupplier.SelectedValue + "'");
GrdRequisition.DataBind();
}
