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)); }