protected int ExecuteNonQuerySQL(string sql, EventsLogModel mE)
{
SqlConnection conn = new SqlConnection(Global.ConnectionString);
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.CommandType = CommandType.Text;
cmd.CommandTimeout = 6000;
try
{
cmd.Connection.Open();
cmd.ExecuteNonQuery();
#region Gan gia tri cho EventsLog
PropertyInfo[] propertiesName1 = mE.GetType().GetProperties();
sql = DBUtils.SQLInsert(mE);
object value;
for (int i = 0; i < propertiesName1.Length; i++)
{
value = propertiesName1[i].GetValue(mE, null);
if (!propertiesName1[i].Name.Equals("iD"))
{
if (value != null)
{
cmd.Parameters.Add("@" + propertiesName1[i].Name, DBUtils.ConvertToSQLType(propertiesName1[i].PropertyType)).Value = value;
}
else
{
cmd.Parameters.Add("@" + propertiesName1[i].Name, DBUtils.ConvertToSQLType(propertiesName1[i].PropertyType)).Value = "";
}
}
}
#endregion
cmd.CommandText = sql;
return(cmd.ExecuteNonQuery());
}
catch (SqlException se)
{
throw new FacadeException(se);
}
finally
{
conn.Close();
}
}
protected EventsLogFacade(EventsLogModel model)
: base(model)
{
}
