protected void SaveItemPrice()
{
DataTable dtItemPrice = new DataTable();
dtItemPrice.Columns.Add("pkid", typeof(int));
dtItemPrice.Columns.Add("rate", typeof(decimal));
dtItemPrice.Columns.Add("discount", typeof(decimal));
dtItemPrice.Columns.Add("unit", typeof(string));
dtItemPrice.Columns.Add("supp_remark");
DataRow dr;
foreach (GridViewRow gr in gvContractDetails.Rows)
{
dr = dtItemPrice.NewRow();
dr["pkid"] = Convert.ToInt32(((TextBox)gr.FindControl("txtrate")).ToolTip.Trim());
dr["rate"] = UDFLib.ConvertToDecimal(((TextBox)gr.FindControl("txtrate")).Text.Trim());
dr["discount"] = UDFLib.ConvertToDecimal(((TextBox)gr.FindControl("txtDiscount")).Text.Trim());
dr["unit"] = ((TextBox)gr.FindControl("lbtnUnitsPKg")).Text.Trim();
dtItemPrice.Rows.Add(dr);
}
DataTable dtCharges = new DataTable();
dtCharges.Columns.Add("Currency");
dtCharges.Columns.Add("Truck_Charge");
dtCharges.Columns.Add("Barge_Charge");
dtCharges.Columns.Add("Freight_Charge");
dtCharges.Columns.Add("Pkg_Hld_Charge");
dtCharges.Columns.Add("Other_Charge");
dtCharges.Columns.Add("Vat");
dtCharges.Columns.Add("Discount");
DataRow drCharges = dtCharges.NewRow();
drCharges["Currency"] = UDFLib.ConvertStringToNull(DDLCurrency.SelectedItem.Text.Trim());
drCharges["Truck_Charge"] = UDFLib.ConvertDecimalToNull(txtTruckCharge.Text);
drCharges["Barge_Charge"] = UDFLib.ConvertDecimalToNull(txtBargeCharge.Text);
drCharges["Freight_Charge"] = UDFLib.ConvertDecimalToNull(txtFrieghtCharge.Text);
drCharges["Pkg_Hld_Charge"] = UDFLib.ConvertDecimalToNull(txtPkgCharge.Text);
drCharges["Other_Charge"] = UDFLib.ConvertDecimalToNull(txtOtherCharge.Text);
drCharges["Vat"] = UDFLib.ConvertDecimalToNull(txtVat.Text);
drCharges["Discount"] = UDFLib.ConvertDecimalToNull(txtDiscount.Text);
dtCharges.Rows.Add(drCharges);
if (dtItemPrice.Rows.Count > 0)
{
BLL_PURC_CTP.Upd_Ctp_Items_Price(Convert.ToInt32(Request.QueryString["Quotation_ID"]), dtItemPrice, Convert.ToInt32(Session["userid"].ToString()), isfinalizing, dtCharges);
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
try
{
if (FileUpload1.HasFile)
{
//FileUpload1.
string strLocalPath = FileUpload1.PostedFile.FileName;
string FileName = Path.GetFileName(strLocalPath);
if (Path.GetExtension(FileName).ToUpper() == ".XLS")
{
try
{
FileUpload1.PostedFile.SaveAs(Server.MapPath("TempUpload\\" + FileName));
string strPath = Server.MapPath("TempUpload\\" + FileName).ToString();
//string[] arrfn = FileName.Split('\\');
// string strPath = Server.MapPath("SendRFQ") + "\\" + arrfn[arrfn.Length - 1];
ExlApp = new Microsoft.Office.Interop.Excel.Application();
ExlWrkBook = ExlApp.Workbooks.Open(strPath,
0,
true,
5,
"", "",
true,
Microsoft.Office.Interop.Excel.XlPlatform.xlWindows,
"\t",
false,
false,
0,
true,
1,
0);
ExlWrkSheet = (Microsoft.Office.Interop.Excel.Worksheet)ExlWrkBook.ActiveSheet;
int Quotation_ID = UDFLib.ConvertToInteger(((ExcelNS.Range)ExlWrkSheet.Cells[6, 15]).Value2);
int QuotationIDrow = Convert.ToInt32(hdf_QuotationID.Value);
if (Quotation_ID == QuotationIDrow)
{
DataTable dtCharges = new DataTable();
dtCharges.Columns.Add("Currency");
dtCharges.Columns.Add("Truck_Charge");
dtCharges.Columns.Add("Barge_Charge");
dtCharges.Columns.Add("Freight_Charge");
dtCharges.Columns.Add("Pkg_Hld_Charge");
dtCharges.Columns.Add("Other_Charge");
dtCharges.Columns.Add("Vat");
dtCharges.Columns.Add("Discount");
DataRow drCharges = dtCharges.NewRow();
drCharges["Currency"] = UDFLib.ConvertIntegerToNull(((ExcelNS.Range)ExlWrkSheet.Cells[5, 3]).Value2);
drCharges["Truck_Charge"] = UDFLib.ConvertDecimalToNull(((ExcelNS.Range)ExlWrkSheet.Cells[9, 3]).Value2);
drCharges["Barge_Charge"] = UDFLib.ConvertDecimalToNull(((ExcelNS.Range)ExlWrkSheet.Cells[9, 9]).Value2);
drCharges["Freight_Charge"] = UDFLib.ConvertDecimalToNull(((ExcelNS.Range)ExlWrkSheet.Cells[5, 9]).Value2);
drCharges["Pkg_Hld_Charge"] = UDFLib.ConvertDecimalToNull(((ExcelNS.Range)ExlWrkSheet.Cells[7, 9]).Value2);
drCharges["Other_Charge"] = UDFLib.ConvertDecimalToNull(((ExcelNS.Range)ExlWrkSheet.Cells[8, 9]).Value2);
drCharges["Vat"] = UDFLib.ConvertDecimalToNull(((ExcelNS.Range)ExlWrkSheet.Cells[9, 7]).Value2);
drCharges["Discount"] = UDFLib.ConvertDecimalToNull(((ExcelNS.Range)ExlWrkSheet.Cells[8, 3]).Value2);
dtCharges.Rows.Add(drCharges);
DataTable dtItemPrice = new DataTable();
dtItemPrice.Columns.Add("pkid", typeof(int));
dtItemPrice.Columns.Add("rate", typeof(decimal));
dtItemPrice.Columns.Add("discount", typeof(decimal));
dtItemPrice.Columns.Add("unit", typeof(string));
dtItemPrice.Columns.Add("supp_remark");
DataRow drNew;
int i = 15;
while (((ExcelNS.Range)ExlWrkSheet.Cells[i, 1]).Value2 != null)
{
double value = 0;
if (double.TryParse(((ExcelNS.Range)ExlWrkSheet.Cells[i, 1]).Value2.ToString(), out value))
{
drNew = dtItemPrice.NewRow();
drNew["pkid"] = ((ExcelNS.Range)ExlWrkSheet.Cells[i, 4]).Value2.ToString();
if (((ExcelNS.Range)ExlWrkSheet.Cells[i, 6]).Value2 != null)
{
drNew["unit"] = ((ExcelNS.Range)ExlWrkSheet.Cells[i, 6]).Value2.ToString();
}
else
{
drNew["unit"] = "";
}
if (((ExcelNS.Range)ExlWrkSheet.Cells[i, 8]).Value2 != null)
{
drNew["rate"] = ((ExcelNS.Range)ExlWrkSheet.Cells[i, 8]).Value2.ToString();
}
else
{
drNew["rate"] = "0";
}
if (((ExcelNS.Range)ExlWrkSheet.Cells[i, 9]).Value2 != null)
{
drNew["discount"] = ((ExcelNS.Range)ExlWrkSheet.Cells[i, 9]).Value2.ToString();
}
else
{
drNew["discount"] = "0";
}
if (((ExcelNS.Range)ExlWrkSheet.Cells[i, 12]).Value2 != null)
{
drNew["supp_remark"] = ((ExcelNS.Range)ExlWrkSheet.Cells[i, 12]).Value2.ToString();
}
else
{
drNew["supp_remark"] = "";
}
dtItemPrice.Rows.Add(drNew);
}
i = i + 3;
}
dtItemPrice.AcceptChanges();
if (dtItemPrice.Rows.Count > 0)
{
if (dtItemPrice.Select("rate > 0").Length > 0)
{
BLL_PURC_CTP.Upd_Ctp_Items_Price(Quotation_ID, dtItemPrice, Convert.ToInt32(Session["userid"].ToString()), 1, dtCharges);
BindDataItems();
}
}
}
else
{
}
}
catch { }
finally
{
ExlWrkBook.Close(null, null, null);
//ExlApp.Workbooks.Close();
ExlApp.Quit();
Marshal.ReleaseComObject(ExlApp);
Marshal.ReleaseComObject(ExlWrkSheet);
Marshal.ReleaseComObject(ExlWrkBook);
}
}
else
{
String msg = String.Format("alert('The uploaded file do not belong to the selected supplier');");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msginvalidSupplier", msg, true);
}
}
}
catch (Exception ex)
{
String msg = String.Format("alert('The uploaded file do not belong to the selected supplier');");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg, true);
}
}