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