public AccInfo FindAccInfo(int id)
{
AccInfo c = new AccInfo();
while (con.State == ConnectionState.Open)
{
System.Threading.Thread.Sleep(500);
}
con.Open();
MySqlCommand cmd = new MySqlCommand("select * from AccInfo where Id=@id", con);
cmd.Parameters.AddWithValue("@id", id);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
c.Id = Convert.ToInt32(reader["Id"].ToString());
c.Date = reader["Date"].ToString();
c.RequestTo = reader["RequestTo"].ToString();
c.Requestfrom = reader["Requestfrom"].ToString();
c.Kind = reader["Kind"].ToString();
c.Comment = reader["Comment"].ToString();
c.Amount = reader["Amount"].ToString();
c.UserId = reader["UserId"].ToString();
c.Category = reader["Category"].ToString();
c.CheckNum = reader["CheckNum"].ToString();
c.BankName = reader["BankName"].ToString();
c.InvoiceNum = reader["InvoiceNum"].ToString();
c.Enterb = Convert.ToBoolean(Convert.ToInt32(reader["Enterb"].ToString()));
}
con.Close();
return(c);
}
public void UpdateButton(AccInfo acc)
{
try
{
Convert.ToDouble(acc.Amount);
}
catch
{
throw new Exception("The Amount Isn't Available");
}
try
{
if (Convert.ToDateTime(acc.Date) > DateTime.Now)
{
throw new Exception();
}
}
catch
{
throw new Exception("The Date Isn't Available");
}
if (acc.InvoiceNum == "")
{
throw new Exception("The Invoice Isn't Available");
}
AccInfoC infoC = new AccInfoC();
infoC.UpdateAccInfo(acc);
}
public void ProcessRequest(HttpContext context)
{
AccInfo ai = new AccInfo();
string cus_id = context.Request.Params["cusid"].ToString();
SqlParameter[] sp =
{
new SqlParameter("@cus_id", cus_id)
};
DataTable dr = SqlUtils.MSSQLHelper.PrecedureDs("wx_get_creline", sp);
if (dr.Rows.Count > 0)
{
ai.Cus_id = dr.Rows[0][0].ToString();
ai.Cus_name = dr.Rows[0][1].ToString();
ai.Effective_Balance = Math.Round(Convert.ToDecimal(dr.Rows[0][2].ToString()), 2);
ai.Yajin = Math.Round(Convert.ToDecimal(dr.Rows[0][3].ToString()), 2);
ai.Balance = Math.Round(Convert.ToDecimal(dr.Rows[0][4].ToString()), 2);
}
context.Response.ContentType = "text/plain";
UTF8Encoding utf8 = new UTF8Encoding();
string rt = CrytUtils.Common.ObjectToJson <AccInfo>(ai, utf8);
context.Response.Write(JsonConvert.DeserializeObject(rt));
}
/// <summary>
/// 同步金商基本资料信息
/// </summary>
/// <param name="accInfo">同步的金商基本资料数据源</param>
public void SyncAccInfo(DealerAccountInformation accInfo)
{
if (accInfo != null)
{
AccInfo.Sync(accInfo);
}
}
public void Income(AccInfo info)
{
AccountC acc = new AccountC();
Account acc1 = acc.FindAcc(info.RequestTo);
double am = Convert.ToDouble(info.Amount);
double eq = Convert.ToDouble(acc1.Equity);
double ba = Convert.ToDouble(acc1.Balance);
double deb = Convert.ToDouble(acc1.Debt);
double seq = Convert.ToDouble(acc1.Sequity);
double sba = Convert.ToDouble(acc1.SBalance);
double sdeb = Convert.ToDouble(acc1.Sdebt);
seq += am;
sba += am;
if (info.Enterb)
{
eq += am;
ba += am;
}
acc1.Equity = eq.ToString();
acc1.Balance = ba.ToString();
acc1.Debt = deb.ToString();
acc1.Sequity = seq.ToString();
acc1.SBalance = sba.ToString();
acc1.Sdebt = sdeb.ToString();
acc.UpdateAcc(acc1, acc1.AccountNum);
}
public void AddNewAccInfo(AccInfo acc)//create new information of transfernce
{
try
{
if (Convert.ToInt32(acc.Amount) < 0)
{
throw new Exception("Unavailable Amount");
}
}
catch
{
throw new Exception("Unavailable Amount");
}
try
{
if (Convert.ToDateTime(acc.Date) > DateTime.Now)
{
throw new Exception("Unavailable Date");
}
}
catch
{
throw new Exception("Unavailable Date");
}
AccInfoC inter = new AccInfoC();
try
{
inter.AddAccInfo(acc);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public bool InsertAccInfo(AccInfo accInfo)
{
accInfo.AccNo = accInfo.AccNo != default(Guid)? accInfo.AccNo : Guid.NewGuid();
using (var conn = _provider.GetDbConnection())
{
//IDbTransaction transaction = conn.BeginTransaction();
try
{
using (var scope = new TransactionScope())
{
long result = conn.Insert <AccInfo>(accInfo);
if (result == 0)
{
//transaction.Commit();
scope.Complete();
return(result == 0);
}
else
{
//transaction.Rollback();
scope.Dispose();
return(result == 0);
}
}
}
catch (Exception ex)
{
//transaction.Rollback();
return(false);
}
}
}
public void RemoveAccInfo(int id)
{
AccInfoC inter = new AccInfoC();
AccInfo info = new AccInfo();
info = inter.FindAccInfo(id);
info.Amount = -1 * Convert.ToDouble(info.Amount) + "";
if (info.Kind == "Regular")
{
Regular(info);
}
if (info.Kind == "Income")
{
Income(info);
}
if (info.Kind == "Expenses")
{
Expenses(info);
}
if (info.Kind == "Third party")
{
Thirdparty(info);
}
while (con.State == ConnectionState.Open)
{
System.Threading.Thread.Sleep(500);
}
con.Open();
MySqlCommand cmd = new MySqlCommand("DELETE FROM AccInfo WHERE Id = @id", con);
cmd.Parameters.AddWithValue("@id", id);
cmd.ExecuteNonQuery();
con.Close();
}
public static Account From_AccInfo_To_Account(AccInfo accInfo)
{
return(new Account
{
AccNo = accInfo.AccNo,
NewsLetterOn = accInfo.NewsLetterOn,
Premium = accInfo.Premium
});
}
//Method 2: To Display Msg to ask User to check email msg
/*public void displayCheckEmailMsg()
* {
*
* }
*/
public int activateAcc(string username, string activationCode, out String error)
{
AccInfo accInfo = new AccInfo();
accInfo.Username = username;
accInfo.ActivationCode = activationCode;
int result = accInfo.activateAcc(out error);
return(result);
}
public void Thirdparty(AccInfo info)
{
AccountC acc = new AccountC();
Account acc1 = acc.FindAcc(info.Requestfrom);
Account acc2 = acc.FindAcc(info.RequestTo);
if (acc1.AccountNum != "0")
{
double am = Convert.ToDouble(info.Amount);
double eq = Convert.ToDouble(acc1.Equity);
double ba = Convert.ToDouble(acc1.Balance);
double deb = Convert.ToDouble(acc1.Debt);
double seq = Convert.ToDouble(acc1.Sequity);
double sba = Convert.ToDouble(acc1.SBalance);
double sdeb = Convert.ToDouble(acc1.Sdebt);
seq -= am;
if (info.Enterb)
{
eq -= am;
}
acc1.Equity = eq.ToString();
acc1.Balance = ba.ToString();
acc1.Debt = deb.ToString();
acc1.Sequity = seq.ToString();
acc1.SBalance = sba.ToString();
acc1.Sdebt = sdeb.ToString();
acc.UpdateAcc(acc1, acc1.AccountNum);
}
else
{
double am = Convert.ToDouble(info.Amount);
double eq = Convert.ToDouble(acc2.Equity);
double ba = Convert.ToDouble(acc2.Balance);
double deb = Convert.ToDouble(acc2.Debt);
double seq = Convert.ToDouble(acc2.Sequity);
double sba = Convert.ToDouble(acc2.SBalance);
double sdeb = Convert.ToDouble(acc2.Sdebt);
seq += am;
if (info.Enterb)
{
eq += am;
}
acc1.Equity = eq.ToString();
acc1.Balance = ba.ToString();
acc1.Debt = deb.ToString();
acc1.Sequity = seq.ToString();
acc1.SBalance = sba.ToString();
acc1.Sdebt = sdeb.ToString();
acc.UpdateAcc(acc1, acc1.AccountNum);
}
}
public List <AccInfo> ListBelongToBank(string bankNum, string Dfrom, string Dto, string category, string f_twhom)
{
List <AccInfo> l = new List <AccInfo>();
while (con.State == ConnectionState.Open)
{
System.Threading.Thread.Sleep(500);
}
con.Open();
MySqlCommand cmd = new MySqlCommand("select * from AccInfo", con);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
AccInfo c = new AccInfo();
c.Date = reader["Date"].ToString();
c.RequestTo = reader["RequestTo"].ToString();
c.Requestfrom = reader["Requestfrom"].ToString();
c.Category = reader["Category"].ToString();
if (Convert.ToDateTime(c.Date) >= Convert.ToDateTime(Dfrom) && Convert.ToDateTime(c.Date) <= Convert.ToDateTime(Dto))
{
if (c.Category == category || category == "All")
{
if (c.Requestfrom == bankNum || c.RequestTo == bankNum)
{
if (f_twhom == "All" || c.Requestfrom == f_twhom || c.RequestTo == f_twhom)
{
c.Id = Convert.ToInt32(reader["Id"].ToString());
c.Kind = reader["Kind"].ToString();
c.Comment = reader["Comment"].ToString();
c.Amount = reader["Amount"].ToString();
c.UserId = reader["UserId"].ToString();
c.CheckNum = reader["CheckNum"].ToString();
c.BankName = reader["BankName"].ToString();
c.InvoiceNum = reader["InvoiceNum"].ToString();
c.Enterb = Convert.ToBoolean(Convert.ToInt32(reader["Enterb"].ToString()));
l.Add(c);
}
}
}
}
}
con.Close();
return(l);
}
//Method 1 : Calling the AccInfo in the Data Layer to create account
public bool creatAcc(string username, string password, string email, string phoneNum, string securityQns, string securityAns, string activationCode, out String error)
{
AccInfo accInfo = new AccInfo();
// Staff staff = new Staff();
accInfo.Username = username;
accInfo.Password = password;
accInfo.Email = email;
accInfo.PhoneNum = phoneNum;
accInfo.SecurityQns = securityQns;
accInfo.SecurityAns = securityAns;
accInfo.ActivationCode = activationCode;
bool result = accInfo.createAcc(out error);
return(result);
}
public void AddAccInfo(AccInfo info)
{
if (info.Kind == "Regular")
{
Regular(info);
}
if (info.Kind == "Income")
{
Income(info);
}
if (info.Kind == "Expenses")
{
Expenses(info);
}
if (info.Kind == "Third party")
{
Thirdparty(info);
}
//add to DB
info.Id = getID();
while (con.State == ConnectionState.Open)
{
System.Threading.Thread.Sleep(500);
}
con.Open();
string query = "INSERT INTO AccInfo (Id,Kind,Date,Requestfrom,RequestTo,Comment,Amount,UserId,Category,CheckNum,BankName,InvoiceNum,Enterb) VALUES (@Id,@Kind,@Date,@Requestfrom,@RequestTo,@Comment,@Amount,@UserId,@Category,@CheckNum,@BankName,@InvoiceNum,@Enterb)";
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@Id", info.Id);
cmd.Parameters.AddWithValue("@Kind", info.Kind);
cmd.Parameters.AddWithValue("@Date", info.Date);
cmd.Parameters.AddWithValue("@Requestfrom", info.Requestfrom);
cmd.Parameters.AddWithValue("@RequestTo", info.RequestTo);
cmd.Parameters.AddWithValue("@Comment", info.Comment);
cmd.Parameters.AddWithValue("@Amount", info.Amount);
cmd.Parameters.AddWithValue("@UserId", info.UserId);
cmd.Parameters.AddWithValue("@Category", info.Category);
cmd.Parameters.AddWithValue("@CheckNum", info.CheckNum);
cmd.Parameters.AddWithValue("@BankName", info.BankName);
cmd.Parameters.AddWithValue("@InvoiceNum", info.InvoiceNum);
cmd.Parameters.AddWithValue("@Enterb", info.Enterb);
cmd.ExecuteNonQuery();
con.Close();
}
public void UpdateWhenDelete(AccInfo i)
{
while (con.State == ConnectionState.Open)
{
System.Threading.Thread.Sleep(500);
}
con.Open();
string query = "UPDATE AccInfo SET Kind=@kind,Requestfrom=@from,RequestTo=@to WHERE Id=@Id";
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@Id", i.Id);
cmd.Parameters.AddWithValue("@kind", i.Kind);
cmd.Parameters.AddWithValue("@from", i.Requestfrom);
cmd.Parameters.AddWithValue("@to", i.RequestTo);
cmd.ExecuteNonQuery();
con.Close();
}
public void Expenses(AccInfo info)
{
AccountC acc = new AccountC();
Account acc1 = acc.FindAcc(info.Requestfrom);
double am = Convert.ToDouble(info.Amount);
double eq = Convert.ToDouble(acc1.Equity);
double ba = Convert.ToDouble(acc1.Balance);
double deb = Convert.ToDouble(acc1.Debt);
double seq = Convert.ToDouble(acc1.Sequity);
double sba = Convert.ToDouble(acc1.SBalance);
double sdeb = Convert.ToDouble(acc1.Sdebt);
bool creditKind = false;
if (acc1.Kind == "Credit")
{
creditKind = true;
}
if (!creditKind)
{
seq -= am;
sba -= am;
if (info.Enterb)
{
eq -= am;
ba -= am;
}
}
else
{
ba -= am;
}
acc1.Equity = eq.ToString();
acc1.Balance = ba.ToString();
acc1.Debt = deb.ToString();
acc1.Sequity = seq.ToString();
acc1.SBalance = sba.ToString();
acc1.Sdebt = sdeb.ToString();
acc.UpdateAcc(acc1, acc1.AccountNum);
}
public void UpdateAccInfo(AccInfo i)
{
RemoveAccInfo(i.Id);
AddAccInfo(i);
}
public void UpdateAccInfo(AccInfo i)
{
AccInfoC inter = new AccInfoC();
inter.UpdateAccInfo(i);
}
public void Regular(AccInfo info)
{
AccountC acc = new AccountC();
Account acc1 = acc.FindAcc(info.Requestfrom);
Account acc2 = acc.FindAcc(info.RequestTo);
bool needDebt = true;
if (acc1.Kind.Contains("Company") && acc2.Kind.Contains("Company"))// there is not debts betweebn company accounts
{
needDebt = false;
}
bool creditKind = false;
if (acc2.Kind == "Credit")
{
creditKind = true;
}
#region From
string s = info.Amount;
double am = Convert.ToDouble(s);
double eq = Convert.ToDouble(acc1.Equity);
double ba = Convert.ToDouble(acc1.Balance);
double deb = Convert.ToDouble(acc1.Debt);
double seq = Convert.ToDouble(acc1.Sequity);
double sba = Convert.ToDouble(acc1.SBalance);
double sdeb = Convert.ToDouble(acc1.Sdebt);
seq -= am;
sba -= am;
if (needDebt)
{
sdeb += am;
}
if (info.Enterb)
{
eq -= am;
ba -= am;
if (needDebt)
{
deb += am;
}
}
acc1.Equity = eq.ToString();
acc1.Balance = ba.ToString();
acc1.Debt = deb.ToString();
acc1.Sequity = seq.ToString();
acc1.SBalance = sba.ToString();
acc1.Sdebt = sdeb.ToString();
#endregion
#region To
eq = Convert.ToDouble(acc2.Equity);
ba = Convert.ToDouble(acc2.Balance);
deb = Convert.ToDouble(acc2.Debt);
seq = Convert.ToDouble(acc2.Sequity);
sba = Convert.ToDouble(acc2.SBalance);
sdeb = Convert.ToDouble(acc2.Sdebt);
if (!creditKind)
{
seq += am;
sba += am;
if (needDebt)
{
sdeb -= am;
}
if (info.Enterb)
{
eq += am;
ba += am;
if (needDebt)
{
deb -= am;
}
}
}
else
{
sba += am;
if (info.Enterb)
{
ba += am;
}
}
acc2.Equity = eq.ToString();
acc2.Balance = ba.ToString();
acc2.Debt = deb.ToString();
acc2.Sequity = seq.ToString();
acc2.SBalance = sba.ToString();
acc2.Sdebt = sdeb.ToString();
#endregion
acc.UpdateAcc(acc1, acc1.AccountNum);
acc.UpdateAcc(acc2, acc2.AccountNum);
}
/// <summary>
/// 同步金商资料数据（包含基本资料和权限）
/// </summary>
/// <param name="clone">同步数据源</param>
public void Sync(DealerAccount clone)
{
AccInfo.Sync(clone.AccInfo);
Authority.Sync(clone.Authority);
}
/// <summary>
/// 同步客户资料数据
/// </summary>
/// <param name="clone">同步数据源</param>
public void Sync(ClientAccount clone)
{
AccInfo.Sync(clone.AccInfo);
TransactionSettings.Sync(clone.TransactionSettings);
}
public List <AccInfo> FilterAccInfo(string date, string kind, string from, string to, string amount, string enterToBank)
{
List <AccInfo> l = new List <AccInfo>();
while (con.State == ConnectionState.Open)
{
System.Threading.Thread.Sleep(500);
}
con.Open();
MySqlCommand cmd = new MySqlCommand("select * from AccInfo ", con);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
AccInfo c = new AccInfo();
c.Date = reader["Date"].ToString();
c.RequestTo = reader["RequestTo"].ToString();
c.Requestfrom = reader["Requestfrom"].ToString();
c.Kind = reader["Kind"].ToString();
c.Enterb = Convert.ToBoolean(Convert.ToInt32(reader["Enterb"].ToString()));
c.Amount = reader["Amount"].ToString();
if (c.Date == date || date == "")
{
if (c.Kind == kind || kind == "All")
{
if (c.Requestfrom == from || from == "All")
{
if (c.RequestTo == to || to == "All")
{
if (amount == "" || Convert.ToDouble(c.Amount) == Convert.ToDouble(amount))
{
if (Convert.ToBoolean(c.Enterb).ToString() == enterToBank || enterToBank == "All")
{
c.Id = Convert.ToInt32(reader["Id"].ToString());
c.Comment = reader["Comment"].ToString();
c.UserId = reader["UserId"].ToString();
c.Category = reader["Category"].ToString();
c.CheckNum = reader["CheckNum"].ToString();
c.BankName = reader["BankName"].ToString();
c.InvoiceNum = reader["InvoiceNum"].ToString();
l.Add(c);
}
}
}
}
}
}
c.Id = Convert.ToInt32(reader["Id"].ToString());
c.Comment = reader["Comment"].ToString();
c.UserId = reader["UserId"].ToString();
c.Category = reader["Category"].ToString();
c.CheckNum = reader["CheckNum"].ToString();
c.BankName = reader["BankName"].ToString();
c.InvoiceNum = reader["InvoiceNum"].ToString();
l.Add(c);
}
con.Close();
return(l);
}
