public void InsertUpdate(MLTipoAgua ML) { try { dbSmartSysDataContext dbContext = new dbSmartSysDataContext(); var Ag = (from t in dbContext.TipoAguas where t.CodTipoAgua == ML.CodTipoAgua select t).SingleOrDefault(); if (Ag == null) { TipoAgua dbAg = new TipoAgua(); dbAg.CodTipoAgua = ML.CodTipoAgua; dbAg.TipoAgua1 = ML.TipoAgua; dbContext.TipoAguas.InsertOnSubmit(dbAg); dbContext.TipoAguas.Context.SubmitChanges(); } else { Ag.TipoAgua1 = ML.TipoAgua; dbContext.TipoAguas.Context.SubmitChanges(); } } catch (Exception ex) { throw ex; } }
public List<MLTipoAgua> List() { List<MLTipoAgua> list = new List<MLTipoAgua>(); SqlDataReader objSqlDataReader; SqlCommand objSqlCommand = new SqlCommand("USP_TIPOAGUA", OpenConnection()); objSqlCommand.CommandType = CommandType.StoredProcedure; if (objSqlCommand.Connection.State != ConnectionState.Open) objSqlCommand.Connection.Open(); objSqlDataReader = objSqlCommand.ExecuteReader(); while (objSqlDataReader.Read()) { MLTipoAgua ML = new MLTipoAgua(); ML.FromDataReader(objSqlDataReader); list.Add(ML); } objSqlCommand.Connection.Close(); return list; }
public void Delete(MLTipoAgua ML) { StringBuilder sb = new StringBuilder(); sb.Append("DELETE FROM ").Append(tblTipoAgua).Append(" WHERE CodTipoAgua = ").Append(ML.CodTipoAgua); try { exCommand(sb.ToString()); } catch (Exception ex) { throw ex; } }