/***********************************Function to Save Culprit File into Sql Server 2000 using Bulk Copy Method***********************************/
public string SaveCulprit(DataTable dt)
{
string lblMessage = "";
MastersController objCont = new MastersController();
string sConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["connectionString"].ToString();
int Status = 0;
try
{
string strDelete = "Delete from CulpritTemp";
objController.ExecuteQuery(strDelete);
SqlConnection sqlconn = new SqlConnection(sConnectionString);
sqlconn.Open();
SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlconn);
bulkCopy.DestinationTableName = "CulpritTemp";
bulkCopy.WriteToServer(dt);
Status = objCont.SaveCulpritData();
if (Status == 1)
{
//Ask User if the duplicates are to be replaced
//if Yes then delete
Page.RegisterStartupScript("OnBlock", "<script language='javascript'>getStatus('culprit');</script>");
Session.Add("dtculprit", dt);
}
else
{
lblMessage = "File Culprit saved successfully";
}
}
catch(Exception ex)
{
// lblMessage = "File Culprit could not be saved successfully";
string strMessage = ex.Message.ToString();
if (strMessage.Contains("Cannot insert duplicate key in object"))
{
lblMessage = "Cannot insert duplicate values";
}
else
{
lblMessage = "Excel file is not in valid format";
}
}
return lblMessage;
}
