public static Comn_Office GetComn_OfficeByID(int id) { Comn_Office comn_Office = new Comn_Office(); SqlComn_OfficeProvider sqlComn_OfficeProvider = new SqlComn_OfficeProvider(); comn_Office = sqlComn_OfficeProvider.GetComn_OfficeByID(id); return(comn_Office); }
public bool UpdateComn_Office(Comn_Office comn_Office) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("IEB_UpdateComn_Office", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Comn_OfficeID", SqlDbType.Int).Value = comn_Office.Comn_OfficeID; cmd.Parameters.Add("@Comn_OfficeName", SqlDbType.NVarChar).Value = comn_Office.Comn_OfficeName; cmd.Parameters.Add("@Comm_OfficeTypeID", SqlDbType.Int).Value = comn_Office.Comm_OfficeTypeID; cmd.Parameters.Add("@UpperLabelOfficeID", SqlDbType.Int).Value = comn_Office.UpperLabelOfficeID; cmd.Parameters.Add("@Website", SqlDbType.NVarChar).Value = comn_Office.Website; cmd.Parameters.Add("@Phone", SqlDbType.NVarChar).Value = comn_Office.Phone; cmd.Parameters.Add("@Fax", SqlDbType.NVarChar).Value = comn_Office.Fax; cmd.Parameters.Add("@Details", SqlDbType.NText).Value = comn_Office.Details; connection.Open(); int result = cmd.ExecuteNonQuery(); return(result == 1); } }
public Comn_Office GetComn_OfficeFromReader(IDataReader reader) { try { Comn_Office comn_Office = new Comn_Office ( (int)reader["Comn_OfficeID"], reader["Comn_OfficeName"].ToString(), (int)reader["Comm_OfficeTypeID"], (int)reader["UpperLabelOfficeID"], reader["Website"].ToString(), reader["Phone"].ToString(), reader["Fax"].ToString(), reader["Details"].ToString() ); return(comn_Office); } catch (Exception ex) { return(null); } }
public static bool UpdateComn_Office(Comn_Office comn_Office) { SqlComn_OfficeProvider sqlComn_OfficeProvider = new SqlComn_OfficeProvider(); return(sqlComn_OfficeProvider.UpdateComn_Office(comn_Office)); }
public static int InsertComn_Office(Comn_Office comn_Office) { SqlComn_OfficeProvider sqlComn_OfficeProvider = new SqlComn_OfficeProvider(); return(sqlComn_OfficeProvider.InsertComn_Office(comn_Office)); }