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); } }