public DataSet getMacRecords(BL_Machine objBL_Mac)
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_Machine", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Mode", SqlDbType.NVarChar, 100).Value = objBL_Mac.Mode;
DataSet ds1 = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds1);
return(ds1);
}
catch (Exception ex)
{
return(null);
}
}
public int BulkInsert(BL_Machine objBL_Mac)
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_Machine", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Mode", SqlDbType.NVarChar, 100).Value = objBL_Mac.Mode;
cmd.Parameters.Add("@ByExcel", SqlDbType.NVarChar, 8000).Value = objBL_Mac.ByExcel;
int res = cmd.ExecuteNonQuery();
return(res);
con.Close();
}
catch (Exception ex)
{
return(0);
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
try
{
objBL_Mac = new BL_Machine();
objDL_Mac = new DL_Machine();
string FullPath = Server.MapPath(FileUpload1.FileName);
string MyPath = System.IO.Path.GetDirectoryName(FullPath);
string myFilename = System.IO.Path.GetFileName(FullPath);
string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FullPath +
";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
int SQlResult = objDL_Mac.BulkInsert(objBL_Mac);
string query = "SELECT [Partno] FROM [Sheet1$]";
OleDbConnection conn = new OleDbConnection(connString);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
OleDbCommand cmd = new OleDbCommand(query, conn);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
objBL_Mac.Mode = "ExcelUpload";
objBL_Mac.ByExcel = ds.GetXml();
grdMac.DataSource = ds.Tables[0];
grdMac.DataBind();
da.Dispose();
conn.Close();
conn.Dispose();
}
catch (Exception ex)
{
}
finally
{
}
}
public DataSet BulkInsert1(BL_Machine objBL_Mac)
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_Machine1", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Mode", SqlDbType.NVarChar, 100).Value = objBL_Mac.Mode;
cmd.Parameters.Add("@ByExcel", SqlDbType.NVarChar, 8000).Value = objBL_Mac.ByExcel;
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adp.Fill(ds);
//int res = cmd.ExecuteNonQuery();
return(ds);
con.Close();
}
catch (Exception ex)
{
return(null);
}
}
