public ActionResult DeleteSalesById(RecapSalesViewModel viewModel, FormCollection formCollection)
{
_tSalesRepository.DbContext.BeginTransaction();
try
{
_tSalesRepository.DeleteById(formCollection["id"]);
_tSalesRepository.DbContext.CommitChanges();
}
catch (Exception e)
{
_tSalesRepository.DbContext.RollbackTransaction();
return(Content(e.GetBaseException().Message));
}
return(Content("Data Penjualan berhasil dihapus"));
}
public ActionResult ListSalesRecap(string sidx, string sord, int page, int rows)
{
int totalRecords = 0;
IList recaps = _tSalesRepository.GetSalesRecap(sidx, sord, page, rows, ref totalRecords);
IList <RecapSalesViewModel> listResult = new List <RecapSalesViewModel>();
RecapSalesViewModel det = new RecapSalesViewModel();
object[] obj;
for (int i = 0; i < recaps.Count; i++)
{
obj = (object[])recaps[i];
det = new RecapSalesViewModel();
det.SalesDate = Convert.ToDateTime(obj[0]);
det.CountSalesDet = Convert.ToInt32(obj[1]);
listResult.Add(det);
}
int pageSize = rows;
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
var jsonData = new
{
total = totalPages,
page = page,
records = totalRecords,
rows = (
from result in listResult
select new
{
i = result.SalesDate,
cell = new string[] {
result.SalesDate.HasValue?result.SalesDate.Value.ToString(Helper.CommonHelper.DateFormat) : null,
result.SalesDate.HasValue ? result.SalesDate.Value.ToString(Helper.CommonHelper.DateFormat):null,
result.CountSalesDet.HasValue ? result.CountSalesDet.Value.ToString() : null
}
}).ToArray()
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteSales(RecapSalesViewModel viewModel, FormCollection formCollection)
{
DateTime salesDate = Convert.ToDateTime(formCollection["id"]);
_tSalesRepository.DbContext.BeginTransaction();
try
{
_tSalesRepository.DeleteByDate(salesDate);
TResult result = _tResultRepository.GetResultByDate(salesDate);
if (result != null)
{
_tResultRepository.Delete(result);
}
_tSalesRepository.DbContext.CommitChanges();
}
catch (Exception e)
{
_tSalesRepository.DbContext.RollbackTransaction();
return(Content(e.GetBaseException().Message));
}
return(Content("Data Penjualan berhasil dihapus"));
}
