private void ButtonImport_Click(object sender, EventArgs e)
{
Path = string.Empty;
OpenFileDialog GetPath = new OpenFileDialog();
GetPath.Filter = "Excel Files 2007(*.xlsx;)|*.xlsx;";
if (GetPath.ShowDialog() == DialogResult.OK)
{
try
{
if (GetPath.FileName != null)
{
Path = GetPath.FileName;
if (!Bgworker.IsBusy)
{
RetriveTableData TObj = new RetriveTableData();
DGImport.Rows.Clear();
ButtonSave.Enabled = false;
ButtonImport.Enabled = false;
Bgworker.RunWorkerAsync(TObj);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "Information", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void viewunderproductioncs_Load(object sender, EventArgs e)
{
if (!BGworker.IsBusy)
{
RetriveTableData TObj = new RetriveTableData();
DGview.Rows.Clear();
BGworker.RunWorkerAsync(TObj);
}
}
private void Viewtoolingisseu_Load(object sender, EventArgs e)
{
if (!BGworker.IsBusy)
{
RetriveTableData TObj = new RetriveTableData();
//SELECT * FROM ToolingReturnedhistory WHERE ToolingIssue_Yes = 'Yes'
DGview.Rows.Clear();
BGworker.RunWorkerAsync(TObj);
}
}
private void BGworker_ProgressChanged(object sender, ProgressChangedEventArgs e)
{
if (!BGworker.CancellationPending)
{
RetriveTableData Obj = (RetriveTableData)e.UserState;
DGview.Rows.Add(Obj.dateTimeReturned1, Obj.PartNumber1, Obj.ToolingNumber1, Obj.ToolingIssue_Yes1,
Obj.ToolsName1, Obj.ProductFamily1, Obj.ToolsStatus1, Obj.ReturnedQTY1, Obj.Reasonnotcompleted1,
Obj.TechnicianansFeedback1, Obj.Usedby1, Obj.Returnby1);
}
}
private void BGworker_ProgressChanged(object sender, ProgressChangedEventArgs e)
{
if (!BGworker.CancellationPending)
{
RetriveTableData Obj = (RetriveTableData)e.UserState;
DGview.Rows.Add(Obj.DateTimeout1, Obj.PartNumber1, Obj.ToolingNumber1, Obj.Status1,
Obj.ToolsName1, Obj.ProductFamily1, Obj.StorageLocation1, Obj.ActualToolsQty1, Obj.ToolingoutQty1,
Obj.WONumber1, Obj.WOQty1, Obj.Note1, Obj.TakenBy1);
}
}
private void Bgworker_ProgressChanged(object sender, ProgressChangedEventArgs e)
{
if (!Bgworker.CancellationPending)
{
RetriveTableData Obj = (RetriveTableData)e.UserState;
DGImport.Rows.Add(Obj.Collectdata[0].ToString(), Obj.Collectdata[1].ToString().ToUpper(), Obj.Collectdata[2].ToString(), Obj.Collectdata[3].ToString(), Obj.Collectdata[4].ToString(), Obj.Collectdata[5].ToString(), Obj.Collectdata[6].ToString(), Obj.Collectdata[7].ToString(), Obj.Collectdata[8].ToString(), Obj.Collectdata[9].ToString(), Obj.Collectdata[10].ToString(), Obj.Collectdata[11].ToString(), Obj.Collectdata[12].ToString());
DGImport.FirstDisplayedCell = DGImport.Rows[DGImport.Rows.Count - 1].Cells[0];
lblcount.Text = "Proccessing..." + e.ProgressPercentage.ToString() + "%";
Progress_Status.Value = e.ProgressPercentage;
Progress_Status.Update();
}
}
private void Bgworker_DoWork(object sender, DoWorkEventArgs e)
{
RetriveTableData Obj = (RetriveTableData)e.Argument;
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
Excel.Range range;
int RowCnt = 0; int ColCnt = 0;
int Counter = 1; int Coltooling = 13;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(Path, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
range = xlWorkSheet.UsedRange;
for (RowCnt = 2; RowCnt <= range.Rows.Count; RowCnt++) //baris
{
for (ColCnt = 1; ColCnt <= Coltooling; ColCnt++) //kolom
{
if ((string)(range.Cells[RowCnt, ColCnt] as Excel.Range).Text != null)
{
Obj.Collectdata[ColCnt - 1] = (string)(range.Cells[RowCnt, ColCnt] as Excel.Range).Text;
}
else
{
Obj.Collectdata[ColCnt - 1] = "";
}
}
Bgworker.ReportProgress((Int32)Math.Round((double)(Counter++ *100) / (range.Rows.Count - 1)), Obj);
}
xlWorkBook.Close(true, null, null);
xlApp.Quit();
releaseObject(xlWorkSheet);
releaseObject(xlWorkBook);
releaseObject(xlApp);
}
private void BGworker_DoWork(object sender, DoWorkEventArgs e)
{
RetriveTableData Obj = (RetriveTableData)e.Argument;
try
{
SqlConnection connection = new SqlConnection(Mydb.connectionstring);
SqlCommand cmd = new SqlCommand(Querysql, connection);
connection.Open();
using (SqlDataReader Reader = cmd.ExecuteReader())
{
while (Reader.Read())
{
Obj.ToolingNumber1 = Reader["ToolingNumber"].ToString().Trim();
Obj.ToolsName1 = Reader["ToolsName"].ToString().Trim();
Obj.PartNumber1 = Reader["PartNumber"].ToString().Trim();
Obj.ProductFamily1 = Reader["ProductFamily"].ToString().Trim();
Obj.dateTimeReturned1 = Reader["dateTimeReturned"].ToString().Trim();
Obj.Returnby1 = Reader["Returnby"].ToString().Trim();
Obj.ReturnedQTY1 = Reader["ReturnedQTY"].ToString().Trim();
Obj.ToolsStatus1 = Reader["ToolsStatus"].ToString().Trim();
Obj.Reasonnotcompleted1 = Reader["Reasonnotcompleted"].ToString().Trim();
Obj.Usedby1 = Reader["Usedby"].ToString().Trim();
Obj.ToolingIssue_Yes1 = Reader["ToolingIssue_Yes"].ToString().Trim();
Obj.TechnicianansFeedback1 = Reader["TechnicianansFeedback"].ToString().Trim();
Obj.Lifetimeusage1 = Reader["Lifetimeusage"].ToString().Trim();
System.Threading.Thread.Sleep(100);
BGworker.ReportProgress(0, Obj);
}
connection.Close();
}
}
catch (Exception)
{
throw;
}
}
private void BGworker_DoWork(object sender, DoWorkEventArgs e)
{
RetriveTableData Obj = (RetriveTableData)e.Argument;
try
{
SqlConnection connection = new SqlConnection(Mydb.connectionstring);
SqlCommand cmd = new SqlCommand(Querysql, connection);
connection.Open();
using (SqlDataReader Reader = cmd.ExecuteReader())
{
while (Reader.Read())
{
Obj.ToolingNumber1 = Reader["ToolingNumber"].ToString().Trim();
Obj.StorageLocation1 = Reader["StorageLocation"].ToString().Trim();
Obj.ActualToolsQty1 = Reader["ActualToolsQty"].ToString().Trim();
Obj.ToolsName1 = Reader["ToolsName"].ToString().Trim();
Obj.PartNumber1 = Reader["PartNumber"].ToString().Trim();
Obj.ProductFamily1 = Reader["ProductFamily"].ToString().Trim();
Obj.DateTimeout1 = Reader["DateTimeout"].ToString().Trim();
Obj.TakenBy1 = Reader["TakenBy"].ToString().Trim();
Obj.ToolingoutQty1 = Reader["ToolingoutQty"].ToString().Trim();
Obj.WONumber1 = Reader["WONumber"].ToString().Trim();
Obj.WOQty1 = Reader["WOQty"].ToString().Trim();
Obj.Note1 = Reader["Note"].ToString().Trim();
Obj.Status1 = Reader["Status"].ToString().Trim();
System.Threading.Thread.Sleep(100);
BGworker.ReportProgress(0, Obj);
}
connection.Close();
}
}
catch (Exception)
{
throw;
}
}
