public int Update(StatusBookML statusBook, String ConnectionString) { try { int id = 0; StringBuilder Query = new StringBuilder(); Query.AppendFormat("UPDATE {0} ", TableName); Query.AppendLine(" SET "); Query.AppendFormat("name = '{0}'", statusBook.Name); Query.AppendFormat("type = '{0}'", statusBook.Type); Query.AppendFormat("idUserUpdate = {0}", statusBook.IdUserUpdate); Query.AppendLine("dateUpdate = GETDATE()"); Query.AppendFormat("WHERE id={0}", statusBook.Id); SqlConnection Conexion = new SqlConnection(); Conexion.ConnectionString = ConnectionString; Conexion.Open(); SqlCommand cmd2 = new SqlCommand(Query.ToString(), Conexion); id = cmd2.ExecuteNonQuery(); Conexion.Close(); return(id); } catch (Exception ex) { throw new Exception(String.Format("{0}.update: {1}", core, ex)); } }
public int Delete(StatusBookML StatusBook) { try { return(StatusBookDAL.Delete(StatusBook, ConnectionStrings)); } catch (Exception ex) { throw new Exception(String.Format("{0}.Delete: {1}", core, ex)); } }
public int Save(StatusBookML StatusBook) { try { if (StatusBook.Id == 0) { return(StatusBookDAL.Save(StatusBook, ConnectionStrings)); } else { return(StatusBookDAL.Update(StatusBook, ConnectionStrings)); } } catch (Exception ex) { throw new Exception(String.Format("{0}.Save: {1}", core, ex)); } }
public int Save(StatusBookML statusBook, String ConnectionString) { try { int id = 0; StringBuilder Query = new StringBuilder(); Query.AppendFormat("INSERT INTO {0}", TableName); Query.AppendLine("( name,type,_registry,idUserInsert,dateInsert)"); Query.AppendFormat(" VALUES('{0}','{1}',1,{2},GETDATE())", statusBook.Name, statusBook.Type, statusBook.IdUserInsert); SqlConnection Conexion = new SqlConnection(); Conexion.ConnectionString = ConnectionString; Conexion.Open(); SqlCommand cmd2 = new SqlCommand(Query.ToString(), Conexion); id = cmd2.ExecuteNonQuery(); Conexion.Close(); return(id); } catch (Exception ex) { throw new Exception(String.Format("{0}.save : {1}", core, ex)); } }