public static int AddnewUser(UserDTO u)
{
// User user = Userconvert.DTOtoDAL(u);
using (SuperGmachEntities db = new SuperGmachEntities()) {
try {
User userDAL = Userconvert.DTOtoDAL(u);
var date = DateTime.Now;
userDAL.joining_date = DateTime.Now;
userDAL.last_Debit_order = date.AddMonths(-1);
userDAL = db.Users.Add(userDAL).Entity;
User_in_fund user_In_Fund = new User_in_fund()
{
balance = 0,
UserId = userDAL.UserId,
FundId = "1",
date_join = DateTime.Now
};
db.UserInFunds.Add(user_In_Fund);
db.SaveChanges();
return(userDAL.UserId);
} catch (Exception e) {
throw new Exception(e.ToString());
}
}
}
public static void SetBankDetails(Bank_details bankDetails)
{
SuperGmachEntities db = new SuperGmachEntities();
var id = Int32.Parse(bankDetails.UserId);
BankDetails bankDetails1 = db.BankDetails.FirstOrDefault(b => b.UserId == id);
bankDetails1.Branch = bankDetails.Brunch;
bankDetails1.Bank = bankDetails.Bank;
bankDetails1.Account = bankDetails.Account;
bankDetails1.owner = bankDetails.Owner;
db.SaveChanges();
}
public static void AddCredit(Crdit credit, int UserID)
{
SuperGmachEntities db = new SuperGmachEntities();
User user = db.Users.FirstOrDefault(u => u.UserId == UserID);
Credit credit1 = db.Credits.FirstOrDefault(c => c.UserId == UserID);
credit1.CVV = credit.CVV.ToString();
credit1.Number = credit.Number.Substring(credit.Number.Length - 4);
credit1.Owner = credit.idOwners;
credit1.UserId = UserID;
db.SaveChanges();
}
public static void AddDeposit(DepositDTO deposit)
{
DB db = new SuperGmachEntities();
try
{
Deposit deposit_DAL = new Deposit();
deposit_DAL = DepositConvert.DTOtoDAL(deposit);
// System.Console.WriteLine(deposit+" DAL/n "+deposit_DAL);
db.Deposits.Add(deposit_DAL);
User user = db.Users.FirstOrDefault();
db.SaveChanges();
user.Scoring = (int)((int)user.Scoring + deposit.Amount * 0.5);
User_in_fund user_In_Fund = db.UserInFunds.FirstOrDefault(u => u.UserId == deposit.UserId && u.FundId == deposit.FundId);
user_In_Fund.balance += deposit.Amount;
FundBL.AddBalance((int)deposit.Amount, deposit.FundId);
db.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
public static int AddnewUser(UserDTO u)
{
// User user = Userconvert.DTOtoDAL(u);
using (SuperGmachEntities db = new SuperGmachEntities()) {
try {
User userDAL = Userconvert.DTOtoDAL(u);
userDAL = db.Users.Add(userDAL).Entity;
db.SaveChanges();
return(userDAL.UserId);
} catch (Exception e) {
throw new Exception(e.ToString());
}
}
}
public static void collectDebit_order(Debit_order debit_Order)
{
SuperGmachEntities db = new SuperGmachEntities();
User user = db.Users.FirstOrDefault(u => u.UserId == debit_Order.UserID);
user.last_Debit_order = DateTime.Now;
Income Debit_order = new Income()
{
Amount = debit_Order.amount,
Date = DateTime.Now,
From = " מנוי " + debit_Order.UserID,
Remarks = "הוראת קבע"
};
db.Incoms.Add(Debit_order);
db.SaveChanges();
}
public static void Update(DepositDetails deposit)
{
DB db = new SuperGmachEntities();
Deposit _deposit = db.Deposits.FirstOrDefault(dep => dep.DepositId == deposit.Id);
if (deposit == null)
{
throw new Exception("deposits not found");
}
else
{
_deposit.Amount = deposit.amount;
_deposit.Date = deposit.date;
_deposit.FundId = deposit.fund_id.ToString();
// _deposit. = deposit.status;
_deposit.Type = deposit.type;
db.SaveChanges();
}
}
public static string AddStatus(Management_statusDTO status)
{
using (SuperGmachEntities db = new SuperGmachEntities())
{
try
{
Management_status s = Mangagment_status_convert.DTOtoDAL(status);
Console.WriteLine(s.NameManagement_status + " " + s.Color);
db.ManagementStatuses.Add(s);
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine("err on add status: " + e.ToString());
return("err on add status: " + e.ToString());
}
return("status add Successfully");
}
}
static public void AddExpenditure(ExpenditureDTO Expenditure)
{
using (SuperGmachEntities db = new SuperGmachEntities())
{
try
{
Expenditure e = ExpenditureConvert.TDOtoDAL(Expenditure);
db.Expenditure.Add(e);
//fundId 1 is for the main fund
if (Expenditure.NameStatus == "performed")
{
FundBL.Subtract_Balance(Expenditure.Amount, "1");
}
db.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
}
public static void updateExpenditure(ExpenditureDTO expenditure)
{
using (SuperGmachEntities db = new SuperGmachEntities())
{
try
{
Expenditure update_expenditure = db.Expenditure.FirstOrDefault(e => e.Id == expenditure.Id);
if (update_expenditure != null)
{
update_expenditure.Amount = expenditure.Amount;
update_expenditure.Date = expenditure.Date;
//update_expenditure.future_date = expenditure.future_date;
update_expenditure.Purpose = expenditure.Purpose;
update_expenditure.Receives = expenditure.Receives;
///chack if its became performed
if (expenditure.NameStatus != update_expenditure.NameStatus)
{
if (expenditure.NameStatus == "performed")
{
FundBL.Subtract_Balance(expenditure.Amount);
}
else
{
///check if it was performed and change to canceled
if (expenditure.NameStatus == "canceled" && update_expenditure.NameStatus == "performed")
{
FundBL.AddBalance(expenditure.Amount);
}
}
update_expenditure.NameStatus = expenditure.NameStatus;
}
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
}
public static int Edite(UserDTO user)
{
SuperGmachEntities db = new SuperGmachEntities();
User userDal = db.Users.FirstOrDefault(u => u.UserId == user.Id_user);
userDal.father_name = user.Father_name;
userDal.lastname = user.Last_name;
userDal.VIP = user.Vip;
userDal.Status_reason = user.Status_reason;
userDal.frirnd = user.Friend;
userDal.email_addres = user.Communication_ways.Email_addres;
userDal.phon1 = user.Communication_ways.Phon1;
userDal.phon2 = user.Communication_ways.Phon2;
userDal.city = user.Communication_ways.City;
userDal.num_street = user.Communication_ways.Num_street;
userDal.street = user.Communication_ways.Street;
userDal.remarks = user.Remarks;
userDal.MaritalStatus = user.MaritalStatus;
userDal.NameManagement_status = user.NameManagement_status;
db.SaveChanges();
return(userDal.UserId);
}