public string Differences(IncidentCost other)
{
if (this == null || other == null)
{
return(string.Empty);
}
var res = new StringBuilder();
if (this.Description != other.Description)
{
res.Append("Description=>").Append(other.Description).Append(";");
}
if (this.Amount != other.Amount)
{
res.Append("Amount=>").Append(other.Amount).Append(";");
}
if (this.Quantity != other.Quantity)
{
res.Append("Quantity=>").Append(other.Quantity).Append(";");
}
return(res.ToString());
}
public static ReadOnlyCollection <IncidentCost> ByBusinessRiskId(long businessRiskId, int companyId)
{
var res = new List <IncidentCost>();
using (var cmd = new SqlCommand("IndecidentCost_GetByBusinessRiskId"))
{
using (var cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["cns"].ConnectionString))
{
cmd.Connection = cnn;
try
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(DataParameter.Input("@BusinessRiskId", businessRiskId));
cmd.Parameters.Add(DataParameter.Input("@CompanyId", companyId));
cmd.Connection.Open();
using (var rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
var newIncidentCost = new IncidentCost
{
Id = rdr.GetInt64(ColumnsIncidentCostGet.Id),
CompanyId = rdr.GetInt32(ColumnsIncidentCostGet.CompanyId),
IncidentId = rdr.GetInt64(ColumnsIncidentCostGet.IncidentActionId),
BusinessRiskId = businessRiskId,
Description = rdr.GetString(ColumnsIncidentCostGet.Description),
Amount = rdr.GetDecimal(ColumnsIncidentCostGet.Amount),
Quantity = rdr.GetDecimal(ColumnsIncidentCostGet.Quantity),
Responsible = new Employee
{
Id = rdr.GetInt32(ColumnsIncidentCostGet.ResponsibleId),
Name = rdr.GetString(ColumnsIncidentCostGet.ResponsibleName),
LastName = rdr.GetString(ColumnsIncidentCostGet.ResponsibleLastName)
},
Active = rdr.GetBoolean(ColumnsIncidentCostGet.Active)
};
if (!rdr.IsDBNull(ColumnsIncidentCostGet.Date))
{
newIncidentCost.Date = rdr.GetDateTime(ColumnsIncidentCostGet.Date);
}
res.Add(newIncidentCost);
}
}
}
finally
{
if (cmd.Connection.State != ConnectionState.Closed)
{
cmd.Connection.Close();
}
}
}
}
return(new ReadOnlyCollection <IncidentCost>(res));
}