public void Binddata()
{
DataTable dt = ClsPurchaseOrder.BindSpecialPriceforApprovaldata();
GvSPA.DataSource = dt;
GvSPA.DataBind();
}
private void GetSalesManager()
{
DataTable ds = new DataTable();
try
{
ds = ClsPurchaseOrder.GetPO_ApprovedDetails(Convert.ToDateTime(Txt_FromDate.Text.Trim()), Convert.ToDateTime(Txt_ToDate.Text.Trim()));
if (ds.Rows.Count > 0)
{
GvwSalesRegister.Visible = true;
GvwSalesRegister.DataSource = ds;
GvwSalesRegister.DataBind();
ViewState["Data"] = ds;
ds.Dispose();
if (ViewState["PageINdex"] != null)
{
GvwSalesRegister.PageIndex = Convert.ToInt32(ViewState["PageINdex"].ToString());
}
}
else
{
lblmsg.Text = "NO Data Found...";
GvwSalesRegister.Visible = false;
//ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('NO Data Found...');</script>", false);
}
}
catch (Exception ex)
{
}
}
protected void GvSPA_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Edited")
{
DivSPAInfo.Visible = true;; DivSPAData.Visible = false;
int Id = Convert.ToInt32(e.CommandArgument.ToString());
DataTable dt = ClsPurchaseOrder.GetSpecialPriceforApprovaldata(Id);
lblEndusername.Text = dt.Rows[0]["Enduser_Name"].ToString();
lblResellerName.Text = dt.Rows[0]["Reseller_Name"].ToString();
lblDistributorName.Text = dt.Rows[0]["Distributer_Name"].ToString();
lblSupplier.Text = dt.Rows[0]["Supplier_Name"].ToString();
lblType.Text = dt.Rows[0]["M_CategoryName"].ToString();
lblCategory.Text = dt.Rows[0]["Category_Name"].ToString();
lblProduct.Text = dt.Rows[0]["Product_Name"].ToString();
lblQuantity.Text = dt.Rows[0]["Quantity"].ToString();
txtUPPWOutDcnt_Dstbtrprice.Text = dt.Rows[0]["UPPWOutDcnt_Dstbtrprice"].ToString();
txtUPPWOutDcnt_Rsprice.Text = dt.Rows[0]["UPPWOutDcnt_Rsprice"].ToString();
txtUPPWOutDcnt_EUprice.Text = dt.Rows[0]["UPPWOutDcnt_EUprice"].ToString();
lblCompUPP_Make1.Text = " " + dt.Rows[0]["CompUPP_Make1"].ToString();
lblCompUPP_Model1.Text = " " + dt.Rows[0]["CompUPP_Model1"].ToString();
txtCUPP_Dstbtrprice1.Text = dt.Rows[0]["CUPP_Dstbtrprice1"].ToString();
txtCUPP_Rsprice1.Text = dt.Rows[0]["CUPP_Rsprice1"].ToString();
txtCUPP_Euprice1.Text = dt.Rows[0]["CUPP_Euprice1"].ToString();
lblCompUPP_Make2.Text = dt.Rows[0]["CompUPP_Make2"].ToString();
lblCompUPP_Model2.Text = dt.Rows[0]["CompUPP_Model2"].ToString();
txtCUPP_Dstbtrprice2.Text = dt.Rows[0]["CUPP_Dstbtrprice2"].ToString();
txtCUPP_Rsprice2.Text = dt.Rows[0]["CUPP_Rsprice2"].ToString();
txtCUPP_Euprice2.Text = dt.Rows[0]["CUPP_Euprice2"].ToString();
txtSUPReq_Dstbtrprice.Text = dt.Rows[0]["SUPReq_Dstbtrprice"].ToString();
txtSUPReq_Rsprice.Text = dt.Rows[0]["SUPReq_Rsprice"].ToString();
txtSUPReq_Euprice.Text = dt.Rows[0]["SUPReq_Euprice"].ToString();
txtAUP_Dstbtrprice.Text = dt.Rows[0]["AUP_Dstbtrprice"].ToString();
txtAUP_Rsprice.Text = dt.Rows[0]["AUP_Rsprice"].ToString();
txtAUP_Euprice.Text = dt.Rows[0]["AUP_Euprice"].ToString();
txtVSP_Dstbtrprice.Text = dt.Rows[0]["VSP_Dstbtrprice"].ToString();
txtVSP_Rsprice.Text = dt.Rows[0]["VSP_Rsprice"].ToString();
txtVSP_Euprice.Text = dt.Rows[0]["VSP_Euprice"].ToString();
lblServiceAttach.Text = dt.Rows[0]["ServiceAttach"].ToString();
lblSANumber.Text = dt.Rows[0]["SANumber"].ToString();
lblSAAppended.Text = dt.Rows[0]["SAAppend"].ToString();
ViewState["lblSPAID"] = Id;
//int index = Convert.ToInt32(e.CommandArgument.ToString());
//HiddenField lblSPAID = (HiddenField)GvSPA.Rows[index].FindControl("HDFSPAId");
//Label lblEndUserName1 = (Label)GvSPA.Rows[index].FindControl("lblEndUserName");
//Label lblResellerName1 = (Label)GvSPA.Rows[index].FindControl("lblResellerName");
//Label lblDistributeName1 = (Label)GvSPA.Rows[index].FindControl("lblDistributeName");
//Label lblModel1 = (Label)GvSPA.Rows[index].FindControl("lblModel");
//Label lblCatNo1 = (Label)GvSPA.Rows[index].FindControl("lblCatNo");
//lblEndusername.Text = lblEndUserName1.Text;
//lblResellerName.Text = lblResellerName1.Text;
//lblDistributorName.Text = lblDistributeName1.Text;
//lblProduct.Text = lblModel1.Text + "_" + lblCatNo1.Text;
// ViewState["lblSPAID"] = lblSPAID.Value;
}
}
protected void GvSA_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Edited")
{
DivInf.Visible = true; DivInfDet.Visible = false;
tr3.Visible = false; tr0.Visible = true; tr1.Visible = true; tr2.Visible = true;
int Id = Convert.ToInt32(e.CommandArgument.ToString());
DataTable dt = ClsPurchaseOrder.Usp_GetServiceAttachforApprovaldata(Id);
lblSANO.Text = dt.Rows[0]["SA_Number"].ToString();
lblEndusername.Text = dt.Rows[0]["Enduser_Name"].ToString();
lblResellerName.Text = dt.Rows[0]["Reseller_Name"].ToString();
lblDistributorName.Text = dt.Rows[0]["Distributor_Name"].ToString();
//lblSupplier.Text = dt.Rows[0][""].ToString();
lblType.Text = dt.Rows[0]["Maincategory"].ToString();
lblCatagory.Text = dt.Rows[0]["Category_Name"].ToString();
lblProduct.Text = dt.Rows[0]["Product_Name"].ToString();
lblQuantity.Text = dt.Rows[0]["TotalQuantity"].ToString();
lblperiodStdYear.Text = dt.Rows[0]["TotalPeriod"].ToString();
lblCompetitorname.Text = dt.Rows[0]["Competitor_Name"].ToString();
txtUPSWOutdcntDistributorprice.Text = dt.Rows[0]["UPSWOutDcnt_Dstbtrprice"].ToString();
txtUPSWOutdcntResellerPrice.Text = dt.Rows[0]["UPSWOutDcnt_Rsprice"].ToString();
txtUPSWOutdcntEndUserPrice.Text = dt.Rows[0]["UPSWOutDcnt_Euprice"].ToString();
txtUPSWithdcntDistributorprice.Text = dt.Rows[0]["UPSWDcnt_DstbtrPrice"].ToString();
txtUPSWithdcntResellerPrice.Text = dt.Rows[0]["UPSWDcnt_Rsprice"].ToString();
txtUPSWithdcntEndUserPrice.Text = dt.Rows[0]["UPSWDcnt_Euprice"].ToString();
txtUSAWOutdcntDistributorprice.Text = dt.Rows[0]["USAWOutDcnt_Dstbtrprice"].ToString();
txtUSAWOutdcntResellerPrice.Text = dt.Rows[0]["USAWOutDcnt_Rsprice"].ToString();
txtUSAWOutdcntEndUserPrice.Text = dt.Rows[0]["USAWOutDcnt_Euprice"].ToString();
txtUSAWithdcntDistributorprice.Text = dt.Rows[0]["USAWDcnt_DstbtrPrice"].ToString();
txtUSAWithdcntResellerPrice.Text = dt.Rows[0]["USAWDcnt_Rsprice"].ToString();
txtUSAWithdcntEndUserPrice.Text = dt.Rows[0]["USAWDcnt_Euprice"].ToString();
//int index = Convert.ToInt32(e.CommandArgument.ToString());
//Label lblSANO1 = (Label)GvSA.Rows[index].FindControl("lblSANO");
//Label lblEndUserName1 = (Label)GvSA.Rows[index].FindControl("lblEndUserName");
//Label lblResellerName1 = (Label)GvSA.Rows[index].FindControl("lblResellerName");
//Label lblDistributeName1 = (Label)GvSA.Rows[index].FindControl("lblDistributeName");
//Label lblModel1 = (Label)GvSA.Rows[index].FindControl("lblModel");
//Label lblCatNo1 = (Label)GvSA.Rows[index].FindControl("lblCatNo");
//lblSANO.Text = lblSANO1.Text;
//lblEndusername.Text = lblEndUserName1.Text;
//lblResellerName.Text = lblResellerName1.Text;
//lblDistributorName.Text = lblDistributeName1.Text;
//lblProduct.Text = lblModel1.Text + "_" + lblCatNo1.Text;
//lblDistributorName.Text=
}
}
public void Binddata()
{
DataTable dt = ClsPurchaseOrder.BindServiceAttachApproval();
GvSA.DataSource = dt;
GvSA.DataBind();
if (dt.Rows.Count == 0)
{
lblMessage.Text = "";
ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('No Records Found...');</script>", false);
lblMessage.Text = "No Records Found";
}
else
{
lblMessage.Text = "";
}
}
public void BindSANo()
{
DataTable Dt = ClsPurchaseOrder.GetServiceAttachNumber();
if (Dt.Rows.Count > 0)
{
ddlSANo.Items.Clear();
ddlSANo.DataSource = Dt;
ddlSANo.DataValueField = "id";
ddlSANo.DataTextField = "SA_Number";
ddlSANo.DataBind();
ddlSANo.Items.Insert(0, new ListItem("Select SA Number", "0"));
}
else
{
ddlSANo.Items.Clear();
ddlSANo.Items.Insert(0, new ListItem("Select SA Number", "0"));
}
}
protected void BtnGeneratePO_Click(object sender, EventArgs e)
{
//if (TxtPoDate.Text.Trim() != string.Empty)
//{
ClsPurchaseOrder objClsPur = new ClsPurchaseOrder();
int Id = objClsPur.Generate_PurchaseOrder(Convert.ToInt32(ViewState["POID"].ToString()));
if (Id > 0)
{
tbldate.Visible = true;
Panel2.Visible = true;
ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Purchase Order Generated Successfully....');</script>", false);
GetSalesManager();
Panel1.Visible = false;
}
//}
//else
//{
// ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Not Selected...');</script>", false);
//}
}
protected void btnSubmit_Click(object Sender, EventArgs e)
{
try
{
if (lblSANumber.Text.Trim() != "")
{
DataTable DtSA = ClsPurchaseOrder.GetSADetailsForSPA(lblSANumber.Text.Trim());
if (DtSA.Rows.Count > 0)
{
//string FilePathSave = "";
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Charset = "";
HttpContext.Current.Response.ContentType = "application/msword";
// string strFileName = string.Empty;
string strFileName = "SpecialPriceApprovalSignedDocument-" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".doc";
HttpContext.Current.Response.AddHeader("Content-Disposition", "inline;filename=" + strFileName);
#region SAA Design
StringBuilder strHTMLContent1 = new StringBuilder();
strHTMLContent1.Append("<img src='" + @"E:\CSSProjects\Inventory_VSS_04-May-2017\ImagingTOOL\images\kodac1.png'>".ToString());
// strHTMLContent.Append("< img src = '~/images/kodac.png' visible = 'true' runat = 'server' style = 'width: 75px; height: 41px' />".ToString());
//strHTMLContent.Append("<br>".ToString());
strHTMLContent1.Append(" <h1 title='Heading' align='Center' style='font-family:verdana;font-size:100%;background:#C0C0C0'>SERVICE ATTACH APPROVAL FORM </h1>".ToString());
strHTMLContent1.Append("<br>".ToString());
strHTMLContent1.Append("<table width='100%' border='1' cellpadding='2'>".ToString());
//strHTMLContent.Append("<tr>".ToString());
//strHTMLContent.Append("<td style='width: 100px;background:#99CC00'><b>SERVICE ATTACH APPROVAL FORM</b></td>".ToString());
//strHTMLContent.Append("</tr><br/>".ToString());
strHTMLContent1.Append("<tr>".ToString());
strHTMLContent1.Append("<td colspan='2'>Name of End User </td>".ToString());
strHTMLContent1.Append("<td>" + DtSA.Rows[0]["Enduser_Name"].ToString() + "</td>".ToString());
strHTMLContent1.Append("<td>Name of Reseller</td>".ToString());
strHTMLContent1.Append("<td>" + DtSA.Rows[0]["Reseller_Name"].ToString() + "</td>".ToString());
strHTMLContent1.Append("</tr>".ToString());
strHTMLContent1.Append("<tr>".ToString());
strHTMLContent1.Append("<td colspan='2'>Name of Distributor </td>".ToString());
strHTMLContent1.Append("<td colspan='3'>" + DtSA.Rows[0]["Distributor_Name"].ToString() + "</td>".ToString());
strHTMLContent1.Append("</tr>".ToString());
strHTMLContent1.Append("<tr>".ToString());
strHTMLContent1.Append("<td>Cat No</td>".ToString());
strHTMLContent1.Append("<td>Model </td>".ToString());
strHTMLContent1.Append("<td> Total Quantity </td>".ToString());
strHTMLContent1.Append("<td> Total Period including Standard One year </td>".ToString());
strHTMLContent1.Append("<td> Name of nearest Competitor offering Service Attach </td>".ToString());
strHTMLContent1.Append("</tr>".ToString());
strHTMLContent1.Append("<tr>".ToString());
strHTMLContent1.Append("<td>" + DtSA.Rows[0]["Product_Name"].ToString() + "</td>".ToString());
strHTMLContent1.Append("<td>" + DtSA.Rows[0]["Product_Name"].ToString() + "</td>".ToString());
strHTMLContent1.Append("<td> " + DtSA.Rows[0]["TotalQuantity"].ToString() + " </td>".ToString());
strHTMLContent1.Append("<td>" + DtSA.Rows[0]["TotalPeriod"].ToString() + "</td>".ToString());
strHTMLContent1.Append("<td>" + DtSA.Rows[0]["Competitor_Name"].ToString() + "</td>".ToString());
strHTMLContent1.Append("</tr>".ToString());
strHTMLContent1.Append("<tr>".ToString());
strHTMLContent1.Append("<td colspan='2'></td>".ToString());
strHTMLContent1.Append("<td>Distributor Price(INR) </ td>".ToString());
strHTMLContent1.Append("<td> Reseller Price(INR)</ td>".ToString());
strHTMLContent1.Append("<td> End User Price(INR) </ td>".ToString());
strHTMLContent1.Append("</tr>".ToString());
strHTMLContent1.Append("<tr>".ToString());
strHTMLContent1.Append("<td colspan='2'>Unit Product Sales Price Without Discount</td>".ToString());
strHTMLContent1.Append("<td>" + DtSA.Rows[0]["UPSWOutDcnt_Dstbtrprice"].ToString() + "</ td>".ToString());
strHTMLContent1.Append("<td> " + DtSA.Rows[0]["UPSWOutDcnt_Rsprice"].ToString() + "</ td>".ToString());
strHTMLContent1.Append("<td>" + DtSA.Rows[0]["UPSWOutDcnt_Euprice"].ToString() + "</ td>".ToString());
strHTMLContent1.Append("</tr>".ToString());
strHTMLContent1.Append("<tr>".ToString());
strHTMLContent1.Append("<td colspan='2'>Unit Product Sales Price With Discount</td>".ToString());
strHTMLContent1.Append("<td>" + DtSA.Rows[0]["UPSWDcnt_DstbtrPrice"].ToString() + "</ td>".ToString());
strHTMLContent1.Append("<td> " + DtSA.Rows[0]["UPSWDcnt_Rsprice"].ToString() + "</ td>".ToString());
strHTMLContent1.Append("<td>" + DtSA.Rows[0]["UPSWDcnt_Euprice"].ToString() + "</ td>".ToString());
strHTMLContent1.Append("</tr>".ToString());
strHTMLContent1.Append("<tr>".ToString());
strHTMLContent1.Append("<td colspan='2'>Unit Service Attach Without Discount</td>".ToString());
strHTMLContent1.Append("<td>" + DtSA.Rows[0]["USAWOutDcnt_Dstbtrprice"].ToString() + "</ td>".ToString());
strHTMLContent1.Append("<td> " + DtSA.Rows[0]["USAWOutDcnt_Rsprice"].ToString() + "</ td>".ToString());
strHTMLContent1.Append("<td>" + DtSA.Rows[0]["USAWOutDcnt_Euprice"].ToString() + "</ td>".ToString());
strHTMLContent1.Append("</tr>".ToString());
strHTMLContent1.Append("<tr>".ToString());
strHTMLContent1.Append("<td colspan='2'>Service Attach With Discount</td>".ToString());
strHTMLContent1.Append("<td>" + DtSA.Rows[0]["USAWDcnt_DstbtrPrice"].ToString() + "</ td>".ToString());
strHTMLContent1.Append("<td> " + DtSA.Rows[0]["USAWDcnt_Rsprice"].ToString() + "</ td>".ToString());
strHTMLContent1.Append("<td>" + DtSA.Rows[0]["USAWDcnt_Euprice"].ToString() + "</ td>".ToString());
strHTMLContent1.Append("</tr>".ToString());
strHTMLContent1.Append("</table>".ToString());
strHTMLContent1.Append("<br>".ToString());
//DateTime WDate = Convert.ToDateTime(System.DateTime.Now.ToShortDateString());
//string WarrentyDate = WDate.ToString("dd/MM/yyyy");
string WarrentyDate = "";
if (DtSA.Rows[0]["Warrenty"].ToString() != "")
{
DateTime WDate = Convert.ToDateTime(DtSA.Rows[0]["Warrenty"].ToString());
WarrentyDate = WDate.ToString("dd/MM/yyyy");
}
strHTMLContent1.Append(" Above prices valid for Warranty until (dd/mm/yyyy) :" + WarrentyDate);
strHTMLContent1.Append("<br>".ToString());
strHTMLContent1.Append("<br>".ToString());
strHTMLContent1.Append("<table border='1' width='100%'>".ToString());
strHTMLContent1.Append("<tr>".ToString());
strHTMLContent1.Append("<td>Name</td>".ToString());
strHTMLContent1.Append("<td>(Sales Manager)</ td>".ToString());
strHTMLContent1.Append("<td>(Service Manager)</ td>".ToString());
strHTMLContent1.Append("</tr>".ToString());
strHTMLContent1.Append("<tr>".ToString());
strHTMLContent1.Append("<td>Signature</td>".ToString());
strHTMLContent1.Append("<td></td>".ToString());
strHTMLContent1.Append("<td></td>".ToString());
strHTMLContent1.Append("</tr>".ToString());
strHTMLContent1.Append("<tr>".ToString());
strHTMLContent1.Append("<td>Date</td>".ToString());
strHTMLContent1.Append("<td></td>".ToString());
strHTMLContent1.Append("<td></td>".ToString());
strHTMLContent1.Append("</tr>".ToString());
strHTMLContent1.Append("</table>".ToString());
strHTMLContent1.Append("<br>".ToString());
strHTMLContent1.Append("<p align='Center'> Note : This is dynamically generated word document </p>".ToString());
strHTMLContent1.Append("<br>".ToString());
strHTMLContent1.Append("<br>".ToString());
strHTMLContent1.Append("<br>".ToString());
strHTMLContent1.Append("<br>".ToString());
strHTMLContent1.Append("<br>".ToString());
strHTMLContent1.Append("<br>".ToString());
//strHTMLContent1.Append("<br>".ToString());
#endregion
#region SPA Design
StringBuilder strHTMLContent = new StringBuilder();
strHTMLContent.Append("<img src='" + @"E:\CSSProjects\Inventory_VSS_04-May-2017\ImagingTOOL\images\kodac1.png'>".ToString());
// strHTMLContent.Append("< img src = '~/images/kodac.png' visible = 'true' runat = 'server' style = 'width: 75px; height: 41px' />".ToString());
//strHTMLContent.Append("<br>".ToString());
strHTMLContent.Append("<h1 title='Heading' align='Center' style='font-family:verdana;font-size:100%;background:#C0C0C0'>SPECIAL PRICE APPROVAL FORM </h1>".ToString());
strHTMLContent.Append("<br>".ToString());
strHTMLContent.Append("<table width='100%'>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td align='center'>Special Price Approval No:" + TxtSPA.Text + "</td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("</table>".ToString());
strHTMLContent.Append("<br>".ToString());
strHTMLContent.Append("<table width='100%' border='1' cellpadding='2'>".ToString());
//strHTMLContent.Append("<tr>".ToString());
//strHTMLContent.Append("<td style='width: 100px;background:#99CC00'><b>SERVICE ATTACH APPROVAL FORM</b></td>".ToString());
//strHTMLContent.Append("</tr><br/>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Name of End User </td>".ToString());
strHTMLContent.Append("<td>" + lblEndusername.Text + "</td>".ToString());
strHTMLContent.Append("<td>Name of Reseller</td>".ToString());
strHTMLContent.Append("<td>" + lblResellerName.Text + "</td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td>Name of Distributor </td>".ToString());
strHTMLContent.Append("<td colspan='4'>" + lblDistributorName.Text + "</td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td>Cat No</td>".ToString());
strHTMLContent.Append("<td>Model </td>".ToString());
strHTMLContent.Append("<td>Distributor Price (INR) as per applicable slab* </td>".ToString());
strHTMLContent.Append("<td>Reseller Price (INR) </td>".ToString());
strHTMLContent.Append("<td> End User Price (INR) </td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td>" + lblProduct.Text + "</td>".ToString());
strHTMLContent.Append("<td>" + lblProduct.Text + "</td>".ToString());
strHTMLContent.Append("<td colspan='3'> </td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Unit Product Price without Discount </td>".ToString());
strHTMLContent.Append("<td>" + txtUPPWOutDcnt_Dstbtrprice.Text + "</ td>".ToString());
strHTMLContent.Append("<td> " + txtUPPWOutDcnt_Rsprice.Text + "</ td>".ToString());
strHTMLContent.Append("<td>" + txtUPPWOutDcnt_EUprice.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Quantity </td>".ToString());
strHTMLContent.Append("<td colspan='3'>" + lblQuantity.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Competitor Unit Product Price Quoted </br>Make1:" + lblCompUPP_Make1.Text + "</br>Model1:" + lblCompUPP_Model1.Text + "</td>".ToString());
strHTMLContent.Append("<td>" + txtCUPP_Dstbtrprice1.Text + "</ td>".ToString());
strHTMLContent.Append("<td> " + txtCUPP_Rsprice1.Text + "</ td>".ToString());
strHTMLContent.Append("<td>" + txtCUPP_Euprice1.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Competitor Unit Product Price Quoted </br>Make2:" + lblCompUPP_Make2.Text + "</br>Model2:" + lblCompUPP_Model2.Text + "</td>".ToString());
strHTMLContent.Append("<td>" + txtCUPP_Dstbtrprice2.Text + "</ td>".ToString());
strHTMLContent.Append("<td> " + txtCUPP_Rsprice2.Text + "</ td>".ToString());
strHTMLContent.Append("<td>" + txtCUPP_Euprice2.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Special Unit Product Price Requested </td>".ToString());
strHTMLContent.Append("<td>" + txtSUPReq_Dstbtrprice.Text + "</ td>".ToString());
strHTMLContent.Append("<td> " + txtSUPReq_Rsprice.Text + "</ td>".ToString());
strHTMLContent.Append("<td>" + txtSUPReq_Euprice.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Approved Unit Product Price </td>".ToString());
strHTMLContent.Append("<td>" + txtAUP_Dstbtrprice.Text + "</ td>".ToString());
strHTMLContent.Append("<td> " + txtAUP_Rsprice.Text + "</ td>".ToString());
strHTMLContent.Append("<td>" + txtAUP_Euprice.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>% variation from standard price</td>".ToString());
strHTMLContent.Append("<td>" + txtVSP_Dstbtrprice.Text + "</ td>".ToString());
strHTMLContent.Append("<td> " + txtVSP_Rsprice.Text + "</ td>".ToString());
strHTMLContent.Append("<td>" + txtVSP_Euprice.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Service Attach ? (Y/N)</td>".ToString());
strHTMLContent.Append("<td colspan='3'>" + lblServiceAttach.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Service Attach Approval Form filled and appended? (Y/N)</td>".ToString());
strHTMLContent.Append("<td colspan='3'>" + lblSAAppended.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("</table>".ToString());
#endregion
strHTMLContent.Append("<br>".ToString());
DateTime PoPlacementUntil = Convert.ToDateTime(System.DateTime.Now.ToShortDateString());
string PoPlacementUntilDate = PoPlacementUntil.ToString("dd/MM/yyyy");
strHTMLContent.Append(" Above prices valid for PO placement until (dd/mm/yyyy) :" + PoPlacementUntilDate);
strHTMLContent.Append("<br>".ToString()); strHTMLContent.Append("<br>".ToString());
strHTMLContent.Append("Orders executed at above prices don’t qualify for other additional discounts that are in place.Valid only if accompanied by End Customer Purchase Order copy and subject to maximum quantity mentioned above.".ToString());
strHTMLContent.Append("<br>".ToString());
strHTMLContent.Append("<br>".ToString());
strHTMLContent.Append("<table border='2' width='100%'>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td>Name</td>".ToString());
strHTMLContent.Append("<td>(Kodak Alaris India Pvt Ltd)</ td>".ToString());
strHTMLContent.Append("<td>(Distributor)</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td>Signature</td>".ToString());
strHTMLContent.Append("<td></td>".ToString());
strHTMLContent.Append("<td></td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td>Date</td>".ToString());
strHTMLContent.Append("<td></td>".ToString());
strHTMLContent.Append("<td></td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("</table>".ToString());
strHTMLContent.Append("<br>".ToString());
//StreamWriter sw = File.CreateText(MapPath("myFile.txt"));
//sw.WriteLine( txtFile.Text );
//sw.Close();
// Convert to string
string strFileData = strHTMLContent.ToString() + strHTMLContent1.ToString();
// strFolderValue = @"\\192.168.50.158\Word\SPAApprovalSignedFiles\";
strFolderValue = WebConfigurationManager.AppSettings["SPAApprovalSignedFiles"];
// string strFolderValue = @"D:\CSS Projects\Inventory_VSS_04-May-2017\ImagingTOOL\Word\"; \\192.168.50.158\Word \\192.168.50.158\Word
//System.IO.
// Directory.CreateDirectory(strFolderValue);
DirectoryInfo Folder = new DirectoryInfo(strFolderValue);
string SAFilename = strFileName;
string SAFilePath = strFolderValue.ToString() + strFileName.ToString();
objprop.P_SPAAttachSignedFileName = SAFilename;
objprop.P_SPAAttcahSignedFilePath = SAFilePath;
if (TxtSPA.Text != "")
{
BindPropertice();
int i = objBlPo.UpdateSpecialPriceApprovalwithSignedDocument(objprop, Convert.ToInt32(ViewState["lblSPAID"].ToString()), TxtSPA.Text, 0, "");
if (i > 0)
{
// FileUpload1.SaveAs(strFolderValue + filename);
if (Folder.Exists)
{
if (strFileData != string.Empty)
{
// build the path
string FilePathSave = Folder.ToString() + strFileName;
// if file exist delete and then save again
// else save file
File.WriteAllText(FilePathSave, strFileData); // is supposed to overwrite the file if it is there but doesn't
}
else
{
Response.Write("(Nothing to save)");
}
// If we can't find the folder
}
else
{
Response.Write("Folder [" + strFolderValue + "not found]");
}
// lblMessage.Text = "";
// lblMessage.Text = "Updated Successfully.";
objBlPo.MAIL_FOR_SpecialPriceApprovalSignedDocFile(Convert.ToInt32(ViewState["lblSPAID"].ToString()));
DivSPAInfo.Visible = false; DivSPAData.Visible = true;
// ClearInputs(Page.Controls);
}
}
else
{
lblMessage.Text = "";
lblMessage.Text = "Please enter special price number.";
}
}
}
else
{
#region SPA Design
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Charset = "";
HttpContext.Current.Response.ContentType = "application/msword";
string strFileName = "SpecialPriceApprovalSignedDocument-" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".doc";
HttpContext.Current.Response.AddHeader("Content-Disposition", "inline;filename=" + strFileName);
StringBuilder strHTMLContent = new StringBuilder();
strHTMLContent.Append("<img src='" + @"E:\CSSProjects\Inventory_VSS_04-May-2017\ImagingTOOL\images\kodac1.png'>".ToString());
// strHTMLContent.Append("< img src = '~/images/kodac.png' visible = 'true' runat = 'server' style = 'width: 75px; height: 41px' />".ToString());
//strHTMLContent.Append("<br>".ToString());
strHTMLContent.Append("<h1 title='Heading' align='Center' style='font-family:verdana;font-size:100%;background:#C0C0C0'>SPECIAL PRICE APPROVAL FORM </h1>".ToString());
strHTMLContent.Append("<br>".ToString());
strHTMLContent.Append("<table width='100%'>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td align='center'>Special Price Approval No:" + TxtSPA.Text + "</td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("</table>".ToString());
strHTMLContent.Append("<br>".ToString());
strHTMLContent.Append("<table width='100%' border='1' cellpadding='2'>".ToString());
//strHTMLContent.Append("<tr>".ToString());
//strHTMLContent.Append("<td style='width: 100px;background:#99CC00'><b>SERVICE ATTACH APPROVAL FORM</b></td>".ToString());
//strHTMLContent.Append("</tr><br/>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Name of End User </td>".ToString());
strHTMLContent.Append("<td>" + lblEndusername.Text + "</td>".ToString());
strHTMLContent.Append("<td>Name of Reseller</td>".ToString());
strHTMLContent.Append("<td>" + lblResellerName.Text + "</td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td>Name of Distributor </td>".ToString());
strHTMLContent.Append("<td colspan='4'>" + lblDistributorName.Text + "</td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td>Cat No</td>".ToString());
strHTMLContent.Append("<td>Model </td>".ToString());
strHTMLContent.Append("<td>Distributor Price (INR) as per applicable slab* </td>".ToString());
strHTMLContent.Append("<td>Reseller Price (INR) </td>".ToString());
strHTMLContent.Append("<td> End User Price (INR) </td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td>" + lblProduct.Text + "</td>".ToString());
strHTMLContent.Append("<td>" + lblProduct.Text + "</td>".ToString());
strHTMLContent.Append("<td colspan='3'> </td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Unit Product Price without Discount </td>".ToString());
strHTMLContent.Append("<td>" + txtUPPWOutDcnt_Dstbtrprice.Text + "</ td>".ToString());
strHTMLContent.Append("<td> " + txtUPPWOutDcnt_Rsprice.Text + "</ td>".ToString());
strHTMLContent.Append("<td>" + txtUPPWOutDcnt_EUprice.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Quantity </td>".ToString());
strHTMLContent.Append("<td colspan='3'>" + lblQuantity.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Competitor Unit Product Price Quoted </br>Make1:" + lblCompUPP_Make1.Text + "</br>Model1:" + lblCompUPP_Model1.Text + "</td>".ToString());
strHTMLContent.Append("<td>" + txtCUPP_Dstbtrprice1.Text + "</ td>".ToString());
strHTMLContent.Append("<td> " + txtCUPP_Rsprice1.Text + "</ td>".ToString());
strHTMLContent.Append("<td>" + txtCUPP_Euprice1.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Competitor Unit Product Price Quoted </br>Make2:" + lblCompUPP_Make2.Text + "</br>Model2:" + lblCompUPP_Model2.Text + "</td>".ToString());
strHTMLContent.Append("<td>" + txtCUPP_Dstbtrprice2.Text + "</ td>".ToString());
strHTMLContent.Append("<td> " + txtCUPP_Rsprice2.Text + "</ td>".ToString());
strHTMLContent.Append("<td>" + txtCUPP_Euprice2.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Special Unit Product Price Requested </td>".ToString());
strHTMLContent.Append("<td>" + txtSUPReq_Dstbtrprice.Text + "</ td>".ToString());
strHTMLContent.Append("<td> " + txtSUPReq_Rsprice.Text + "</ td>".ToString());
strHTMLContent.Append("<td>" + txtSUPReq_Euprice.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Approved Unit Product Price </td>".ToString());
strHTMLContent.Append("<td>" + txtAUP_Dstbtrprice.Text + "</ td>".ToString());
strHTMLContent.Append("<td> " + txtAUP_Rsprice.Text + "</ td>".ToString());
strHTMLContent.Append("<td>" + txtAUP_Euprice.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>% variation from standard price</td>".ToString());
strHTMLContent.Append("<td>" + txtVSP_Dstbtrprice.Text + "</ td>".ToString());
strHTMLContent.Append("<td> " + txtVSP_Rsprice.Text + "</ td>".ToString());
strHTMLContent.Append("<td>" + txtVSP_Euprice.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Service Attach ? (Y/N)</td>".ToString());
strHTMLContent.Append("<td colspan='3'>" + lblServiceAttach.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Service Attach Approval Form filled and appended? (Y/N)</td>".ToString());
strHTMLContent.Append("<td colspan='3'>" + lblSAAppended.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("</table>".ToString());
#endregion
strHTMLContent.Append("<br>".ToString());
DateTime PoPlacementUntil = Convert.ToDateTime(System.DateTime.Now.ToShortDateString());
string PoPlacementUntilDate = PoPlacementUntil.ToString("dd/MM/yyyy");
strHTMLContent.Append(" Above prices valid for PO placement until (dd/mm/yyyy) :" + PoPlacementUntilDate);
strHTMLContent.Append("</br>".ToString()); strHTMLContent.Append("</br>".ToString());
strHTMLContent.Append("Orders executed at above prices do not qualify for other additional discounts that are in place.Valid only if accompanied by End Customer Purchase Order copy and subject to maximum quantity mentioned above.".ToString());
strHTMLContent.Append("</br>".ToString());
strHTMLContent.Append("<table border='2' width='100%'>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td>Name</td>".ToString());
strHTMLContent.Append("<td>(Kodak Alaris India Pvt Ltd)</ td>".ToString());
strHTMLContent.Append("<td>(Distributor)</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td>Signature</td>".ToString());
strHTMLContent.Append("<td></td>".ToString());
strHTMLContent.Append("<td></td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td>Date</td>".ToString());
strHTMLContent.Append("<td></td>".ToString());
strHTMLContent.Append("<td></td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("</table>".ToString());
strHTMLContent.Append("<br>".ToString());
strHTMLContent.Append("<p align='Center'> Note : This is dynamically generated word document </p>".ToString());
// Convert to string
string strFileData = strHTMLContent.ToString();
strFolderValue = WebConfigurationManager.AppSettings["SPAApprovalSignedFiles"];
// strFolderValue = @"\\192.168.50.158\Word\SPAApprovalSignedFiles\";
// string strFolderValue = @"D:\CSS Projects\Inventory_VSS_04-May-2017\ImagingTOOL\Word\"; \\192.168.50.158\Word \\192.168.50.158\Word
//System.IO.
// Directory.CreateDirectory(strFolderValue);
DirectoryInfo Folder = new DirectoryInfo(strFolderValue);
//objprop.P_SAFilename = strFileName;
//objprop.P_SAFilepath = strFolderValue.ToString() + strFileName.ToString();
string SAFilename = strFileName;
string SAFilePath = strFolderValue.ToString() + strFileName.ToString();
objprop.P_SPAAttachSignedFileName = SAFilename;
objprop.P_SPAAttcahSignedFilePath = SAFilePath;
if (TxtSPA.Text != "")
{
BindPropertice();
int i = objBlPo.UpdateSpecialPriceApprovalwithSignedDocument(objprop, Convert.ToInt32(ViewState["lblSPAID"].ToString()), TxtSPA.Text, 0, "");
if (i > 0)
{
// FileUpload1.SaveAs(strFolderValue + filename);
if (Folder.Exists)
{
if (strFileData != string.Empty)
{
// build the path
string FilePathSave = Folder.ToString() + strFileName;
// if file exist delete and then save again
// else save file
File.WriteAllText(FilePathSave, strFileData); // is supposed to overwrite the file if it is there but doesn't
}
else
{
Response.Write("(Nothing to save)");
}
// If we can't find the folder
}
else
{
Response.Write("Folder [" + strFolderValue + "not found]");
}
// lblMessage.Text = "";
// lblMessage.Text = "Updated Successfully.";
objBlPo.MAIL_FOR_SpecialPriceApprovalSignedDocFile(Convert.ToInt32(ViewState["lblSPAID"].ToString()));
// btnClear_Click(Sender, e);
DivSPAInfo.Visible = false; DivSPAData.Visible = true;
// ClearInputs(Page.Controls);
Binddata();
}
}
else
{
lblMessage.Text = "";
lblMessage.Text = "Please enter special price number.";
}
}
//if (FileUpload1.HasFile)
//{
// string filename = "";
// string[] allowdFile = { ".docx", ".doc" };
// //Here we are allowing only pdf file so verifying selected file pdf or not
// string FileExt = System.IO.Path.GetExtension(FileUpload1.PostedFile.FileName);
// bool isValidFile = allowdFile.Contains(FileExt);
// if (!isValidFile)
// {
// lblMessage.Text = "Please upload only docx ";
// return;
// }
// else
// {
//filename = Path.GetFileName(FileUpload1.FileName);
//objprop.P_SPAAttachSignedFileName = filename;
//string strFolderValue = @"\\192.168.50.158\Word\SPAApprovalSignedFiles\";
//objprop.P_SPAAttcahSignedFilePath = strFolderValue + filename;
//// string pat = FilePath + "" + filename;
//}
//}
//else
//{
// lblMessage.Text = "Please upload docx file. ";
// return;
//}
}
catch (Exception ex)
{
throw;
}
}
protected void btnSubmit_Click(object Sender, EventArgs e)
{
try
{
//if (FileUpload1.HasFile)
//{
// string filename = "";
// string[] allowdFile = { ".docx", ".doc" };
// //Here we are allowing only pdf file so verifying selected file pdf or not
// string FileExt = System.IO.Path.GetExtension(FileUpload1.PostedFile.FileName);
// bool isValidFile = allowdFile.Contains(FileExt);
// if (!isValidFile)
// {
// lblMessage.Text = "Please upload only docx ";
// return;
// }
// else
// {
string FilePathSave = "";
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Charset = "";
HttpContext.Current.Response.ContentType = "application/msword";
string strFileName = string.Empty;
strFileName = "ServiceAttachApprovalSignedDocument-" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".doc";
HttpContext.Current.Response.AddHeader("Content-Disposition", "inline;filename=" + strFileName);
StringBuilder strHTMLContent = new StringBuilder();
// strHTMLContent.Append("<img src='" + @"E:\CSSProjects\Inventory_VSS_04-May-2017\ImagingTOOL\images\kodac1.png'>".ToString());
strHTMLContent.Append("<img src='" + WebConfigurationManager.AppSettings["kodac1Logo"] + "'>".ToString());
strHTMLContent.Append(" <h1 title='Heading' align='Center' style='font-family:Calibri;font-size:16px;background:#C0C0C0'>SERVICE ATTACH APPROVAL FORM </h1>".ToString());
strHTMLContent.Append("<br>".ToString());
strHTMLContent.Append("<table width='100%' border='2' style='font-family:Calibri;font-size:16px;'>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td rowspan='3' colspan='2'>".ToString());
strHTMLContent.Append("<img src='" + WebConfigurationManager.AppSettings["CentillionLogo"] + "'>".ToString());
//strHTMLContent.Append("<img src='" + @"E:\CSSProjects\Inventory_VSS_04-May-2017\ImagingTOOL\images\logo.jpg'>".ToString());
strHTMLContent.Append(" </td>");
strHTMLContent.Append("<td colspan='2'>Name of End User </td>".ToString());
strHTMLContent.Append("<td>" + lblEndusername.Text + "</td>".ToString());
strHTMLContent.Append("</tr>".ToString());
//strHTMLContent.Append("<tr>".ToString());
//strHTMLContent.Append("<td>Name of Distributor </td>".ToString());
//strHTMLContent.Append("<td colspan='4'>" + txtDistributorName.Text + "</td>".ToString());
//strHTMLContent.Append("</tr>".ToString());
// txtResellerName
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Name of Reseller </td>".ToString());
strHTMLContent.Append("<td>" + lblResellerName.Text + "</td>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Name of Distributor</td>".ToString());
strHTMLContent.Append("<td>" + lblDistributorName.Text + "</td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td>Cat No</td>".ToString());
strHTMLContent.Append("<td>Model </td>".ToString());
strHTMLContent.Append("<td> Total Quantity </td>".ToString());
strHTMLContent.Append("<td> Total Period including Standard One year </td>".ToString());
strHTMLContent.Append("<td> Name of nearest Competitor offering Service Attach </td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td>" + lblProduct.Text + "</td>".ToString());
strHTMLContent.Append("<td>" + lblProduct.Text + "</td>".ToString());
strHTMLContent.Append("<td> " + lblQuantity.Text + " </td>".ToString());
strHTMLContent.Append("<td>" + lblperiodStdYear.Text + "</td>".ToString());
strHTMLContent.Append("<td>" + lblCompetitorname.Text + "</td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'></td>".ToString());
strHTMLContent.Append("<td>Distributor Price(INR) </ td>".ToString());
strHTMLContent.Append("<td> Reseller Price(INR)</ td>".ToString());
strHTMLContent.Append("<td> End User Price(INR) </ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Unit Product Sales Price Without Discount</td>".ToString());
strHTMLContent.Append("<td>" + txtUPSWOutdcntDistributorprice.Text + "</ td>".ToString());
strHTMLContent.Append("<td> " + txtUPSWOutdcntResellerPrice.Text + "</ td>".ToString());
strHTMLContent.Append("<td>" + txtUPSWOutdcntEndUserPrice.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Unit Product Sales Price With Discount</td>".ToString());
strHTMLContent.Append("<td>" + txtUPSWithdcntDistributorprice.Text + "</ td>".ToString());
strHTMLContent.Append("<td> " + txtUPSWithdcntResellerPrice.Text + "</ td>".ToString());
strHTMLContent.Append("<td>" + txtUPSWithdcntEndUserPrice.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Unit Service Attach Without Discount</td>".ToString());
strHTMLContent.Append("<td>" + txtUSAWOutdcntDistributorprice.Text + "</ td>".ToString());
strHTMLContent.Append("<td> " + txtUSAWOutdcntResellerPrice.Text + "</ td>".ToString());
strHTMLContent.Append("<td>" + txtUSAWOutdcntEndUserPrice.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td colspan='2'>Service Attach With Discount</td>".ToString());
strHTMLContent.Append("<td>" + txtUSAWithdcntDistributorprice.Text + "</ td>".ToString());
strHTMLContent.Append("<td> " + txtUSAWithdcntResellerPrice.Text + "</ td>".ToString());
strHTMLContent.Append("<td>" + txtUSAWithdcntEndUserPrice.Text + "</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("</table>".ToString());
strHTMLContent.Append("<br>".ToString());
//DateTime WDate = Convert.ToDateTime(System.DateTime.Now.ToShortDateString());
DateTime WDate = Convert.ToDateTime(TxtWarrantyDate.Text.Trim());
string WarrentyDate = WDate.ToString("dd/MM/yyyy");
strHTMLContent.Append("<label><font face='Calibri' size='3'>Above prices valid for Warranty until (dd/mm/yyyy) :</font></label>" + WarrentyDate);
strHTMLContent.Append("<br>".ToString());
strHTMLContent.Append("<br>".ToString());
strHTMLContent.Append("<table border='2' width='100%' style='font-family:Calibri;font-size:16px;'>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td>Name</td>".ToString());
strHTMLContent.Append("<td>(Sales Manager)</ td>".ToString());
strHTMLContent.Append("<td>(Service Manager)</ td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td>Signature</td>".ToString());
strHTMLContent.Append("<td></td>".ToString());
strHTMLContent.Append("<td></td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("<tr>".ToString());
strHTMLContent.Append("<td>Date</td>".ToString());
strHTMLContent.Append("<td></td>".ToString());
strHTMLContent.Append("<td></td>".ToString());
strHTMLContent.Append("</tr>".ToString());
strHTMLContent.Append("</table>".ToString());
strHTMLContent.Append("<br><br>".ToString());
//strHTMLContent.Append("<p align='Center'> Note : This is dynamically generated word document </p>".ToString());
//StreamWriter sw = File.CreateText(MapPath("myFile.txt"));
//sw.WriteLine( txtFile.Text );
//sw.Close();
// Convert to string
string strFileData = strHTMLContent.ToString();
string strFolderValue = WebConfigurationManager.AppSettings["SAApprovalSignedFiles"];
// string strFolderValue = @"\\192.168.50.158\Word\SAApprovalSignedFiles\";
DirectoryInfo Folder = new DirectoryInfo(strFolderValue);
string SAFilename = strFileName;
string SAFilePath = strFolderValue.ToString() + strFileName.ToString();
objprop.P_UPSWDcnt_DstbtrPrice = Convert.ToDecimal(txtUPSWithdcntDistributorprice.Text);
objprop.P_UPSWDcnt_Euprice = Convert.ToDecimal(txtUPSWithdcntEndUserPrice.Text);
objprop.P_UPSWDcnt_Rsprice = Convert.ToDecimal(txtUPSWithdcntResellerPrice.Text);
objprop.P_UPSWOutDcnt_Dstbtrprice = Convert.ToDecimal(txtUPSWOutdcntDistributorprice.Text);
objprop.P_UPSWOutDcnt_Euprice = Convert.ToDecimal(txtUPSWOutdcntEndUserPrice.Text);
objprop.P_UPSWOutDcnt_Rsprice = Convert.ToDecimal(txtUPSWOutdcntResellerPrice.Text);
objprop.P_USAWDcnt_DstbtrPrice = Convert.ToDecimal(txtUSAWithdcntDistributorprice.Text);
objprop.P_USAWDcnt_Euprice = Convert.ToDecimal(txtUSAWithdcntEndUserPrice.Text);
objprop.P_USAWDcnt_Rsprice = Convert.ToDecimal(txtUSAWithdcntResellerPrice.Text);
objprop.P_USAWOutDcnt_Dstbtrprice = Convert.ToDecimal(txtUSAWOutdcntDistributorprice.Text);
objprop.P_USAWOutDcnt_Euprice = Convert.ToDecimal(txtUSAWOutdcntEndUserPrice.Text);
objprop.P_USAWOutDcnt_Rsprice = Convert.ToDecimal(txtUSAWOutdcntResellerPrice.Text);
objprop.P_SASignedFilename = SAFilename;
objprop.P_SASignedFilePath = SAFilePath;
DateTime?Warrenty;
if (TxtWarrantyDate.Text.Trim() == string.Empty)
{
Warrenty = null;
}
else
{
Warrenty = Convert.ToDateTime(TxtWarrantyDate.Text, System.Globalization.CultureInfo.GetCultureInfo("hi-IN").DateTimeFormat);
}
objprop.P_Warrenty = Warrenty;
//filename = Path.GetFileName(FileUpload1.FileName);
//objprop.P_SASignedFilename = filename;
//string strFolderValue = @"\\192.168.50.158\Word\SAApprovalSignedFiles\";
//objprop.P_SASignedFilePath = strFolderValue + filename;
// string pat = FilePath + "" + filename;
if (ddlSANo.SelectedValue != "0")
{
DataTable dt = ClsPurchaseOrder.CheckExistSA_Number(ddlSANo.SelectedItem.Text);
if (dt.Rows.Count > 0)
{
Session["SANo"] = ddlSANo.SelectedItem.Text.Trim();
Session["SANoValue"] = ddlSANo.SelectedValue;
int i = objClsPo.UpdateServiceAttachApprovalwithSignedDocument(ddlSANo.SelectedItem.Text, objprop);
if (i > 0)
{
//FileUpload1.SaveAs(strFolderValue + filename);
//lblMessage.Text = "";
//lblMessage.Text = "Uploaded Successfully.";
// FileUpload1.SaveAs(strFolderValue + filename);
if (Folder.Exists)
{
if (strFileData != string.Empty)
{
// build the path
FilePathSave = Folder.ToString() + strFileName;
// if file exist delete and then save again
// else save file
File.WriteAllText(FilePathSave, strFileData); // is supposed to overwrite the file if it is there but doesn't
}
else
{
Response.Write("(Nothing to save)");
}
// If we can't find the folder
}
else
{
Response.Write("Folder [" + strFolderValue + "not found]");
}
lblMsg.Text = "";
lblMsg.Text = "Updated Successfully.";
// Clear();
tr3.Visible = true; tr0.Visible = false; tr1.Visible = false; tr2.Visible = false;
BindSANo();
Binddata();
Session["SPAStatus"] = 1;
Response.Redirect("~/SpecialPriceApproval.aspx", true);
}
}
else
{
lblMsg.Text = "";
lblMsg.Text = "Service attach number not exists";
}
}
else if (lblSANO.Text != "")
{
DataTable dt = ClsPurchaseOrder.CheckExistSA_Number(lblSANO.Text.Trim());
if (dt.Rows.Count > 0)
{
Session["SANo"] = lblSANO.Text;
Session["SANoValue"] = dt.Rows[0]["id"].ToString();
int i = objClsPo.UpdateServiceAttachApprovalwithSignedDocument(lblSANO.Text, objprop);
if (i > 0)
{
if (Folder.Exists)
{
if (strFileData != string.Empty)
{
// build the path
FilePathSave = Folder.ToString() + strFileName;
// if file exist delete and then save again
// else save file
File.WriteAllText(FilePathSave, strFileData); // is supposed to overwrite the file if it is there but doesn't
}
else
{
Response.Write("(Nothing to save)");
}
// If we can't find the folder
}
else
{
Response.Write("Folder [" + strFolderValue + "not found]");
}
lblMsg.Text = "";
lblMsg.Text = "Updated Successfully.";
objClsPo.MAIL_FOR_ServiceAttchApprovalForSignedDocFile(lblSANO.Text.Trim());
//lblMessage.Text = "";
//lblMessage.Text = "Uploaded Successfully";
// Clear();
tr3.Visible = true; tr0.Visible = false; tr1.Visible = false; tr2.Visible = false;
BindSANo();
Binddata();
Session["SPAStatus"] = 1;
Response.Redirect("~/SpecialPriceApproval.aspx", true);
}
}
else
{
lblMsg.Text = "";
lblMsg.Text = "Service attach number not exists";
}
}
else
{
lblMsg.Text = "";
lblMsg.Text = "please select Service attach number.";
}
// }
//}
//else
//{
// lblMessage.Text = "Please upload docx file. ";
// return;
//}
}
catch (Exception ex)
{
throw;
}
}
