public static Comn_FileType GetComn_FileTypeByID(int id)
{
Comn_FileType comn_FileType = new Comn_FileType();
SqlComn_FileTypeProvider sqlComn_FileTypeProvider = new SqlComn_FileTypeProvider();
comn_FileType = sqlComn_FileTypeProvider.GetComn_FileTypeByID(id);
return(comn_FileType);
}
public int InsertComn_FileType(Comn_FileType comn_FileType)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("IEB_InsertComn_FileType", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Comn_FileTypeID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@Comn_FileTypeName", SqlDbType.NVarChar).Value = comn_FileType.Comn_FileTypeName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@Comn_FileTypeID"].Value);
}
}
public bool UpdateComn_FileType(Comn_FileType comn_FileType)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("IEB_UpdateComn_FileType", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Comn_FileTypeID", SqlDbType.Int).Value = comn_FileType.Comn_FileTypeID;
cmd.Parameters.Add("@Comn_FileTypeName", SqlDbType.NVarChar).Value = comn_FileType.Comn_FileTypeName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public Comn_FileType GetComn_FileTypeFromReader(IDataReader reader)
{
try
{
Comn_FileType comn_FileType = new Comn_FileType
(
(int)reader["Comn_FileTypeID"],
reader["Comn_FileTypeName"].ToString()
);
return(comn_FileType);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateComn_FileType(Comn_FileType comn_FileType)
{
SqlComn_FileTypeProvider sqlComn_FileTypeProvider = new SqlComn_FileTypeProvider();
return(sqlComn_FileTypeProvider.UpdateComn_FileType(comn_FileType));
}
public static int InsertComn_FileType(Comn_FileType comn_FileType)
{
SqlComn_FileTypeProvider sqlComn_FileTypeProvider = new SqlComn_FileTypeProvider();
return(sqlComn_FileTypeProvider.InsertComn_FileType(comn_FileType));
}
