public IEnumerable <UtilityDTO> FindAll(int start, int end)
{
string query = "select power, vreme from uproduction " +
"where vreme >= :s and vreme <= :e " +
"order by vreme asc";
List <UtilityDTO> consumerList = new List <UtilityDTO>();
using (IDbConnection connection = ConnectionUtil_Pooling.GetConnection())
{
connection.Open();
using (IDbCommand command = connection.CreateCommand())
{
command.CommandText = query;
ParameterUtil.AddParameter(command, "s", DbType.Int32);
ParameterUtil.AddParameter(command, "e", DbType.Int32);
command.Prepare();
ParameterUtil.SetParameterValue(command, "e", end);
ParameterUtil.SetParameterValue(command, "s", start);
using (IDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
UtilityDTO cons = new UtilityDTO(reader.GetDouble(0), reader.GetInt32(1));
consumerList.Add(cons);
}
}
}
}
return(consumerList);
}
public ActionResult Edit(UtilityDTO utility)
{
if (ModelState.IsValid)
{
utilityService.AddOrUpdate(utility);
return(RedirectToAction("Index"));
}
return(View(utility));
}
public ActionResult Delete(int id)
{
try
{
UtilityDTO utility = utilityService.Get(id);
utilityService.Delete(utility);
return(Json("OK"));
}
catch { return(Json("Error")); }
}
/// <summary>
/// </summary>
/// <param name="utilityDto"></param>
public void AddUtility(UtilityDTO utilityDto)
{
var utility = new Utility
{
Description = utilityDto.Description,
KmNo = utilityDto.KmNo,
MonthsNo = utilityDto.MonthsNo,
UtilityName = utilityDto.UtilityName
};
_dataAccess.UtilityRepository.Add(utility);
}
/// <summary>
///
/// </summary>
/// <param name="utilityDto"></param>
/// <returns>true sau false</returns>
public bool UpdateUtility(UtilityDTO utilityDto)
{
try
{
_bl.UtilityLogic.UpdateUtility(utilityDto);
return(true);
}
catch
{
return(false);
}
}
public ActionResult Edit(int id)
{
UtilityDTO utility = (id == 0) ? new UtilityDTO() : utilityService.Get(id);
ViewBag.Units = new SelectList(unitService.GetAll().Select(u => new SelectListItem {
Value = u.UnitId.ToString(), Text = u.UnitName
}), "Value", "Text",
new SelectListItem {
Value = utility.UnitId.ToString(), Text = utility.UnitName
});
return(View(utility));
}
/// <summary>
/// </summary>
/// <param name="utilityDto"></param>
public void UpdateUtility(UtilityDTO utilityDto)
{
var utility = new Utility
{
UtilityID = utilityDto.UtilityID,
Description = utilityDto.Description,
KmNo = utilityDto.KmNo,
MonthsNo = utilityDto.MonthsNo,
UtilityName = utilityDto.UtilityName
};
_dataAccess.UtilityRepository.Update(utility);
}
/// <summary>
/// Saves a new Utility or updates an already existing Utility.
/// </summary>
/// <param name="Utility">Utility to be saved or updated.</param>
/// <param name="UtilityId">UtilityId of the Utility creating or updating</param>
/// <returns>UtilityId</returns>
public long SaveUtility(UtilityDTO utilityDTO, string userId)
{
long utilityId = 0;
if (utilityDTO.UtilityId == 0)
{
var utility = new Utility()
{
Amount = utilityDTO.Amount,
Description = utilityDTO.Description,
BranchId = utilityDTO.BranchId,
SectorId = utilityDTO.SectorId,
BatchId = utilityDTO.BatchId,
CreatedOn = DateTime.Now,
TimeStamp = DateTime.Now,
CreatedBy = userId,
Deleted = false,
};
this.UnitOfWork.Get <Utility>().AddNew(utility);
this.UnitOfWork.SaveChanges();
utilityId = utility.UtilityId;
return(utilityId);
}
else
{
var result = this.UnitOfWork.Get <Utility>().AsQueryable()
.FirstOrDefault(e => e.UtilityId == utilityDTO.UtilityId);
if (result != null)
{
result.Amount = utilityDTO.Amount;
result.UpdatedBy = userId;
result.Description = utilityDTO.Description;
result.BatchId = utilityDTO.BatchId;
result.TimeStamp = DateTime.Now;
result.Deleted = utilityDTO.Deleted;
result.BranchId = utilityDTO.BranchId;
result.SectorId = utilityDTO.SectorId;
result.DeletedBy = utilityDTO.DeletedBy;
result.DeletedOn = utilityDTO.DeletedOn;
this.UnitOfWork.Get <Utility>().Update(result);
this.UnitOfWork.SaveChanges();
}
return(utilityDTO.UtilityId);
}
return(utilityId);
}
public HttpResponseMessage Put(UtilityDTO utilityDto)
{
HttpResponseMessage responseMessage;
JSendMessage json;
var response = _utilityModel.UpdateUtility(utilityDto);
if (response)
{
json = new JSendMessage("success", "Utility details successfully updated");
responseMessage = Request.CreateResponse(HttpStatusCode.OK, json);
}
else
{
json = new JSendMessage("fail", "Something bad happened");
responseMessage = Request.CreateResponse(HttpStatusCode.BadRequest, json);
}
return(responseMessage);
}
