public int SaveDataInTable(int RadioId, int Interval, decimal Audience, string RadioName, string Semester, string TotalAudience, int FileType)
{
int Status = -1;
try
{
clsAudienceFigureFactory fac = new clsAudienceFigureFactory();
clsAudienceFigure AudienceFigure = new clsAudienceFigure();
AudienceFigure.RadioId = RadioId;
AudienceFigure.Interval = Interval;
AudienceFigure.Audience = Audience;
AudienceFigure.RadioName = RadioName;
AudienceFigure.Semester = Semester;
AudienceFigure.TotalAudience = TotalAudience;
Status = fac.Insert(AudienceFigure, FileType);
}
catch { Status = -1; }
return(Status);
}
/// <summary>
/// insert new row in the table
/// </summary>
/// <param name="businessObject">business object</param>
/// <returns>true of successfully insert</returns>
public Int32 Insert(clsAudienceFigure businessObject, int FileType)
{
int IdRow = -1;
SqlCommand sqlCommand = new SqlCommand();
try
{
MainConnection.Close();
sqlCommand.Dispose();
sqlCommand = new SqlCommand();
if (FileType == 1)
{
sqlCommand.CommandText = "dbo.[sp_AudienceRadio_Insert]";
}
else if (FileType == 2)
{
sqlCommand.CommandText = "dbo.[sp_AudienceFigures_Insert]";
}
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
//sqlCommand.CommandTimeout = 60;
if (FileType == 1)
{
sqlCommand.Parameters.Add(new SqlParameter("@RadioId", SqlDbType.Int, 6, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.RadioId));
sqlCommand.Parameters.Add(new SqlParameter("@Interval", SqlDbType.Int, 6, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Interval));
sqlCommand.Parameters.Add(new SqlParameter("@Audience", SqlDbType.Decimal, 200, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Audience));
}
else if (FileType == 2)
{
sqlCommand.Parameters.Add(new SqlParameter("@RadioId", SqlDbType.Int, 6, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.RadioId));
sqlCommand.Parameters.Add(new SqlParameter("@Interval", SqlDbType.Int, 6, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Interval));
sqlCommand.Parameters.Add(new SqlParameter("@Audience", SqlDbType.Decimal, 200, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Audience));
sqlCommand.Parameters.Add(new SqlParameter("@RadioName", SqlDbType.NVarChar, 200, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.RadioName));
sqlCommand.Parameters.Add(new SqlParameter("@Semester", SqlDbType.NVarChar, 200, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Semester));
sqlCommand.Parameters.Add(new SqlParameter("@TotalAudience", SqlDbType.NVarChar, 200, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.TotalAudience));
}
MainConnection.Open();
sqlCommand.ExecuteNonQuery();
//IdRow = (int)sqlCommand.Parameters["@IdRow"].Value;
IdRow = 1;
return(IdRow);
}
catch (Exception ex)
{
IdRow = -1;
return(-1);
//throw new Exception("clsAudienceFigure::Insert::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
