protected void btnimportcancel_Click(object sender, EventArgs e) { CustomProfile profile = CustomProfile.GetProfile(); ImportServiceClient Import = new ImportServiceClient(); Import.DeleteFromtempTable(hdnobject.Value, profile.Personal.UserID); Import.Close(); }
protected void btnback_Click(object sender, EventArgs e) { CustomProfile profile = CustomProfile.GetProfile(); ImportServiceClient Import = new ImportServiceClient(); Import.DeleteFromtempTable(hdnobject.Value, profile.Personal.UserID); pnlvalidate.Visible = false; pnlImport.Visible = true; btnnext.Enabled = true; Import.Close(); }
protected void btnnext_Click(object sender, EventArgs e) { CustomProfile profile = CustomProfile.GetProfile(); ImportServiceClient Import = new ImportServiceClient(); DataSet DSInsert = new DataSet(); pnlImport.Visible = false; pnlvalidate.Visible = false; pnlfinish.Visible = true; DSInsert = (DataSet)Session["ImportValues"]; long Result = Import.InsertImportLocation(hdnobject.Value, profile.Personal.UserID, profile.Personal.CompanyID, DSInsert); Import.DeleteFromtempTable(hdnobject.Value, profile.Personal.UserID); Import.Close(); }
protected void btnUploadPo_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); DataSet ImportData = new DataSet(); string connString = ""; CustomProfile profile = CustomProfile.GetProfile(); ImportServiceClient Import = new ImportServiceClient(); Import.DeleteFromtempTable(hdnobject.Value, profile.Personal.UserID); Import.Close(); string path = FileuploadPO.PostedFile.FileName; string strFileType = System.IO.Path.GetExtension(path).ToString().ToLower(); string Fullpath = Server.MapPath("../CommonControls/ImportFiles/" + path); // string Fullpath = "https://testoms.gwclogistics.com/GWCTestVersion2/PowerOnRent/OrderImport/1DirectOrderImportTest.xlsx"; FileuploadPO.PostedFile.SaveAs(Server.MapPath("../CommonControls/ImportFiles/" + path)); if (strFileType.Trim() == ".xls") { connString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Fullpath + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\""; } else if (strFileType.Trim() == ".xlsx") { connString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Fullpath + ";Extended Properties='Excel 8.0;HDR=Yes'"; } OleDbConnection excelConnection = new OleDbConnection(connString); OleDbCommand cmd1 = new OleDbCommand("Select * from [Sheet1$]", excelConnection); OleDbDataAdapter oda = new OleDbDataAdapter(); excelConnection.Open(); oda.SelectCommand = cmd1; oda.Fill(ImportData); Session.Add("ImportValues", ImportData); excelConnection.Close(); btnimpnext.Enabled = true; btnimpnext.CssClass = "class2"; //btnimportNext.Enabled = true; //btnimportNext.CssClass = "class2"; uploadMessage.Visible = true; lblmessagesuccess.Visible = true; }