public static bool UpdateAttributeDbTableFieldRecord(Attribute_Db_Table_Field objAttribute_Db_Table_Field) { bool updateSuccessful = false; if (objAttribute_Db_Table_Field == null) { return(updateSuccessful); } if (objAttribute_Db_Table_Field.Attribute_Id == 0) { return(updateSuccessful); } if (string.IsNullOrEmpty(objAttribute_Db_Table_Field.Attribute_Db) || string.IsNullOrEmpty(objAttribute_Db_Table_Field.Attribute_Table) || string.IsNullOrEmpty(objAttribute_Db_Table_Field.Attribute_Field_Id) || string.IsNullOrEmpty(objAttribute_Db_Table_Field.Attribute_Field_Desc)) { return(updateSuccessful); } string updateString = "UPDATE tblAttribute_Db_Table_Field SET attribute_id = {0}, attribute_database = '{1}', attribute_table = '{2}', attribute_field_id = '{3}', attribute_field_description = '{4}', application_name = '{5}' WHERE attribute_db_table_field_id = {6}"; updateString = string.Format(updateString, objAttribute_Db_Table_Field.Attribute_Id, objAttribute_Db_Table_Field.Attribute_Db, objAttribute_Db_Table_Field.Attribute_Table, objAttribute_Db_Table_Field.Attribute_Field_Id, objAttribute_Db_Table_Field.Attribute_Field_Desc, objAttribute_Db_Table_Field.Application_Name, objAttribute_Db_Table_Field.Attribute_Db_Table_Field_Id); updateSuccessful = Data_Layer.UpdateTypeRecord(updateString, Data_Layer.ltConnectionString); return(updateSuccessful); }
public static Boolean UpdateAttributeRecord(Support_Classes.Attribute objAttribute) { bool updateSuccessful = false; if (objAttribute == null) { return(updateSuccessful); } if (string.IsNullOrEmpty(objAttribute.Attribute_Name)) { return(updateSuccessful); } string updateString = "UPDATE tblAttribute SET attribute_name = '{0}' WHERE attribute_id = {2}"; updateString = string.Format(updateString, objAttribute.Attribute_Name, objAttribute.Attribute_Id); updateSuccessful = Data_Layer.UpdateTypeRecord(updateString, Data_Layer.ltConnectionString); return(updateSuccessful); }