public ActionResult Sum()
{
List <SumModel> model = new List <SumModel>();
List <ApplicationUser> users = this.OtherUsers.ToList();
foreach (ApplicationUser appUser in users)
{
IQueryable <Payment> approvedPayments = this.Database.Payments.Where(p => p.Approved);
List <Payment> paymentsToMe = approvedPayments.Where(p => p.PayeeId == this.UserId).ToList();
List <Payment> paymentsFromMe = approvedPayments.Where(p => p.PayerId == this.UserId).ToList();
decimal amount = 0;
foreach (Payment payment in paymentsToMe)
{
amount += payment.Amount;
}
foreach (Payment payment in paymentsFromMe)
{
amount -= payment.Amount;
}
SumModel receiptInfo = new SumModel(appUser.UserName, amount);
model.Add(receiptInfo);
}
return(this.View(model));
}
/// <summary>
/// Megakadályozza, hogy a 3 date közül bármelyik is null értéket kapjon
/// </summary>
/// <param name="setSum"></param>
/// <param name="inputSum"></param>
private void ResolveDateTypeDefaults(SumModel setSum, SumModel inputSum)
{
DateTime?defDate = inputSum.InputDate;
if (defDate == null)
{
defDate = inputSum.AccountDate;
}
if (defDate == null)
{
defDate = inputSum.DueDate;
}
if (defDate == null)
{
throw new Exception("At least one date should be not null.");
}
if (inputSum.InputDate == null)
{
setSum.InputDate = defDate;
}
if (inputSum.AccountDate == null)
{
setSum.AccountDate = defDate;
}
if (inputSum.DueDate == null)
{
setSum.DueDate = defDate;
}
}
public ActionResult DeleteConfirmed(int id)
{
SumModel sumModel = db.SumModels.Find(id);
db.SumModels.Remove(sumModel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//插入例子
public void InsertData(SumModel sum)
{
//var sum = new SumModel() { key = "jack" };
//var studentArray = new SumModel[] { sum };
//sumModel.InsertRange(studentArray);//批量插入
//var id = sumModel.InsertReturnIdentity(sum);//插入返回自增列
sumModel.Insert(sum);//插入
}
public ActionResult Edit([Bind(Include = "Id,costPrice,viewYear,truckAge,salvageValue,totalDep")] SumModel sumModel)
{
if (ModelState.IsValid)
{
db.Entry(sumModel).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sumModel));
}
public IActionResult Index(SumModel sum)
{
if (ModelState.IsValid)
{
sum.Result = _addNumbers.AddNumbers(sum);
return(View(sum));
}
else
{
return(View(sum));
}
}
public ActionResult Create([Bind(Include = "Id,costPrice,viewYear,truckAge,salvageValue,totalDep")] SumModel sumModel)
{
if (ModelState.IsValid)
{
sumModel.salvageValue = sumModel.CalSalvageValue();
sumModel.totalDep = sumModel.CalDepreciation();
db.SumModels.Add(sumModel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sumModel));
}
/// <summary>
/// Metoda aktualizująca wykresy
/// </summary>
private void UpdateModels()
{
var category = _iterations.Count;
var d = CalculateModels(GetStateByIteration(category));
_iterations.Add(new Tuple <int, String>(category, ""));
foreach (var s in GenerateColumns(category, d[0]))
{
var columnSeries = CountModel.Series[0] as ColumnSeries;
if (columnSeries != null)
{
columnSeries.Items.Add(s);
}
}
if (category > 0)
{
foreach (var s in GenerateColumns(category - 1, d[1]))
{
var columnSeries = PointsModel.Series[0] as ColumnSeries;
if (columnSeries != null)
{
columnSeries.Items.Add(s);
}
}
var sum = _sumPoints.ToArray();
double v = sum.Sum();
if (Math.Abs(v) < double.Epsilon * 100)
{
v = 1;
}
sum = sum.Select(k => 100 * k / v).ToArray();
foreach (var s in GenerateColumns(category - 1, sum))
{
var columnSeries = SumModel.Series[0] as ColumnSeries;
if (columnSeries != null)
{
columnSeries.Items.Add(s);
}
}
}
CountModel = CountModel;
PointsModel = PointsModel;
SumModel = SumModel;
CountModel.InvalidatePlot(true);
PointsModel.InvalidatePlot(true);
SumModel.InvalidatePlot(true);
}
// GET: SumModels/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SumModel sumModel = db.SumModels.Find(id);
if (sumModel == null)
{
return(HttpNotFound());
}
return(View(sumModel));
}
//删除例子
public void DeleteData()
{
var student = new SumModel()
{
id = 1, key = "jack"
};
sumModel.Delete(student); //根据实体删除
sumModel.DeleteById(1); //根据主键删除
sumModel.DeleteById(new int[] { 1, 2 }); //根据主键数组删除
sumModel.Delete(it => it.id == 1); //根据条件删除
//支持StudentDb.AsDeleteable()
}
public void Add3And5Returns8()
{
//Arrange
var model = new SumModel()
{
FirstNumber = 3,
SecondNumber = 5
};
//Act
int result = _logic.AddNumbers(model);
//Assert
Assert.AreEqual(8, result);
}
/// <summary>
/// Addition of two numbers
/// </summary>
/// <param name="sum"></param>
/// <returns></returns>
public ActionResult Add(SumModel sum)
{
try
{
int FirstNumber = sum.FirstNumber;
int SecondNumber = sum.SecondNumber;
sum.Result = FirstNumber + SecondNumber;
return(RedirectToAction("Index", sum));
}
catch (Exception ex)
{
HandleError.WriteError(ex);
return(View("Error"));
}
}
//更新例子
public void UpdateDemo()
{
var student = new SumModel()
{
id = 1, key = "jack"
};
var studentArray = new SumModel[] { student };
sumModel.Update(student); //根据实体更新
sumModel.UpdateRange(studentArray); //批量更新
sumModel.Update(it => new SumModel()
{
key = "a", add_date = DateTime.Now.ToString()
}, it => it.id == 1); // 只更新Name列和CreateTime列，其它列不更新，条件id=1
//支持StudentDb.AsUpdateable(student)
}
public bool Delete(int ID)
{
using (DBSHYMONEYV1Context context = new DBSHYMONEYV1Context())
{
SumModel sum = context.Sum.Where(x => x.Id == ID).FirstOrDefault();
if (sum != null)
{
DateTime now = DateTime.Now;
sum.ModifyDate = now;
sum.ModifyBy = tmpUserId;
sum.State = "N";
context.SaveChanges();
return(true);
}
else
{
throw new Exception("Record not found for deletion.");
}
}
}
static void DataStatistics(ConfigModel configModel, DataSumManage sm)
{
string[] path = configModel.Path;
string config_key = configModel.key;
DataSum dataSum = new DataSum();
dataSum.StatFunc(path);
string total = CommonTools.GetSizeStr(dataSum.totalBytes);
string addDate = dataSum.addDate;
string updateDate = dataSum.updateDate;
var dataList = sm.GetListByFilter(addDate, config_key);
int count = dataList.Count;
var sum = new SumModel()
{
key = config_key,
sum = total,
add_date = addDate,
update_date = updateDate,
path = string.Join(",", path)
};
if (count != 0)
{
sum.id = dataList[0].id;
sm.Update(sum);
}
else
{
sm.Insert(sum);
}
Console.WriteLine(addDate);
Console.WriteLine(updateDate);
Console.WriteLine(total);
Console.WriteLine("数据更新成功");
Console.WriteLine("*****************************");
}
/// <summary>
/// Logic to add the numbers
/// </summary>
/// <param name="sum"></param>
/// <returns></returns>
public int AddNumbers(SumModel sum)
{
int res = sum.FirstNumber + sum.SecondNumber;
return(res);
}
/// <summary>
/// Method to get the view
/// </summary>
/// <returns></returns>
public IActionResult Index()
{
SumModel model = new SumModel();
return(View(model));
}
public SumModel SaveGetSum(SumModel p_sum)
{
using (DBSHYMONEYV1Context context = new DBSHYMONEYV1Context())
{
SumModel sum = context.Sum.Where(x => x.Id == p_sum.Id).FirstOrDefault();
DateTime now = DateTime.Now;
if (sum == null)
{
sum = new SumModel()
{
Title = p_sum.Title,
Sum = p_sum.Sum,
AccountDate = p_sum.AccountDate,
InputDate = p_sum.InputDate,
DueDate = p_sum.DueDate,
CreateDate = now,
CreateBy = tmpUserId,
ModifyDate = now,
ModifyBy = tmpUserId,
State = "Y",
IsPayed = "Y"
};
this.ResolveDateTypeDefaults(sum, p_sum);
context.Sum.Add(sum);
}
else
{
List <SumTagConnModel> stcList = context.SumTagConn.Where(x => x.SumId == sum.Id).ToList();
sum.Title = p_sum.Title;
sum.Sum = p_sum.Sum;
sum.ModifyDate = now;
sum.ModifyBy = tmpUserId;
this.ResolveDateTypeDefaults(sum, p_sum);
// remove old tag connections
if (stcList.Count > 0)
{
context.SumTagConn.RemoveRange(stcList);
}
}
// TODO Valamiért elrontja, ha vannak tagek
// add tag connections
if (p_sum.Tags != null)
{
foreach (TagModel tag in p_sum.Tags)
{
context.SumTagConn.Add(new SumTagConnModel()
{
SumId = sum.Id,
TagId = tag.Id
});
}
}
if (context.SaveChanges() >= 1)
{
return(sum);
}
else
{
return(null);
}
}
}
public IActionResult SaveGetSum([FromBody] SumModel SUM)
{
return(Json(repo.SaveGetSum(SUM)));
}
public ActionResult Index(SumModel sum)
{
return(View(sum));
}
