public void InsertUpdate(MLTipoConsumidor ML)
{
try
{
dbSmartSysDataContext dbContext = new dbSmartSysDataContext();
var Con = (from t in dbContext.TipoConsumidors where t.CodTipoConsumidor == ML.CodTipoConsumidor select t).SingleOrDefault();
if (Con == null)
{
TipoConsumidor dbCon = new TipoConsumidor();
dbCon.CodTipoConsumidor = ML.CodTipoConsumidor;
dbCon.TipoConsumidor1 = ML.TipoConsumidor;
dbContext.TipoConsumidors.InsertOnSubmit(dbCon);
dbContext.TipoConsumidors.Context.SubmitChanges();
}
else
{
Con.TipoConsumidor1 = ML.TipoConsumidor;
dbContext.TipoConsumidors.Context.SubmitChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public List<MLTipoConsumidor> List()
{
List<MLTipoConsumidor> list = new List<MLTipoConsumidor>();
SqlDataReader objSqlDataReader;
SqlCommand objSqlCommand = new SqlCommand("USP_TIPOCONSUMIDOR", OpenConnection());
objSqlCommand.CommandType = CommandType.StoredProcedure;
if (objSqlCommand.Connection.State != ConnectionState.Open)
objSqlCommand.Connection.Open();
objSqlDataReader = objSqlCommand.ExecuteReader();
while (objSqlDataReader.Read())
{
MLTipoConsumidor ML = new MLTipoConsumidor();
ML.FromDataReader(objSqlDataReader);
list.Add(ML);
}
objSqlCommand.Connection.Close();
return list;
}
public void Delete(MLTipoConsumidor ML)
{
StringBuilder sb = new StringBuilder();
sb.Append("DELETE FROM ").Append(tblTipoConsumidor).Append(" WHERE CodTipoConsumidor = ").Append(ML.CodTipoConsumidor);
try
{
exCommand(sb.ToString());
}
catch (Exception ex)
{
throw ex;
}
}
