/// <summary>
/// insert new row in the table
/// </summary>
/// <param name="businessObject">business object</param>
/// <returns>true of successfully insert</returns>
public Int32 Insert(clsRecognized businessObject)
{
SqlCommand sqlCommand = new SqlCommand();
try
{
MainConnection.Close();
sqlCommand.Dispose();
sqlCommand = new SqlCommand();
sqlCommand.CommandText = "dbo.[sp_Recognized_Temp_Insert]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Connection = MainConnection;
sqlCommand.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ID));
sqlCommand.Parameters.Add(new SqlParameter("@FileName", SqlDbType.NVarChar, 512, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.FileName));
sqlCommand.Parameters.Add(new SqlParameter("@IdRadio", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.IdRadio));
sqlCommand.Parameters.Add(new SqlParameter("@Hour", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Hour));
sqlCommand.Parameters.Add(new SqlParameter("@FingerprintingTime", SqlDbType.DateTime, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.FingerprintingTime));
sqlCommand.Parameters.Add(new SqlParameter("@FingerprintingDetails", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.FingerprintingDetails));
MainConnection.Open();
sqlCommand.ExecuteNonQuery();
businessObject.ID = (int)sqlCommand.Parameters["@ID"].Value;
return(businessObject.ID);
}
catch (Exception ex)
{
businessObject.ID = -1;
return(-1);
//throw new Exception("clsRecognized::Insert::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
protected void btn_Click(object sender, EventArgs e)
{
CultureInfo cinfo = new CultureInfo("it-IT");
clsRecognizedFactory fac = new clsRecognizedFactory();
if (!String.IsNullOrEmpty(hfname.Value))
{
if (IsEnglish(hfname.Value))
{
if (filename.HasFile)
{
string FileName = Path.GetFileName(filename.PostedFile.FileName);
string Extension = Path.GetExtension(filename.PostedFile.FileName);
if (Extension == ".csv")
{
try
{
string FolderPath = Server.MapPath("~/ImportFiles");
if (!Directory.Exists(FolderPath))
{
Directory.CreateDirectory(FolderPath);
}
Guid abc = Guid.NewGuid();
string FilePath = FolderPath + "/" + abc.ToString();
if (System.IO.File.Exists(FilePath))
{
System.IO.File.Delete(FilePath);
}
filename.SaveAs(FilePath);
fac.GetAllRecognizedDelete();
string ReadCSV = File.ReadAllText(FilePath);
foreach (string csvRow in ReadCSV.Split('\n'))
{
if (!string.IsNullOrEmpty(csvRow))
{
string csvFileName = string.Empty;
int IdRadio = 0;
int csvHour = 0;
DateTime FingerprintingTime = DateTime.Now;
string FingerprintingDetails = string.Empty;
string[] xxx = csvRow.ToString().Split('\t');
string item1 = xxx[0];
if (item1 != "\r")
{
if (item1 != null)
{
string[] inner = item1.Split('.');
string Ids = inner[0].Replace(@"\ ", "").Replace(@"""", "");
IdRadio = Convert.ToInt32(Ids);
csvHour = GetInterval(inner[4]);
string DatetimeFor = inner[1] + "-" + inner[2] + "-" + inner[3] + " " + inner[4] + ":" + inner[5] + ":" + inner[6] + ".000";
FingerprintingTime = Convert.ToDateTime(DatetimeFor);
}
csvFileName = xxx[2];
FingerprintingDetails = xxx[3];
clsRecognized recognized = new clsRecognized();
if (csvFileName.EndsWith(".mp3"))
{
recognized.FileName = csvFileName;
}
else
{
recognized.FileName = csvFileName + ".mp3";
}
recognized.IdRadio = IdRadio;
recognized.Hour = csvHour;
recognized.FingerprintingTime = FingerprintingTime;
recognized.FingerprintingDetails = FingerprintingDetails;
try
{
int ID = fac.Insert(recognized);
}
catch (Exception ex)
{
string errorMessage = string.Empty;
}
}
}
}
int pageNumber = Convert.ToInt32(ViewState["PageNumber"]);
int PageSize = 100;
DataSet Recognized = fac.GetAllRecognized(pageNumber, PageSize);
DataTable myDataTable = Recognized.Tables[0]; //Set your DataTable here
ViewState["Count"] = Recognized.Tables[1];
grd.DataSource = myDataTable;
grd.DataBind();
Div1.Style.Add("display", "block");
divBtnSave.Style.Add("display", "block");
}
catch (Exception ex)
{
pnlError.Visible = true;
lblError.Text = ex.Message.ToString();// "Error occured! Please try again later.";
}
}
else
{
pnlError.Visible = true;
lblError.Text = "Upload only csv files.";
}
}
}
else
{
pnlError.Visible = true;
lblError.Text = "File name contains illegal characters";
}
}
else
{
pnlError.Visible = true;
lblError.Text = "Please select a file first";
}
}
