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