public bool Update(Savings savinginfo) //적금을 연장할 때 부르는 함수
{
MySqlTransaction trans = conn.BeginTransaction();
try
{
string sql = @"update savings
set
OutAccount = @outaccount,
OutAccountPwd = @outpwd,
NewPwd = @newpd,
Duration = Duration + @duration
where SAccountNum = @saccoutnum";
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.Transaction = trans;
cmd.Parameters.Add("@outaccount", MySqlDbType.VarChar);
cmd.Parameters["@outaccount"].Value = savinginfo.OutAccount;
cmd.Parameters.Add("@outpwd", MySqlDbType.VarChar);
cmd.Parameters["@outpwd"].Value = savinginfo.OutAccountPwd;
cmd.Parameters.Add("@newpd", MySqlDbType.VarChar);
cmd.Parameters["@newpd"].Value = savinginfo.NewPwd;
cmd.Parameters.Add("@duration", MySqlDbType.VarChar);
cmd.Parameters["@duration"].Value = savinginfo.Duration;
cmd.Parameters.Add("@saccoutnum", MySqlDbType.Int32);
cmd.Parameters["@saccoutnum"].Value = savinginfo.SAccountNum;
if (cmd.ExecuteNonQuery() > 0)
{
trans.Commit();
return(true);
}
else
{
trans.Rollback();
return(false);
}
}
catch (Exception)
{
trans.Rollback();
return(false);
}
}
public bool Insert(Savings savinginfo)
{
MySqlTransaction trans = conn.BeginTransaction();
try
{
string sql = @"insert into savings (DateCreated, CustomerNum, CustomerName, KindOfAcc, Duration,
PayPerMonth, OutAccount, OutAccountPwd, NewPwd)
values(now(), @customernum, @customername, @kindofacc, @duration, @paypermonth, @outaccount, @outaccountpwd, @newpwd)";
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.Transaction = trans;
cmd.Parameters.Add("@customernum", MySqlDbType.Int32);
cmd.Parameters["@customernum"].Value = Convert.ToInt32(savinginfo.CustomerNum);
cmd.Parameters.Add("@customername", MySqlDbType.VarChar);
cmd.Parameters["@customername"].Value = savinginfo.CustomerName;
cmd.Parameters.Add("@kindofacc", MySqlDbType.VarChar);
cmd.Parameters["@kindofacc"].Value = savinginfo.KindOfAcc;
cmd.Parameters.Add("@duration", MySqlDbType.VarChar);
cmd.Parameters["@duration"].Value = savinginfo.Duration;
cmd.Parameters.Add("@paypermonth", MySqlDbType.VarChar);
cmd.Parameters["@paypermonth"].Value = savinginfo.PayPerMonth;
cmd.Parameters.Add("@outaccount", MySqlDbType.VarChar);
cmd.Parameters["@outaccount"].Value = savinginfo.OutAccount;
cmd.Parameters.Add("@outaccountpwd", MySqlDbType.VarChar);
cmd.Parameters["@outaccountpwd"].Value = savinginfo.OutAccountPwd;
cmd.Parameters.Add("@newpwd", MySqlDbType.VarChar);
cmd.Parameters["@newpwd"].Value = savinginfo.NewPwd;
cmd.ExecuteNonQuery();
trans.Commit();
return(true);
}
catch (Exception)
{
trans.Rollback();
return(false);
}
}