private void addButton_Click(object sender, EventArgs e)
{
if (String.IsNullOrWhiteSpace(explainTextBox.Text))
{
explainTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("توضیحات وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
SqlConnection con = new SqlConnection(this.connection);
con.Open();
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; insert into backAccountInfoHistory (id, name, bankName, ownerName, subdate, enactmentId, description) Values (@id, @name, @bname, @oname, @sdate, @eId, @des); delete from bankAccount where id = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd.Parameters.AddWithValue("@name", bankAccountNameTextBox.Text);
cmd.Parameters.AddWithValue("@bname", bankNameTextBox.Text);
cmd.Parameters.AddWithValue("@oname", bankAccountOwnerNameTextBox.Text);
cmd.Parameters.AddWithValue("@sdate", endDateTimePickerX.SelectedDateInDateTime.Date);
cmd.Parameters.AddWithValue("@eId", ExtensionFunction.PersianToEnglish(enactmentTextbox.Text));
cmd.Parameters.AddWithValue("@des", "(حذف حساب) " + explainTextBox.Text);
cmd.ExecuteNonQuery();
con.Close();
FMessegeBox.FarsiMessegeBox.Show("حساب با موفقیت حذف شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
this.Close();
}
private void editMemeberButton_Click(object sender, EventArgs e)
{
string id;
if (!editMemberTextbox.Text.Any(char.IsWhiteSpace) && editMemberTextbox.Text.All(char.IsDigit))
{
id = ExtensionFunction.PersianToEnglish(editMemberTextbox.Text);
SqlConnection con = new SqlConnection(this.connection);
con.Open();
SqlCommand cmdcheck = new SqlCommand("select count(*) as existance from member where id = @id", con);
cmdcheck.Parameters.AddWithValue("@id", id);
int exist = 0;
using (SqlDataReader reader = cmdcheck.ExecuteReader())
{
if (reader.Read())
{
exist = int.Parse(String.Format("{0}", reader["existance"]));
}
}
con.Close();
if (exist == 1)
{
var newform = new editMemberForm2(id);
newform.ShowDialog(this);
}
else
{
FMessegeBox.FarsiMessegeBox.Show("عضوی با این شماره ملی وجود ندارد!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
}
}
else
{
FMessegeBox.FarsiMessegeBox.Show("!شماره ملی باید شامل اعداد و بدون هیچ فاصلهای باشد", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
}
}
private void comebackButton_Click(object sender, EventArgs e)
{
string id;
id = ExtensionFunction.PersianToEnglish(comebackTextbox.Text);
SqlCommand cmdcheck;
SqlConnection con = new SqlConnection(this.connection);
con.Open();
if (this.Text == "رجعت عضو")
{
cmdcheck = new SqlCommand("select count(*) as existance from abandoned where id = @id", con);
cmdcheck.Parameters.AddWithValue("@id", id);
int exist = 0;
using (SqlDataReader reader = cmdcheck.ExecuteReader())
{
if (reader.Read())
{
exist = int.Parse(String.Format("{0}", reader["existance"]));
}
}
con.Close();
if (exist == 1)
{
var newform = new comebackForm2(id);
newform.ShowDialog(this);
}
else
{
FMessegeBox.FarsiMessegeBox.Show("!عضوی با این شماره ملی در لیست اعضای معلق وجود ندارد", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
}
}
else
{
cmdcheck = new SqlCommand("select count(*) as existance from member, Inmember where member.id = Inmember.id and Inmember.kickdate is Null and member.id = @id", con);
cmdcheck.Parameters.AddWithValue("@id", id);
int exist = 0;
using (SqlDataReader reader = cmdcheck.ExecuteReader())
{
if (reader.Read())
{
exist = int.Parse(String.Format("{0}", reader["existance"]));
}
}
con.Close();
if (exist == 1)
{
var newform = new comebackForm2(id);
newform.ShowDialog(this);
}
else
{
FMessegeBox.FarsiMessegeBox.Show("!عضوی با این شماره ملی در لیست اعضای رجعت یافته وجود ندارد", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
}
}
}
private void denyButton_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(this.connection);
con.Open();
SqlCommand cmd = new SqlCommand("update MarryHelpReq Set status = @rstat, enactmentId = @eId where id = @rId;", con);
cmd.Parameters.AddWithValue("@rId", this.rId);
cmd.Parameters.AddWithValue("@eId", ExtensionFunction.PersianToEnglish(enactmentTextbox.Text));
cmd.Parameters.AddWithValue("@rstat", "رد شده");
cmd.ExecuteNonQuery();
con.Close();
FMessegeBox.FarsiMessegeBox.Show("درخواست با موفقیت رد شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
this.Close();
}
private void delButton_Click(object sender, EventArgs e)
{
DialogResult res = FMessegeBox.FarsiMessegeBox.Show("آیا نسیت به حذف ارائه این کمک اطمینان دارید؟", "پرسش", FMessegeBox.FMessegeBoxButtons.YesNo, FMessegeBox.FMessegeBoxIcons.Question, FMessegeBox.FMessegeBoxDefaultButton.button1);
if (res != DialogResult.Yes)
{
return;
}
SqlConnection con = new SqlConnection(this.connection);
con.Open();
string dpath = System.IO.Directory.GetFiles(this.helpPath + "\\" + this.id + "\\receipt")[0];
System.IO.File.Delete(dpath);
if (cashtype == "نقدی")
{
decimal stock = 0;
SqlCommand cmdget = new SqlCommand("select stock from bankAccount where id = @bId;", con);
cmdget.Parameters.AddWithValue("@bId", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
using (SqlDataReader reader = cmdget.ExecuteReader())
{
if (reader.Read())
{
stock = reader.GetDecimal(0);
}
}
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; update OtherHelpsIndiv Set presdescription = Null, enddate = Null, status = @stat where id = @bId; update bankAccount set stock = @st where id = @id; delete from doc where id = @id and doctype = @dtype; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@stat", "ارائه");
cmd.Parameters.AddWithValue("@bId", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd.Parameters.AddWithValue("@st", stock + fee);
cmd.Parameters.AddWithValue("@dtype", "OIhelp:receipt");
cmd.ExecuteNonQuery();
}
else
{
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; update OtherHelpsIndiv Set presdescription = Null, enddate = Null, status = @stat where id = @id; update bankAccount set stock = @st where id = @id; delete from doc where id = @id and doctype = @dtype; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@stat", "ارائه");
cmd.Parameters.AddWithValue("@dtype", "OIhelp:receipt");
cmd.ExecuteNonQuery();
}
con.Close();
FMessegeBox.FarsiMessegeBox.Show("ارائه کمک با موفقیت حذف شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
this.Close();
}
private void chooseButton_Click(object sender, EventArgs e)
{
if (membersView.Rows[membersView.SelectedCells[0].RowIndex].Cells[7].Value.ToString() == "نامشخص")
{
FMessegeBox.FarsiMessegeBox.Show("این تقاضا فایل یا اطلاعات بیشتری ندارد!", "توجه", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
}
else if(membersView.Rows[membersView.SelectedCells[0].RowIndex].Cells[6].Value.ToString() == "")
{
var newform = new observereqForm2_2(ExtensionFunction.PersianToEnglish(membersView.Rows[membersView.SelectedCells[0].RowIndex].Cells[membersView.SelectedCells[0].ColumnIndex].Value.ToString()));
newform.ShowDialog(this);
}
else
{
var newform = new observereqForm3_2(ExtensionFunction.PersianToEnglish(membersView.Rows[membersView.SelectedCells[0].RowIndex].Cells[membersView.SelectedCells[0].ColumnIndex].Value.ToString()));
newform.ShowDialog(this);
}
}
private void setButton_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(this.connection);
con.Open();
SqlCommand cmdmember = new SqlCommand("select count(*) from member where id = @id and id = supporter_id;", con);
cmdmember.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(idTextbox.Text));
int c = 0;
using (SqlDataReader reader = cmdmember.ExecuteReader())
{
if (reader.Read())
{
c = reader.GetInt32(0);
}
}
if (c != 0)
{
var newform = new newReqForm2(ExtensionFunction.PersianToEnglish(idTextbox.Text), "member");
newform.ShowDialog(this);
}
else
{
SqlCommand cmdapplicant = new SqlCommand("select count(*) from otherApplicant where id = @id;", con);
cmdapplicant.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(idTextbox.Text));
c = 0;
using (SqlDataReader reader = cmdapplicant.ExecuteReader())
{
if (reader.Read())
{
c = reader.GetInt32(0);
}
}
if (c != 0)
{
var newform = new newReqForm2(ExtensionFunction.PersianToEnglish(idTextbox.Text), "applicant");
newform.ShowDialog(this);
}
else
{
FMessegeBox.FarsiMessegeBox.Show("شماره ملی عضو موجود نیست!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
}
}
con.Close();
}
private void setButton_Click(object sender, EventArgs e)
{
DialogResult res = FMessegeBox.FarsiMessegeBox.Show("آیا نسبت به ثبت بودجه اطمینان دارید؟", "پرسش", FMessegeBox.FMessegeBoxButtons.YesNo, FMessegeBox.FMessegeBoxIcons.Question, FMessegeBox.FMessegeBoxDefaultButton.button1);
if (res != DialogResult.Yes)
{
return;
}
SqlConnection con = new SqlConnection(this.connection);
con.Open();
SqlCommand cmdsavehistory = new SqlCommand("BEGIN TRY begin tran t1; insert into budgetsCurrenciesHistory select @y, * from budgetsCurrencies; update budgetsCurrencies set amount = 0 where typename like '%Consume'; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
SqlCommand cmdgetbsid = new SqlCommand("select max(id) from budgetsets;", con);
string bsid = "1398";
using (SqlDataReader reader = cmdgetbsid.ExecuteReader())
{
if (reader.Read())
{
bsid = reader.GetString(0);
}
}
cmdsavehistory.Parameters.AddWithValue("@y", bsid);
cmdsavehistory.ExecuteNonQuery();
string d = DateTime.Now.Date.ToPersian(); d = d.Substring(0, 4) + d.Substring(5, 2) + d.Substring(8, 2);
SqlCommand cmd = new SqlCommand("insert into budgetsets (id, subdate, enactmentId) Values(@id, @sdate, @eId);", con);
cmd.Parameters.AddWithValue("@id", "bs" + d);
cmd.Parameters.AddWithValue("@sdate", DateTime.Now.Date);
cmd.Parameters.AddWithValue("@eId", ExtensionFunction.PersianToEnglish(enactmentTextbox.Text));
cmd.ExecuteNonQuery();
NumericUpDown nu;
foreach (var budget in budgets)
{
cmd = new SqlCommand("update budgetsCurrencies Set amount = @amount where typename = @tname;", con);
nu = (NumericUpDown)this.Controls.Find(budget + "NumericUpDown", true)[0];
cmd.Parameters.AddWithValue("@amount", nu.Value);
cmd.Parameters.AddWithValue("@tname", budget + "Budget");
cmd.ExecuteNonQuery();
}
FMessegeBox.FarsiMessegeBox.Show("بودجه با موفقیت تعیین شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
con.Close();
this.Close();
con.Close();
}
private void chooseButton_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(this.connection);
con.Open();
SqlCommand cmd = new SqlCommand("select docpath from enactment where id = @id;", con);
cmd.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(membersView.Rows[membersView.SelectedCells[0].RowIndex].Cells[membersView.SelectedCells[0].ColumnIndex + membersView.ColumnCount - 1].Value.ToString()));
string p = "";
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
p = reader.GetString(0);
}
}
con.Close();
System.Diagnostics.Process.Start(p);
}
private void updateButton_Click(object sender, EventArgs e)
{
bool flag = false;
SqlConnection con = new SqlConnection(this.connection);
con.Open();
SqlCommand cmd = new SqlCommand("select name, family from helper where id = @id;", con);
cmd.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(helperIdTextbox.Text));
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
helperNameTextBox.Text = reader.GetString(0) + " " + reader.GetString(1);
flag = true;
}
}
con.Close();
if (!flag)
{
helperNameTextBox.Text = "";
}
}
private void addButton_Click(object sender, EventArgs e)
{
if (typeComboBox.Text.Length == 0)
{
FMessegeBox.FarsiMessegeBox.Show("نوع کمک انتخاب نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
/*if (String.IsNullOrWhiteSpace(helperIdTextbox.Text))
* {
* helperIdTextbox.BackColor = Color.Tomato;
* FMessegeBox.FarsiMessegeBox.Show("شناسه ملی اهداکننده وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
* return;
* }*/
if (!helperIdTextbox.Text.All(char.IsDigit) || helperIdTextbox.TextLength != 10)
{
helperIdTextbox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("شناسه ملی اهداکننده باید فقط شامل ارقام و 10 رقم باشد!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (!String.IsNullOrWhiteSpace(helperIdTextbox.Text) && String.IsNullOrWhiteSpace(helperNameTextBox.Text))
{
helperIdTextbox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("شماره ملی وارد شده ولی نام اهداکننده بررسی نشده یا وجود ندارد!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (docLabel.BackColor == Color.Red)
{
FMessegeBox.FarsiMessegeBox.Show("فایل رسید انتخاب نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (String.IsNullOrWhiteSpace(explainTextBox.Text))
{
explainTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("ذکر توضیحات الزامی است. توضیحی وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (typeComboBox.Text == "نقدی" && bankAccountNumberTextBox.TextLength == 0)
{
FMessegeBox.FarsiMessegeBox.Show("حساب مورد نظر انتخاب نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
DialogResult res = FMessegeBox.FarsiMessegeBox.Show("آیا نسبت به ثبت دریافت این کمک اطمینان دارید؟", "پرسش", FMessegeBox.FMessegeBoxButtons.YesNo, FMessegeBox.FMessegeBoxIcons.Question, FMessegeBox.FMessegeBoxDefaultButton.button1);
if (res != DialogResult.Yes)
{
return;
}
SqlConnection con = new SqlConnection(this.connection);
con.Open();
string d = DateTime.Now.Date.ToPersian(); d = "Rec" + d.Substring(0, 4) + d.Substring(5, 2) + d.Substring(8, 2);
SqlCommand cmdgetid = new SqlCommand("select id from recHelps where id like '" + d + "%';", con);
int index = 1, mx = 1;
using (SqlDataReader reader = cmdgetid.ExecuteReader())
{
while (reader.Read())
{
string s = String.Format("{0}", reader["id"]);
if (s == "")
{
index = 1;
}
else
{
index = Convert.ToInt32(s.Substring(11)) + 1;
}
mx = Math.Max(mx, index);
}
}
d = d + mx.ToString();
decimal stock = 0;
if (cashRadioButton.Checked)
{
SqlCommand cmdget = new SqlCommand("select stock from bankAccount where id = @id", con);
cmdget.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
using (SqlDataReader reader = cmdget.ExecuteReader())
{
if (reader.Read())
{
stock = reader.GetDecimal(0);
}
}
}
else
{
SqlCommand cmdget = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
switch (typeComboBox.Text)
{
case "گوشت":
cmdget.Parameters.AddWithValue("@id", "meat");
break;
case "خواربار":
cmdget.Parameters.AddWithValue("@id", "grocery");
break;
case "مرغ":
cmdget.Parameters.AddWithValue("@id", "chicken");
break;
case "ازدواج":
cmdget.Parameters.AddWithValue("@id", "marry");
break;
case "ایتام":
cmdget.Parameters.AddWithValue("@id", "orphan");
break;
case "متفرقه":
cmdget.Parameters.AddWithValue("@id", "stock");
break;
}
using (SqlDataReader reader = cmdget.ExecuteReader())
{
if (reader.Read())
{
stock = reader.GetDecimal(0);
}
}
}
string fileName = System.IO.Path.GetFileName(doc);
string targetPath = this.recHelpPath + "\\" + d + "\\";
System.IO.Directory.CreateDirectory(targetPath);
string destFile = System.IO.Path.Combine(targetPath, fileName);
System.IO.File.Copy(doc, destFile, false);
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; insert into recHelps(id, type, fee, packet, recdate, subdate, helperId, helperName, bankAccountId, bankAccountName, description, cashtype) Values(@id, @typ, @fee, @pack, @rdate, @sdate, @hId, @hName, @bId, @bName, @des, @cashtype); insert into recHelpsHistory (id, type, fee, packet, recdate, subdate, helperId, helperName, bankAccountId, bankAccountName, description, cashtype) Values(@id, @typ, @fee, @pack, @rdate, @sdate, @hId, @hName, @bId, @bName, @des, @cashtype); insert into doc(id, docname, docpath, subdate, doctype) Values(@id, @dname, @dpath, @sdate, @dtype); commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id", d);
cmd.Parameters.AddWithValue("@typ", typeComboBox.Text);
cmd.Parameters.AddWithValue("@fee", feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@pack", packetNumericUpDown.Value);
cmd.Parameters.AddWithValue("@rdate", recDateTimePickerX.SelectedDateInDateTime.Date);
cmd.Parameters.AddWithValue("@sdate", DateTime.Now.Date);
cmd.Parameters.AddWithValue("@hId", ExtensionFunction.PersianToEnglish(helperIdTextbox.Text));
cmd.Parameters.AddWithValue("@hName", helperNameTextBox.Text);
cmd.Parameters.AddWithValue("@bId", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd.Parameters.AddWithValue("@bName", bankAccountNameComboBox.Text);
cmd.Parameters.AddWithValue("@des", explainTextBox.Text);
if (cashRadioButton.Checked)
{
cmd.Parameters.AddWithValue("@cashtype", "نقدی");
}
else
{
cmd.Parameters.AddWithValue("@cashtype", "غیرنقدی");
}
cmd.Parameters.AddWithValue("@dname", fileName);
cmd.Parameters.AddWithValue("@dpath", destFile);
cmd.Parameters.AddWithValue("@dtype", "recHelp");
cmd.ExecuteNonQuery();
SqlCommand cmd2;
if (cashRadioButton.Checked)
{
cmd2 = new SqlCommand("update bankAccount set stock = @st where id = @id;", con);
cmd2.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd2.Parameters.AddWithValue("@st", stock + feeNumericUpDown.Value);
cmd2.ExecuteNonQuery();
}
else if (typeComboBox.Text == "گوشت")
{
cmd2 = new SqlCommand("update budgetsCurrencies set amount = @amount where typename = @typ;", con);
cmd2.Parameters.AddWithValue("@typ", "meat");
cmd2.Parameters.AddWithValue("@amount", stock + feeNumericUpDown.Value);
cmd2.ExecuteNonQuery();
}
else if (typeComboBox.Text == "مرغ")
{
cmd2 = new SqlCommand("update budgetsCurrencies set amount = @amount where typename = @typ;", con);
cmd2.Parameters.AddWithValue("@typ", "chicken");
cmd2.Parameters.AddWithValue("@amount", stock + feeNumericUpDown.Value);
cmd2.ExecuteNonQuery();
}
else if (typeComboBox.Text == "خواربار")
{
cmd2 = new SqlCommand("update budgetsCurrencies set amount = @amount where typename = @typ;", con);
cmd2.Parameters.AddWithValue("@typ", "grocery");
cmd2.Parameters.AddWithValue("@amount", stock + feeNumericUpDown.Value);
cmd2.ExecuteNonQuery();
}
else if (typeComboBox.Text == "ازدواج")
{
cmd2 = new SqlCommand("update budgetsCurrencies set amount = @amount where typename = @typ;", con);
cmd2.Parameters.AddWithValue("@typ", "marry");
cmd2.Parameters.AddWithValue("@amount", stock + feeNumericUpDown.Value);
cmd2.ExecuteNonQuery();
}
else if (typeComboBox.Text == "ایتام")
{
cmd2 = new SqlCommand("update budgetsCurrencies set amount = @amount where typename = @typ;", con);
cmd2.Parameters.AddWithValue("@typ", "orphan");
cmd2.Parameters.AddWithValue("@amount", stock + feeNumericUpDown.Value);
cmd2.ExecuteNonQuery();
}
else if (typeComboBox.Text == "متفرقه")
{
cmd2 = new SqlCommand("update budgetsCurrencies set amount = @amount where typename = @typ;", con);
cmd2.Parameters.AddWithValue("@typ", "stock");
cmd2.Parameters.AddWithValue("@amount", stock + feeNumericUpDown.Value);
cmd2.ExecuteNonQuery();
}
FMessegeBox.FarsiMessegeBox.Show("دریافت کمک با موفقیت ثبت شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
con.Close();
this.Close();
}
private void setButton_Click(object sender, EventArgs e)
{
if (this.Text == "تایید معرفینامه تحصیلی")
{
SqlConnection con = new SqlConnection(this.connection);
con.Open();
decimal budget = 0, consume = 0, stock = 0;
SqlCommand cmdget = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
SqlCommand cmdget2 = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
SqlCommand cmdget3 = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
cmdget.Parameters.AddWithValue("@id", "eduBudget");
cmdget2.Parameters.AddWithValue("@id", "eduConsume");
cmdget3.Parameters.AddWithValue("@id", "stock");
using (SqlDataReader reader = cmdget.ExecuteReader())
{
if (reader.Read())
{
budget = reader.GetDecimal(0);
}
}
using (SqlDataReader reader = cmdget2.ExecuteReader())
{
if (reader.Read())
{
consume = reader.GetDecimal(0);
}
}
using (SqlDataReader reader = cmdget3.ExecuteReader())
{
if (reader.Read())
{
stock = reader.GetDecimal(0);
}
}
if (feeNumericUpDown.Value > this.fee && consume + feeNumericUpDown.Value - this.fee > budget)
{
FMessegeBox.FarsiMessegeBox.Show("این درخواست خارج از محدوده بودجه تعریف شده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
else if (feeNumericUpDown.Value > this.fee && feeNumericUpDown.Value - this.fee > stock)
{
FMessegeBox.FarsiMessegeBox.Show("موجودی کافی نیست!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
else
{
res = true;
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1;update StudyHelps Set fenactmentId = @feId, status = @stat, fee = @fee where id = @id; update budgetsCurrencies Set amount = @amount2 where typename = @tname2; update budgetsCurrencies Set amount = @amount3 where typename = @tname3; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@feId", ExtensionFunction.PersianToEnglish(enactmentTextbox2.Text));
cmd.Parameters.AddWithValue("@stat", "نهایی");
cmd.Parameters.AddWithValue("@amount2", consume + feeNumericUpDown.Value - this.fee);
cmd.Parameters.AddWithValue("@amount3", stock - feeNumericUpDown.Value + this.fee);
cmd.Parameters.AddWithValue("@fee", feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@tname2", "eduConsume");
cmd.Parameters.AddWithValue("@tname3", "stock");
cmd.ExecuteNonQuery();
con.Close();
FMessegeBox.FarsiMessegeBox.Show("کمک با موفقیت تایید و نهایی شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
this.Close();
}
}
else if (this.Text == "ویرایش تایید معرفینامه تحصیلی")
{
SqlConnection con = new SqlConnection(this.connection);
con.Open();
decimal budget = 0, consume = 0, stock = 0;
SqlCommand cmdget = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
SqlCommand cmdget2 = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
SqlCommand cmdget3 = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
cmdget.Parameters.AddWithValue("@id", "eduBudget");
cmdget2.Parameters.AddWithValue("@id", "eduConsume");
cmdget3.Parameters.AddWithValue("@id", "stock");
using (SqlDataReader reader = cmdget.ExecuteReader())
{
if (reader.Read())
{
budget = reader.GetDecimal(0);
}
}
using (SqlDataReader reader = cmdget2.ExecuteReader())
{
if (reader.Read())
{
consume = reader.GetDecimal(0);
}
}
using (SqlDataReader reader = cmdget3.ExecuteReader())
{
if (reader.Read())
{
stock = reader.GetDecimal(0);
}
}
if (feeNumericUpDown.Value > this.fee && consume + feeNumericUpDown.Value - this.fee > budget)
{
FMessegeBox.FarsiMessegeBox.Show("این درخواست خارج از محدوده بودجه تعریف شده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
else if (feeNumericUpDown.Value > this.fee && feeNumericUpDown.Value - this.fee > stock)
{
FMessegeBox.FarsiMessegeBox.Show("موجودی کافی نیست!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
else
{
res = true;
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1;update StudyHelps Set fenactmentId = @feId, fee = @fee where id = @id; update budgetsCurrencies Set amount = @amount2 where typename = @tname2; update budgetsCurrencies Set amount = @amount3 where typename = @tname3; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@feId", ExtensionFunction.PersianToEnglish(enactmentTextbox2.Text));
cmd.Parameters.AddWithValue("@amount2", consume + feeNumericUpDown.Value - this.fee);
cmd.Parameters.AddWithValue("@amount3", stock - feeNumericUpDown.Value + this.fee);
cmd.Parameters.AddWithValue("@fee", feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@tname2", "eduConsume");
cmd.Parameters.AddWithValue("@tname3", "stock");
cmd.ExecuteNonQuery();
con.Close();
FMessegeBox.FarsiMessegeBox.Show("تایید کمک با موفقیت ویرایش شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
this.Close();
}
}
else if (this.Text == "ارائه معرفینامه تحصیلی")
{
res = true;
SqlConnection con = new SqlConnection(this.connection);
con.Open();
SqlCommand cmdup = new SqlCommand("BEGIN TRY begin tran t1; update StudyHelps Set status = @stat, enddate = @edate where id = @id; insert into StudyRecList (hId, supporter_id, folder_id, name, family, stuId) select hId, supporter_id, folder_id, name, family, stuId from StudyFinList where hId = @id; delete from StudyFinList where hId = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmdup.Parameters.AddWithValue("@id", this.id);
cmdup.Parameters.AddWithValue("@stat", "پایانیافته");
cmdup.Parameters.AddWithValue("@edate", DateTime.Now.Date);
cmdup.ExecuteNonQuery();
con.Close();
FMessegeBox.FarsiMessegeBox.Show("کمک با موفقیت پایان یافت!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
this.Close();
}
else
{
res = true;
FMessegeBox.FarsiMessegeBox.Show("ارائه کمک با موفقیت ویرایش شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
this.Close();
}
}
private void addButton_Click(object sender, EventArgs e)
{
if (String.IsNullOrWhiteSpace(bankAccountNameTextBox.Text))
{
bankAccountNameTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("نام حساب وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (!bankAccountNumberTextBox.Text.All(char.IsDigit))
{
bankAccountNumberTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("شماره حساب باید فقط شامل ارقام باشد!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (String.IsNullOrWhiteSpace(bankNameTextBox.Text))
{
bankNameTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("نام بانک وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
/*if (!bankNameTextBox.Text.All(c => char.IsWhiteSpace(c) || char.IsLetter(c)))
* {
* bankNameTextBox.BackColor = Color.Tomato;
* FMessegeBox.FarsiMessegeBox.Show("نام بانک باید فقط شامل حروف و فاصله باشد!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
* return;
* }*/
if (String.IsNullOrWhiteSpace(bankAccountOwnerNameTextBox.Text))
{
bankAccountOwnerNameTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("نام صاحب حساب وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (!bankAccountOwnerNameTextBox.Text.All(c => char.IsWhiteSpace(c) || char.IsLetter(c)))
{
bankAccountOwnerNameTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("نام صاحب حساب باید فقط شامل حروف و فاصله باشد!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (String.IsNullOrWhiteSpace(explainTextBox.Text))
{
explainTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("توضیحات وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
SqlConnection con = new SqlConnection(this.connection);
con.Open();
if (this.id != ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text))
{
int c = 0;
SqlCommand cmdcheck = new SqlCommand("select count(*) from bankAccount where id = @id;", con);
using (SqlDataReader reader = cmdcheck.ExecuteReader())
{
if (reader.Read())
{
c = reader.GetInt32(0);
}
}
if (c != 0)
{
bankAccountNumberTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("شماره حساب وارد شده متعلق به یک حساب دیگر موجود در سیستم میباشد!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
}
SqlCommand cmd = new SqlCommand("update backAccountInfoHistory set id = @newId where id = @id; insert into backAccountInfoHistory (id, name, bankName, ownerName, subdate, enactmentId, description) Values (@newId, @name, @bname, @oname, @sdate, @eId, @des); update bankAccount set id = @newId, name = @name, bankName = @bname, ownerName = @oname where id = @id;", con);
cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@newId", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd.Parameters.AddWithValue("@name", bankAccountNameTextBox.Text);
cmd.Parameters.AddWithValue("@bname", bankNameTextBox.Text);
cmd.Parameters.AddWithValue("@oname", bankAccountOwnerNameTextBox.Text);
cmd.Parameters.AddWithValue("@eId", ExtensionFunction.PersianToEnglish(enactmentTextbox.Text));
cmd.Parameters.AddWithValue("@sdate", DateTime.Now.Date);
cmd.Parameters.AddWithValue("@des", explainTextBox.Text);
cmd.ExecuteNonQuery();
con.Close();
FMessegeBox.FarsiMessegeBox.Show("حساب با موفقیت ویرایش شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
this.Close();
}
private void setButton_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(this.connection);
con.Open();
SqlCommand cmdcheck;
if (this.Text == "بررسی تقاضا" || this.Text == "ویرایش تقاضا")
{
cmdcheck = new SqlCommand("select count(*) from request where applicantId = sup and id = @id and result is Null;", con);
cmdcheck.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(idTextbox.Text));
int c = 0;
using (SqlDataReader reader = cmdcheck.ExecuteReader())
{
if (reader.Read())
{
c = reader.GetInt32(0);
}
}
if (c != 0)
{
if (this.Text == "بررسی تقاضا")
{
var newform = new checkReqForm(ExtensionFunction.PersianToEnglish(idTextbox.Text), "check");
newform.ShowDialog(this);
}
else
{
var newform = new newReqForm2(ExtensionFunction.PersianToEnglish(idTextbox.Text), "edit");
newform.ShowDialog(this);
}
}
else
{
FMessegeBox.FarsiMessegeBox.Show("شماره تقاضا موجود نیست!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
}
}
else if (this.Text == "ثبت ارائه معرفینامه" || this.Text == "ویرایش بررسی")
{
if (this.Text == "ویرایش بررسی")
{
cmdcheck = new SqlCommand("select count(*) from request where applicantId = sup and id = @id and result is not Null and deliveryDate is Null;", con);
}
else
{
cmdcheck = new SqlCommand("select count(*) from request where applicantId = sup and id = @id and result = N'تایید' and deliveryDate is Null;", con);
}
cmdcheck.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(idTextbox.Text));
int c = 0;
using (SqlDataReader reader = cmdcheck.ExecuteReader())
{
if (reader.Read())
{
c = reader.GetInt32(0);
}
}
if (c != 0)
{
if (this.Text == "ثبت ارائه معرفینامه")
{
var newform = new responseReqForm(ExtensionFunction.PersianToEnglish(idTextbox.Text), "response");
newform.ShowDialog(this);
}
else
{
var newform = new checkReqForm(ExtensionFunction.PersianToEnglish(idTextbox.Text), "edit");
newform.ShowDialog(this);
}
}
else
{
FMessegeBox.FarsiMessegeBox.Show("شماره تقاضا موجود نیست!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
}
}
else if (this.Text == "ویرایش مصوبه")
{
cmdcheck = new SqlCommand("select count(*) from enactment where id = @id;", con);
cmdcheck.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(idTextbox.Text));
int c = 0;
using (SqlDataReader reader = cmdcheck.ExecuteReader())
{
if (reader.Read())
{
c = reader.GetInt32(0);
}
}
if (c != 0)
{
var newform = new editEnactmentForm(ExtensionFunction.PersianToEnglish(idTextbox.Text));
newform.ShowDialog(this);
}
else
{
FMessegeBox.FarsiMessegeBox.Show("شماره مصوبه موجود نیست!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
}
}
else
{
cmdcheck = new SqlCommand("select count(*) from request where applicantId = sup and id = @id and deliveryDate is not Null;", con);
cmdcheck.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(idTextbox.Text));
int c = 0;
using (SqlDataReader reader = cmdcheck.ExecuteReader())
{
if (reader.Read())
{
c = reader.GetInt32(0);
}
}
if (c != 0)
{
var newform = new responseReqForm(ExtensionFunction.PersianToEnglish(idTextbox.Text), "edit");
newform.ShowDialog(this);
}
else
{
FMessegeBox.FarsiMessegeBox.Show("شماره تقاضا موجود نیست!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
}
}
con.Close();
}
private void setButton_Click(object sender, EventArgs e)
{
if (this.Text == "ارائه کمک ازدواج")
{
if (this.type == "نقدی")
{
if (bankAccountNameComboBox.SelectedIndex == -1)
{
FMessegeBox.FarsiMessegeBox.Show("حساب بانکی انتخاب نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (receiptLabel.BackColor == Color.Red)
{
FMessegeBox.FarsiMessegeBox.Show("فیش پرداخت بارگزاری نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
SqlConnection con = new SqlConnection(this.connection);
con.Open();
decimal stock = 0;
SqlCommand cmdgetst = new SqlCommand("select stock from bankAccount where id = @bId;", con);
cmdgetst.Parameters.AddWithValue("@bId", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
using (SqlDataReader reader = cmdgetst.ExecuteReader())
{
if (reader.Read())
{
stock = reader.GetDecimal(0);
}
}
if (stock < fee)
{
FMessegeBox.FarsiMessegeBox.Show("موجودی حساب کافی نیست!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
DialogResult res = FMessegeBox.FarsiMessegeBox.Show("آیا نسبت به ثبت ارائه این کمک اطمینان دارید؟", "پرسش", FMessegeBox.FMessegeBoxButtons.YesNo, FMessegeBox.FMessegeBoxIcons.Question, FMessegeBox.FMessegeBoxDefaultButton.button1);
if (res != DialogResult.Yes)
{
return;
}
string fileName = System.IO.Path.GetFileName(RF);
string targetPath = this.helpPath + "\\" + this.id + "\\receipt";
string destFile = System.IO.Path.Combine(targetPath, fileName);
System.IO.File.Copy(addOpenFileDialog.FileName, destFile, false);
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; update MarryHelps Set presdescription = @des, enddate = @edate, status = @stat, bankAccountName = @bName, bankAccountId = @bId where id = @id; update bankAccount set stock = @st where id = @bId; insert into doc(id, docname, docpath, subdate, doctype) Values(@id, @dname, @dpath, @edate, @dtype); commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@des", "(توضیحات ارائه: " + explainTextBox2.Text + ")");
cmd.Parameters.AddWithValue("@edate", DateTime.Now.Date);
cmd.Parameters.AddWithValue("@stat", "پایانیافته: ارائه شده");
cmd.Parameters.AddWithValue("@bId", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd.Parameters.AddWithValue("@st", stock - fee);
cmd.Parameters.AddWithValue("@bName", bankAccountNameComboBox.Text);
cmd.Parameters.AddWithValue("@bId", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd.Parameters.AddWithValue("@dname", fileName);
cmd.Parameters.AddWithValue("@dpath", destFile);
cmd.Parameters.AddWithValue("@dtype", "Mhelp:receipt");
cmd.ExecuteNonQuery();
con.Close();
FMessegeBox.FarsiMessegeBox.Show("کمک با موفقیت به مددجو ارائه شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
this.Close();
}
else
{
if (receiptLabel.BackColor == Color.Red)
{
FMessegeBox.FarsiMessegeBox.Show("رسید بارگزاری نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
SqlConnection con = new SqlConnection(this.connection);
con.Open();
string fileName = System.IO.Path.GetFileName(RF);
string targetPath = this.helpPath + "\\" + this.id + "\\receipt";
string destFile = System.IO.Path.Combine(targetPath, fileName);
System.IO.File.Copy(addOpenFileDialog.FileName, destFile, false);
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; update MarryHelps Set presdescription = @des, enddate = @edate, status = @stat where id = @id; insert into doc(id, docname, docpath, subdate, doctype) Values(@id, @dname, @dpath, @edate, @dtype); commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@des", "(توضیحات ارائه: " + explainTextBox2.Text + ")");
cmd.Parameters.AddWithValue("@edate", DateTime.Now.Date);
cmd.Parameters.AddWithValue("@stat", "پایانیافته: ارائه شده");
cmd.Parameters.AddWithValue("@dname", fileName);
cmd.Parameters.AddWithValue("@dpath", destFile);
cmd.Parameters.AddWithValue("@dtype", "Mhelp:receipt");
cmd.ExecuteNonQuery();
con.Close();
FMessegeBox.FarsiMessegeBox.Show("کمک با موفقیت به مددجو ارائه شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
this.Close();
}
}
else
{
SqlConnection con = new SqlConnection(this.connection);
con.Open();
decimal prestock = 0, stock = 0;
if (this.prebId != ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text))
{
SqlCommand cmdgetst = new SqlCommand("select stock from bankAccount where id = @bId;", con);
cmdgetst.Parameters.AddWithValue("@bId", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
using (SqlDataReader reader = cmdgetst.ExecuteReader())
{
if (reader.Read())
{
stock = reader.GetDecimal(0);
}
}
cmdgetst = new SqlCommand("select stock from bankAccount where id = @bId;", con);
cmdgetst.Parameters.AddWithValue("@bId", this.prebId);
using (SqlDataReader reader = cmdgetst.ExecuteReader())
{
if (reader.Read())
{
prestock = reader.GetDecimal(0);
}
}
}
if (stock < fee)
{
FMessegeBox.FarsiMessegeBox.Show("موجودی حساب قبلی برای ویرایش کافی نیست!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
DialogResult res = FMessegeBox.FarsiMessegeBox.Show("آیا نسبت به ثبت ارائه این کمک اطمینان دارید؟", "پرسش", FMessegeBox.FMessegeBoxButtons.YesNo, FMessegeBox.FMessegeBoxIcons.Question, FMessegeBox.FMessegeBoxDefaultButton.button1);
if (res != DialogResult.Yes)
{
return;
}
if (this.prebId != ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text))
{
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; update bankAccount set stock = @st where id = @prev; update bankAccount set stock = @newst where id = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@prev", this.prebId);
cmd.Parameters.AddWithValue("@st", prestock + fee);
cmd.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd.Parameters.AddWithValue("@newst", stock - fee);
cmd.ExecuteNonQuery();
}
if (receiptLabel.BackColor == Color.GreenYellow)
{
string dpath = System.IO.Directory.GetFiles(this.helpPath + "\\" + this.id + "\\receipt")[0];
System.IO.File.Delete(dpath);
string fileName = System.IO.Path.GetFileName(RF);
string targetPath = this.helpPath + "\\" + this.id + "\\receipt";
string destFile = System.IO.Path.Combine(targetPath, fileName);
System.IO.File.Copy(addOpenFileDialog.FileName, destFile, false);
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; update MarryHelps Set presdescription = @des where id = @id; update doc Set docname = @dname, docpath = @dpath, subdate = @edate where id = @id and doctype = @dtype; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@des", this.explain + "(توضیحات ویرایش ارائه: " + explainTextBox2.Text + ")");
cmd.Parameters.AddWithValue("@edate", DateTime.Now.Date);
cmd.Parameters.AddWithValue("@dname", fileName);
cmd.Parameters.AddWithValue("@dpath", destFile);
cmd.Parameters.AddWithValue("@dtype", "Mhelp:receipt");
cmd.ExecuteNonQuery();
}
else
{
SqlCommand cmd = new SqlCommand("update MarryHelps Set presdescription = @des where id = @id;", con);
cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@des", this.explain + "(توضیحات ویرایش ارائه: " + explainTextBox2.Text + ")");
cmd.ExecuteNonQuery();
}
con.Close();
FMessegeBox.FarsiMessegeBox.Show("ارائه کمک با موفقیت ویرایش شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
this.Close();
}
}
private void addButton_Click(object sender, EventArgs e)
{
if (typeComboBox.Text.Length == 0)
{
FMessegeBox.FarsiMessegeBox.Show("نوع کمک انتخاب نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (String.IsNullOrWhiteSpace(buyerNameTextBox.Text))
{
buyerNameTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("نام خریدار وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (docLabel.BackColor == Color.Red)
{
FMessegeBox.FarsiMessegeBox.Show("فایل رسید انتخاب نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (String.IsNullOrWhiteSpace(explainTextBox.Text))
{
explainTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("ذکر توضیحات الزامی است. توضیحی وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (bankAccountNameComboBox.SelectedIndex == -1)
{
FMessegeBox.FarsiMessegeBox.Show("حساب مورد نظر انتخاب نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
SqlConnection con = new SqlConnection(this.connection);
con.Open();
decimal stock = 0, amount = 0, prestock = 0, preamount = 0;
SqlCommand cmdgetst = new SqlCommand("select stock from bankAccount where id = @id;", con);
cmdgetst.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
using (SqlDataReader reader = cmdgetst.ExecuteReader())
{
if (reader.Read())
{
stock = reader.GetDecimal(0);
}
}
if (this.prebId != ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text))
{
cmdgetst = new SqlCommand("select stock from bankAccount where id = @id;", con);
cmdgetst.Parameters.AddWithValue("@id", this.prebId);
using (SqlDataReader reader = cmdgetst.ExecuteReader())
{
if (reader.Read())
{
prestock = reader.GetDecimal(0);
}
}
if (stock < feeNumericUpDown.Value)
{
FMessegeBox.FarsiMessegeBox.Show("موجودی حساب جدید کافی نیست!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
}
else if (feeNumericUpDown.Value > preFee && stock < feeNumericUpDown.Value - preFee)
{
FMessegeBox.FarsiMessegeBox.Show("موجودی حساب کافی نیست!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (pretype == "اداری فرهنگی" && typeComboBox.Text == "اداری فرهنگی")
{
decimal budget = 0, consume = 0;
SqlCommand cmdget = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
SqlCommand cmdget2 = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
cmdget.Parameters.AddWithValue("@id", "cultureBudget");
cmdget2.Parameters.AddWithValue("@id", "cultureConsume");
using (SqlDataReader reader = cmdget.ExecuteReader())
{
if (reader.Read())
{
budget = reader.GetDecimal(0);
}
}
using (SqlDataReader reader = cmdget2.ExecuteReader())
{
if (reader.Read())
{
consume = reader.GetDecimal(0);
}
}
if (feeNumericUpDown.Value > preFee && consume + feeNumericUpDown.Value - preFee > budget)
{
FMessegeBox.FarsiMessegeBox.Show("این درخواست خارج از محدوده بودجه تعریف شده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
DialogResult res = FMessegeBox.FarsiMessegeBox.Show("آیا نسبت به ویرایش خرید این کمک اطمینان دارید؟", "پرسش", FMessegeBox.FMessegeBoxButtons.YesNo, FMessegeBox.FMessegeBoxIcons.Question, FMessegeBox.FMessegeBoxDefaultButton.button1);
if (res != DialogResult.Yes)
{
return;
}
SqlCommand cmdupam, cmdupst;
if (this.prebId != ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text))
{
cmdupst = new SqlCommand("BEGIN TRY begin tran t1; update bankAccount set stock = @st where id = @prev; update bankAccount set stock = @newst where id = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmdupst.Parameters.AddWithValue("@prev", this.prebId);
cmdupst.Parameters.AddWithValue("@st", prestock + preFee);
cmdupst.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmdupst.Parameters.AddWithValue("@newst", stock - feeNumericUpDown.Value);
cmdupst.ExecuteNonQuery();
}
else if (preFee != feeNumericUpDown.Value)
{
cmdupst = new SqlCommand("BEGIN TRY begin tran t1; update bankAccount set stock = @newst where id = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmdupst.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmdupst.Parameters.AddWithValue("@newst", stock + preFee - feeNumericUpDown.Value);
cmdupst.ExecuteNonQuery();
}
if (docLabel.BackColor == Color.YellowGreen)
{
string fileName = System.IO.Path.GetFileName(doc);
string targetPath = this.buyHelpPath + "\\" + this.id + "\\";
System.IO.Directory.Delete(targetPath, true);
System.IO.Directory.CreateDirectory(targetPath);
string destFile = System.IO.Path.Combine(targetPath, fileName);
System.IO.File.Copy(doc, destFile, false);
SqlCommand cmdupdatefile = new SqlCommand("BEGIN TRY begin tran t1; delete from doc where id = @id; insert into doc(id, docname, docpath, subdate, doctype) Values(@id, @dname, @dpath, @sdate, @dtype); commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmdupdatefile.Parameters.AddWithValue("@id", this.id);
cmdupdatefile.Parameters.AddWithValue("@dname", fileName);
cmdupdatefile.Parameters.AddWithValue("@dpath", destFile);
cmdupdatefile.Parameters.AddWithValue("@sdate", DateTime.Now.Date);
cmdupdatefile.Parameters.AddWithValue("@dtype", "buyHelp");
cmdupdatefile.ExecuteNonQuery();
}
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; update buyHelps set type = @typ, fee = @fee, packet = @pack, buydate = @bdate, subdate = @sdate, buyerName = @buname, bankAccountId = @bId, bankAccountName = @bName, description = @des where id = @id; insert into buyHelpsHistory (id, type, fee, packet, buydate, subdate, buyerName, bankAccountId, bankAccountName, description, enactmentId) Values(@id, @typ, @fee, @pack, @bdate, @sdate, @buName, @bId, @bName, @des, @eId); commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@typ", typeComboBox.Text);
cmd.Parameters.AddWithValue("@fee", feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@pack", packetNumericUpDown.Value);
cmd.Parameters.AddWithValue("@bdate", buyDateTimePickerX.SelectedDateInDateTime.Date);
cmd.Parameters.AddWithValue("@sdate", DateTime.Now.Date);
cmd.Parameters.AddWithValue("@buName", buyerNameTextBox.Text);
cmd.Parameters.AddWithValue("@bId", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd.Parameters.AddWithValue("@bName", bankAccountNameComboBox.Text);
cmd.Parameters.AddWithValue("@newst", stock - feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@des", explainTextBox.Text);
cmd.Parameters.AddWithValue("@eId", ExtensionFunction.PersianToEnglish(enactmentTextbox.Text));
cmd.ExecuteNonQuery();
}
else if (pretype == "اداری فرهنگی" && typeComboBox.Text != "اداری فرهنگی")
{
SqlCommand cmdgetam = new SqlCommand("select amount from budgetsCurrencies where typename = @id;", con);
switch (typeComboBox.Text)
{
case "گوشت":
cmdgetam.Parameters.AddWithValue("@id", "meat");
break;
case "خواربار":
cmdgetam.Parameters.AddWithValue("@id", "grocery");
break;
case "مرغ":
cmdgetam.Parameters.AddWithValue("@id", "chicken");
break;
case "متفرقه":
cmdgetam.Parameters.AddWithValue("@id", "stock");
break;
}
using (SqlDataReader reader = cmdgetam.ExecuteReader())
{
if (reader.Read())
{
amount = reader.GetDecimal(0);
}
}
cmdgetam = new SqlCommand("select amount from budgetsCurrencies where typename = @id;", con);
cmdgetam.Parameters.AddWithValue("@id", "cultureConsume");
using (SqlDataReader reader = cmdgetam.ExecuteReader())
{
if (reader.Read())
{
preamount = reader.GetDecimal(0);
}
}
DialogResult res = FMessegeBox.FarsiMessegeBox.Show("آیا نسبت به ویرایش خرید این کمک اطمینان دارید؟", "پرسش", FMessegeBox.FMessegeBoxButtons.YesNo, FMessegeBox.FMessegeBoxIcons.Question, FMessegeBox.FMessegeBoxDefaultButton.button1);
if (res != DialogResult.Yes)
{
return;
}
SqlCommand cmdupam, cmdupst;
if (this.prebId != ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text))
{
cmdupst = new SqlCommand("BEGIN TRY begin tran t1; update bankAccount set stock = @st where id = @prev; update bankAccount set stock = @newst where id = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmdupst.Parameters.AddWithValue("@prev", this.prebId);
cmdupst.Parameters.AddWithValue("@st", prestock + preFee);
cmdupst.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmdupst.Parameters.AddWithValue("@newst", stock - feeNumericUpDown.Value);
cmdupst.ExecuteNonQuery();
}
else if (preFee != feeNumericUpDown.Value)
{
cmdupst = new SqlCommand("BEGIN TRY begin tran t1; update bankAccount set stock = @newst where id = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmdupst.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmdupst.Parameters.AddWithValue("@newst", stock + preFee - feeNumericUpDown.Value);
cmdupst.ExecuteNonQuery();
}
cmdupam = new SqlCommand("BEGIN TRY begin tran t1; update budgetsCurrencies set amount = @am where typename = @prev; update budgetsCurrencies set amount = @newam where typename = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmdupam.Parameters.AddWithValue("@prev", "cultureConsume");
if (typeComboBox.Text == "گوشت")
{
cmdupam.Parameters.AddWithValue("@id", "meat");
}
else if (typeComboBox.Text == "مرغ")
{
cmdupam.Parameters.AddWithValue("@id", "chicken");
}
else if (typeComboBox.Text == "خواربار")
{
cmdupam.Parameters.AddWithValue("@id", "grocery");
}
else if (typeComboBox.Text == "متفرقه")
{
cmdupam.Parameters.AddWithValue("@id", "stock");
}
cmdupam.Parameters.AddWithValue("@am", preamount - preFee);
cmdupam.Parameters.AddWithValue("@newam", amount + feeNumericUpDown.Value);
cmdupam.ExecuteNonQuery();
if (docLabel.BackColor == Color.YellowGreen)
{
string fileName = System.IO.Path.GetFileName(doc);
string targetPath = this.buyHelpPath + "\\" + this.id + "\\";
System.IO.Directory.Delete(targetPath, true);
System.IO.Directory.CreateDirectory(targetPath);
string destFile = System.IO.Path.Combine(targetPath, fileName);
System.IO.File.Copy(doc, destFile, false);
SqlCommand cmdupdatefile = new SqlCommand("BEGIN TRY begin tran t1; delete from doc where id = @id; insert into doc(id, docname, docpath, subdate, doctype) Values(@id, @dname, @dpath, @sdate, @dtype); commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmdupdatefile.Parameters.AddWithValue("@id", this.id);
cmdupdatefile.Parameters.AddWithValue("@dname", fileName);
cmdupdatefile.Parameters.AddWithValue("@dpath", destFile);
cmdupdatefile.Parameters.AddWithValue("@sdate", DateTime.Now.Date);
cmdupdatefile.Parameters.AddWithValue("@dtype", "buyHelp");
cmdupdatefile.ExecuteNonQuery();
}
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; update buyHelps set type = @typ, fee = @fee, packet = @pack, buydate = @bdate, subdate = @sdate, buyerName = @buname, bankAccountId = @bId, bankAccountName = @bName, description = @des where id = @id; insert into buyHelpsHistory (id, type, fee, packet, buydate, subdate, buyerName, bankAccountId, bankAccountName, description, enactmentId) Values(@id, @typ, @fee, @pack, @bdate, @sdate, @buName, @bId, @bName, @des, @eId); commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@typ", typeComboBox.Text);
cmd.Parameters.AddWithValue("@fee", feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@pack", packetNumericUpDown.Value);
cmd.Parameters.AddWithValue("@bdate", buyDateTimePickerX.SelectedDateInDateTime.Date);
cmd.Parameters.AddWithValue("@sdate", DateTime.Now.Date);
cmd.Parameters.AddWithValue("@buName", buyerNameTextBox.Text);
cmd.Parameters.AddWithValue("@bId", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd.Parameters.AddWithValue("@bName", bankAccountNameComboBox.Text);
cmd.Parameters.AddWithValue("@newst", stock - feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@des", explainTextBox.Text);
cmd.Parameters.AddWithValue("@eId", ExtensionFunction.PersianToEnglish(enactmentTextbox.Text));
cmd.ExecuteNonQuery();
}
else if (pretype != "اداری فرهنگی" && typeComboBox.Text == "اداری فرهنگی")
{
decimal budget = 0, consume = 0;
SqlCommand cmdget = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
SqlCommand cmdget2 = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
cmdget.Parameters.AddWithValue("@id", "cultureBudget");
cmdget2.Parameters.AddWithValue("@id", "cultureConsume");
using (SqlDataReader reader = cmdget.ExecuteReader())
{
if (reader.Read())
{
budget = reader.GetDecimal(0);
}
}
using (SqlDataReader reader = cmdget2.ExecuteReader())
{
if (reader.Read())
{
consume = reader.GetDecimal(0);
}
}
if (feeNumericUpDown.Value > preFee && consume + feeNumericUpDown.Value - preFee > budget)
{
FMessegeBox.FarsiMessegeBox.Show("این درخواست خارج از محدوده بودجه تعریف شده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
SqlCommand cmdgetam = new SqlCommand("select amount from budgetsCurrencies where typename = @id;", con);
switch (this.pretype)
{
case "گوشت":
cmdgetam.Parameters.AddWithValue("@id", "meat");
break;
case "خواربار":
cmdgetam.Parameters.AddWithValue("@id", "grocery");
break;
case "مرغ":
cmdgetam.Parameters.AddWithValue("@id", "chicken");
break;
case "متفرقه":
cmdgetam.Parameters.AddWithValue("@id", "stock");
break;
}
using (SqlDataReader reader = cmdgetam.ExecuteReader())
{
if (reader.Read())
{
preamount = reader.GetDecimal(0);
}
}
if (preamount < preFee)
{
FMessegeBox.FarsiMessegeBox.Show(String.Format("موجودی {0} برای عودت ارزش ریالی کافی نیست!", this.pretype), "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
DialogResult res = FMessegeBox.FarsiMessegeBox.Show("آیا نسبت به ویرایش خرید این کمک اطمینان دارید؟", "پرسش", FMessegeBox.FMessegeBoxButtons.YesNo, FMessegeBox.FMessegeBoxIcons.Question, FMessegeBox.FMessegeBoxDefaultButton.button1);
if (res != DialogResult.Yes)
{
return;
}
SqlCommand cmdupam, cmdupst;
if (this.prebId != ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text))
{
cmdupst = new SqlCommand("BEGIN TRY begin tran t1; update bankAccount set stock = @st where id = @prev; update bankAccount set stock = @newst where id = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmdupst.Parameters.AddWithValue("@prev", this.prebId);
cmdupst.Parameters.AddWithValue("@st", prestock + preFee);
cmdupst.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmdupst.Parameters.AddWithValue("@newst", stock - feeNumericUpDown.Value);
cmdupst.ExecuteNonQuery();
}
else if (preFee != feeNumericUpDown.Value)
{
cmdupst = new SqlCommand("BEGIN TRY begin tran t1; update bankAccount set stock = @newst where id = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmdupst.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmdupst.Parameters.AddWithValue("@newst", stock + preFee - feeNumericUpDown.Value);
cmdupst.ExecuteNonQuery();
}
cmdupam = new SqlCommand("BEGIN TRY begin tran t1; update budgetsCurrencies set amount = @am where typename = @prev; update budgetsCurrencies set amount = @newam where typename = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
switch (this.pretype)
{
case "گوشت":
cmdupam.Parameters.AddWithValue("@prev", "meat");
break;
case "خواربار":
cmdupam.Parameters.AddWithValue("@prev", "grocery");
break;
case "مرغ":
cmdupam.Parameters.AddWithValue("@prev", "chicken");
break;
case "متفرقه":
cmdupam.Parameters.AddWithValue("@prev", "stock");
break;
}
cmdupam.Parameters.AddWithValue("@id", "cultureConsume");
cmdupam.Parameters.AddWithValue("@am", preamount - preFee);
cmdupam.Parameters.AddWithValue("@newam", amount + feeNumericUpDown.Value);
cmdupam.ExecuteNonQuery();
if (docLabel.BackColor == Color.YellowGreen)
{
string fileName = System.IO.Path.GetFileName(doc);
string targetPath = this.buyHelpPath + "\\" + this.id + "\\";
System.IO.Directory.Delete(targetPath, true);
System.IO.Directory.CreateDirectory(targetPath);
string destFile = System.IO.Path.Combine(targetPath, fileName);
System.IO.File.Copy(doc, destFile, false);
SqlCommand cmdupdatefile = new SqlCommand("BEGIN TRY begin tran t1; delete from doc where id = @id; insert into doc(id, docname, docpath, subdate, doctype) Values(@id, @dname, @dpath, @sdate, @dtype); commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmdupdatefile.Parameters.AddWithValue("@id", this.id);
cmdupdatefile.Parameters.AddWithValue("@dname", fileName);
cmdupdatefile.Parameters.AddWithValue("@dpath", destFile);
cmdupdatefile.Parameters.AddWithValue("@sdate", DateTime.Now.Date);
cmdupdatefile.Parameters.AddWithValue("@dtype", "buyHelp");
cmdupdatefile.ExecuteNonQuery();
}
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; update buyHelps set type = @typ, fee = @fee, packet = @pack, buydate = @bdate, subdate = @sdate, buyerName = @buname, bankAccountId = @bId, bankAccountName = @bName, description = @des where id = @id; insert into buyHelpsHistory (id, type, fee, packet, buydate, subdate, buyerName, bankAccountId, bankAccountName, description, enactmentId) Values(@id, @typ, @fee, @pack, @bdate, @sdate, @buName, @bId, @bName, @des, @eId); commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@typ", typeComboBox.Text);
cmd.Parameters.AddWithValue("@fee", feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@pack", packetNumericUpDown.Value);
cmd.Parameters.AddWithValue("@bdate", buyDateTimePickerX.SelectedDateInDateTime.Date);
cmd.Parameters.AddWithValue("@sdate", DateTime.Now.Date);
cmd.Parameters.AddWithValue("@buName", buyerNameTextBox.Text);
cmd.Parameters.AddWithValue("@bId", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd.Parameters.AddWithValue("@bName", bankAccountNameComboBox.Text);
cmd.Parameters.AddWithValue("@newst", stock - feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@des", explainTextBox.Text);
cmd.Parameters.AddWithValue("@eId", ExtensionFunction.PersianToEnglish(enactmentTextbox.Text));
cmd.ExecuteNonQuery();
}
else
{
SqlCommand cmdgetam = new SqlCommand("select amount from budgetsCurrencies where typename = @id;", con);
switch (typeComboBox.Text)
{
case "گوشت":
cmdgetam.Parameters.AddWithValue("@id", "meat");
break;
case "خواربار":
cmdgetam.Parameters.AddWithValue("@id", "grocery");
break;
case "مرغ":
cmdgetam.Parameters.AddWithValue("@id", "chicken");
break;
case "متفرقه":
cmdgetam.Parameters.AddWithValue("@id", "stock");
break;
}
using (SqlDataReader reader = cmdgetam.ExecuteReader())
{
if (reader.Read())
{
amount = reader.GetDecimal(0);
}
}
if (this.pretype != typeComboBox.Text)
{
cmdgetam = new SqlCommand("select amount from budgetsCurrencies where typename = @id;", con);
switch (this.pretype)
{
case "گوشت":
cmdgetam.Parameters.AddWithValue("@id", "meat");
break;
case "خواربار":
cmdgetam.Parameters.AddWithValue("@id", "grocery");
break;
case "مرغ":
cmdgetam.Parameters.AddWithValue("@id", "chicken");
break;
case "متفرقه":
cmdgetam.Parameters.AddWithValue("@id", "stock");
break;
}
using (SqlDataReader reader = cmdgetam.ExecuteReader())
{
if (reader.Read())
{
preamount = reader.GetDecimal(0);
}
}
if (preamount < preFee)
{
FMessegeBox.FarsiMessegeBox.Show(String.Format("موجودی {0} برای عودت ارزش ریالی کافی نیست!", this.pretype), "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
}
else if (preFee > feeNumericUpDown.Value && amount < preFee - feeNumericUpDown.Value)
{
FMessegeBox.FarsiMessegeBox.Show(String.Format("موجودی {0} برای اصلاح کافی نیست!", typeComboBox.Text), "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
DialogResult res = FMessegeBox.FarsiMessegeBox.Show("آیا نسبت به ویرایش خرید این کمک اطمینان دارید؟", "پرسش", FMessegeBox.FMessegeBoxButtons.YesNo, FMessegeBox.FMessegeBoxIcons.Question, FMessegeBox.FMessegeBoxDefaultButton.button1);
if (res != DialogResult.Yes)
{
return;
}
SqlCommand cmdupam, cmdupst;
if (this.prebId != ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text))
{
cmdupst = new SqlCommand("BEGIN TRY begin tran t1; update bankAccount set stock = @st where id = @prev; update bankAccount set stock = @newst where id = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmdupst.Parameters.AddWithValue("@prev", this.prebId);
cmdupst.Parameters.AddWithValue("@st", prestock + preFee);
cmdupst.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmdupst.Parameters.AddWithValue("@newst", stock - feeNumericUpDown.Value);
cmdupst.ExecuteNonQuery();
}
else if (preFee != feeNumericUpDown.Value)
{
cmdupst = new SqlCommand("BEGIN TRY begin tran t1; update bankAccount set stock = @newst where id = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmdupst.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmdupst.Parameters.AddWithValue("@newst", stock + preFee - feeNumericUpDown.Value);
cmdupst.ExecuteNonQuery();
}
if (this.pretype != typeComboBox.Text)
{
cmdupam = new SqlCommand("BEGIN TRY begin tran t1; update budgetsCurrencies set amount = @am where typename = @prev; update budgetsCurrencies set amount = @newam where typename = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
switch (this.pretype)
{
case "گوشت":
cmdupam.Parameters.AddWithValue("@prev", "meat");
break;
case "خواربار":
cmdupam.Parameters.AddWithValue("@prev", "grocery");
break;
case "مرغ":
cmdupam.Parameters.AddWithValue("@prev", "chicken");
break;
case "متفرقه":
cmdupam.Parameters.AddWithValue("@prev", "stock");
break;
}
if (typeComboBox.Text == "گوشت")
{
cmdupam.Parameters.AddWithValue("@id", "meat");
}
else if (typeComboBox.Text == "مرغ")
{
cmdupam.Parameters.AddWithValue("@id", "chicken");
}
else if (typeComboBox.Text == "خواربار")
{
cmdupam.Parameters.AddWithValue("@id", "grocery");
}
else if (typeComboBox.Text == "متفرقه")
{
cmdupam.Parameters.AddWithValue("@id", "stock");
}
cmdupam.Parameters.AddWithValue("@am", preamount - preFee);
cmdupam.Parameters.AddWithValue("@newam", amount + feeNumericUpDown.Value);
cmdupam.ExecuteNonQuery();
}
else if (preFee != feeNumericUpDown.Value)
{
cmdupam = new SqlCommand("BEGIN TRY begin tran t1; update budgetsCurrencies set amount = @newam where typename = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
if (typeComboBox.Text == "گوشت")
{
cmdupam.Parameters.AddWithValue("@id", "meat");
}
else if (typeComboBox.Text == "مرغ")
{
cmdupam.Parameters.AddWithValue("@id", "chicken");
}
else if (typeComboBox.Text == "خواربار")
{
cmdupam.Parameters.AddWithValue("@id", "grocery");
}
else if (typeComboBox.Text == "متفرقه")
{
cmdupam.Parameters.AddWithValue("@id", "stock");
}
cmdupam.Parameters.AddWithValue("@newam", amount + feeNumericUpDown.Value - preFee);
cmdupam.ExecuteNonQuery();
}
if (docLabel.BackColor == Color.YellowGreen)
{
string fileName = System.IO.Path.GetFileName(doc);
string targetPath = this.buyHelpPath + "\\" + this.id + "\\";
System.IO.Directory.Delete(targetPath, true);
System.IO.Directory.CreateDirectory(targetPath);
string destFile = System.IO.Path.Combine(targetPath, fileName);
System.IO.File.Copy(doc, destFile, false);
SqlCommand cmdupdatefile = new SqlCommand("BEGIN TRY begin tran t1; delete from doc where id = @id; insert into doc(id, docname, docpath, subdate, doctype) Values(@id, @dname, @dpath, @sdate, @dtype); commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmdupdatefile.Parameters.AddWithValue("@id", this.id);
cmdupdatefile.Parameters.AddWithValue("@dname", fileName);
cmdupdatefile.Parameters.AddWithValue("@dpath", destFile);
cmdupdatefile.Parameters.AddWithValue("@sdate", DateTime.Now.Date);
cmdupdatefile.Parameters.AddWithValue("@dtype", "buyHelp");
cmdupdatefile.ExecuteNonQuery();
}
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; update buyHelps set type = @typ, fee = @fee, packet = @pack, buydate = @bdate, subdate = @sdate, buyerName = @buname, bankAccountId = @bId, bankAccountName = @bName, description = @des where id = @id; insert into buyHelpsHistory (id, type, fee, packet, buydate, subdate, buyerName, bankAccountId, bankAccountName, description, enactmentId) Values(@id, @typ, @fee, @pack, @bdate, @sdate, @buName, @bId, @bName, @des, @eId); commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@typ", typeComboBox.Text);
cmd.Parameters.AddWithValue("@fee", feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@pack", packetNumericUpDown.Value);
cmd.Parameters.AddWithValue("@bdate", buyDateTimePickerX.SelectedDateInDateTime.Date);
cmd.Parameters.AddWithValue("@sdate", DateTime.Now.Date);
cmd.Parameters.AddWithValue("@buName", buyerNameTextBox.Text);
cmd.Parameters.AddWithValue("@bId", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd.Parameters.AddWithValue("@bName", bankAccountNameComboBox.Text);
cmd.Parameters.AddWithValue("@newst", stock - feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@des", explainTextBox.Text);
cmd.Parameters.AddWithValue("@eId", ExtensionFunction.PersianToEnglish(enactmentTextbox.Text));
cmd.ExecuteNonQuery();
}
FMessegeBox.FarsiMessegeBox.Show("خرید کمک با موفقیت ویرایش شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
con.Close();
this.Close();
}
private void addButton_Click(object sender, EventArgs e)
{
if (String.IsNullOrWhiteSpace(bankAccountNameTextBox.Text))
{
bankAccountNameTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("نام حساب وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (!bankAccountNumberTextBox.Text.All(char.IsDigit))
{
bankAccountNumberTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("شماره حساب باید فقط شامل ارقام باشد!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (String.IsNullOrWhiteSpace(bankNameTextBox.Text))
{
bankNameTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("نام بانک وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
/*if (!bankNameTextBox.Text.All(c => char.IsWhiteSpace(c) || char.IsLetter(c)))
* {
* bankNameTextBox.BackColor = Color.Tomato;
* FMessegeBox.FarsiMessegeBox.Show("نام بانک باید فقط شامل حروف و فاصله باشد!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
* return;
* }*/
if (String.IsNullOrWhiteSpace(bankAccountOwnerNameTextBox.Text))
{
bankAccountOwnerNameTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("نام صاحب حساب وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
/*if (!bankAccountOwnerNameTextBox.Text.All(c => char.IsWhiteSpace(c) || char.IsLetter(c)))
* {
* bankAccountOwnerNameTextBox.BackColor = Color.Tomato;
* FMessegeBox.FarsiMessegeBox.Show("نام صاحب حساب باید فقط شامل حروف و فاصله باشد!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
* return;
* }*/
if (String.IsNullOrWhiteSpace(explainTextBox.Text))
{
explainTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("توضیحات وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
SqlConnection con = new SqlConnection(this.connection);
con.Open();
SqlCommand cmdcheck = new SqlCommand("select id, name from bankAccount;", con);
List <KeyValuePair <string, string> > li = new List <KeyValuePair <string, string> >();
using (SqlDataReader reader = cmdcheck.ExecuteReader())
{
while (reader.Read())
{
li.Add(new KeyValuePair <string, string>(reader.GetString(0), reader.GetString(0)));
}
}
bool flag = true;
foreach (var ac in li)
{
if (ac.Key == bankAccountNumberTextBox.Text || ac.Value == bankAccountNameTextBox.Text)
{
flag = false;
break;
}
}
if (!flag)
{
FMessegeBox.FarsiMessegeBox.Show("حساب دیگری با این نام یا شماره حساب موجود است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; insert into bankAccount (id, name, bankName, stock, ownerName) Values(@id, @name, @bname, @st, @oname); insert into backAccountInfoHistory (id, name, bankName, ownerName, subdate, enactmentId, description) Values (@id, @name, @bname, @oname, @sdate, @eId, @des); commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd.Parameters.AddWithValue("@name", bankAccountNameTextBox.Text);
cmd.Parameters.AddWithValue("@bname", bankNameTextBox.Text);
cmd.Parameters.AddWithValue("@st", 0);
cmd.Parameters.AddWithValue("@oname", bankAccountOwnerNameTextBox.Text);
cmd.Parameters.AddWithValue("@sdate", createDateTimePickerX.SelectedDateInDateTime.Date);
cmd.Parameters.AddWithValue("@eId", ExtensionFunction.PersianToEnglish(enactmentTextbox.Text));
cmd.Parameters.AddWithValue("@des", "(ایجاد حساب)" + explainTextBox.Text);
cmd.ExecuteNonQuery();
con.Close();
FMessegeBox.FarsiMessegeBox.Show("حساب با موفقیت ثبت شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
this.Close();
}
private void addButton_Click(object sender, EventArgs e)
{
if (String.IsNullOrWhiteSpace(idTextBox.Text))
{
idTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("شماره نامه وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (String.IsNullOrWhiteSpace(titleTextBox.Text))
{
titleTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("عنوان وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (String.IsNullOrWhiteSpace(senderTextBox.Text))
{
senderTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("فرستنده وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (String.IsNullOrWhiteSpace(signerTextBox.Text))
{
signerTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("امضاکننده وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (docLabel.BackColor == Color.Red)
{
FMessegeBox.FarsiMessegeBox.Show("فایل نامه انتخاب نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (attachmentCheckBox.Checked && attachmentLabel.BackColor == Color.Red)
{
FMessegeBox.FarsiMessegeBox.Show("فایلهای پیوست انتخاب نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
DialogResult res = FMessegeBox.FarsiMessegeBox.Show("آیا نسبت به ویرایش نامه اطمینان دارید؟", "پرسش", FMessegeBox.FMessegeBoxButtons.YesNo, FMessegeBox.FMessegeBoxIcons.Question, FMessegeBox.FMessegeBoxDefaultButton.button1);
if (res != DialogResult.Yes)
{
return;
}
SqlConnection con = new SqlConnection(this.connection);
con.Open();
if (docLabel.BackColor == Color.YellowGreen)
{
string fileName = System.IO.Path.GetFileName(doc);
string iddir = this.receivedLettersPath + "\\" + this.id;
System.IO.Directory.CreateDirectory(iddir);
string targetPath = iddir + "\\" + "doc";
System.IO.Directory.Delete(targetPath, true);
System.IO.Directory.CreateDirectory(targetPath);
string destFile = System.IO.Path.Combine(targetPath, fileName);
System.IO.File.Copy(doc, destFile, false);
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; update receivedLetters set id_i = @id_i, title = @title, sender = @sender, signer = @signer, attachment = @attach, recdate = @recdate, subdate = @subdate where id = @id; insert into receivedLettersHistory (id_i, id, title, sender, signer, attachment, recdate, subdate, enactmentId) Values(@id_i, @id, @title, @sender, @signer, @attach, @recdate, @subdate, @eId); delete from doc where id = @id and doctype = 'Letter'; insert into doc(id, docname, docpath, subdate, doctype) Values(@id, @dname, @dpath, @subdate, @dtype); commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id_i", idTextBox.Text);
cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@title", titleTextBox.Text);
cmd.Parameters.AddWithValue("@sender", senderTextBox.Text);
cmd.Parameters.AddWithValue("@signer", signerTextBox.Text);
cmd.Parameters.AddWithValue("@eId", ExtensionFunction.PersianToEnglish(enactmentTextbox.Text));
if (attachmentCheckBox.Checked)
{
cmd.Parameters.AddWithValue("@attach", "بله");
}
else
{
cmd.Parameters.AddWithValue("@attach", "خیر");
SqlCommand cmddel = new SqlCommand("delete from doc where id = @id and doctype = 'LetterAttachment';", con);
cmddel.Parameters.AddWithValue("@id", this.id);
cmddel.ExecuteNonQuery();
if (System.IO.Directory.Exists(this.receivedLettersPath + "\\" + this.id + "\\attachments"))
{
System.IO.Directory.Delete(this.receivedLettersPath + "\\" + this.id + "\\attachments", true);
}
}
cmd.Parameters.AddWithValue("@recdate", recDateTimePickerX.SelectedDateInDateTime.Date);
cmd.Parameters.AddWithValue("@subdate", DateTime.Now.Date);
cmd.Parameters.AddWithValue("@dname", fileName);
cmd.Parameters.AddWithValue("@dpath", destFile);
cmd.Parameters.AddWithValue("@dtype", "Letter");
cmd.ExecuteNonQuery();
}
else
{
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; update receivedLetters set id_i = @id_i, title = @title, sender = @sender, signer = @signer, attachment = @attach, recdate = @recdate, subdate = @subdate where id = @id; insert into receivedLettersHistory (id_i, id, title, sender, signer, attachment, recdate, subdate, enactmentId) Values(@id_i, @id, @title, @sender, @signer, @attach, @recdate, @subdate, @eId); commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id_i", idTextBox.Text);
cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@title", titleTextBox.Text);
cmd.Parameters.AddWithValue("@sender", senderTextBox.Text);
cmd.Parameters.AddWithValue("@signer", signerTextBox.Text);
cmd.Parameters.AddWithValue("@eId", ExtensionFunction.PersianToEnglish(enactmentTextbox.Text));
if (attachmentCheckBox.Checked)
{
cmd.Parameters.AddWithValue("@attach", "بله");
}
else
{
cmd.Parameters.AddWithValue("@attach", "خیر");
SqlCommand cmddel = new SqlCommand("delete from doc where id = @id and doctype = 'LetterAttachment';", con);
cmddel.Parameters.AddWithValue("@id", this.id);
cmddel.ExecuteNonQuery();
if (System.IO.Directory.Exists(this.receivedLettersPath + "\\" + this.id + "\\attachments"))
{
System.IO.Directory.Delete(this.receivedLettersPath + "\\" + this.id + "\\attachments", true);
}
}
cmd.Parameters.AddWithValue("@recdate", recDateTimePickerX.SelectedDateInDateTime.Date);
cmd.Parameters.AddWithValue("@subdate", DateTime.Now.Date);
cmd.ExecuteNonQuery();
}
con.Close();
FMessegeBox.FarsiMessegeBox.Show("نامه دریافتی با موفقیت ویرایش شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
this.Close();
}
private void addButton_Click(object sender, EventArgs e)
{
if (String.IsNullOrWhiteSpace(idTextBox.Text))
{
idTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("شماره ملی مددکار وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (!idTextBox.Text.All(char.IsDigit) || idTextBox.TextLength != 10)
{
idTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("شماره ملی مددکار باید فقط شامل ارقام و 10 رقم باشد!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (String.IsNullOrWhiteSpace(nameTextBox.Text))
{
nameTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("نام مددکار وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (!nameTextBox.Text.All(c => char.IsWhiteSpace(c) || char.IsLetter(c)))
{
nameTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("نام مددکار باید فقط شامل حروف و فاصله باشد!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (String.IsNullOrWhiteSpace(familyTextBox.Text))
{
familyTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("نام خانوادگی مددکار وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (!familyTextBox.Text.All(c => char.IsWhiteSpace(c) || char.IsLetter(c)))
{
familyTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("نام خانوادگی مددکار باید فقط شامل حروف و فاصله باشد!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (String.IsNullOrWhiteSpace(phoneTextBox.Text))
{
phoneTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("شماره تلفن مددکار وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (!phoneTextBox.Text.All(char.IsDigit))
{
phoneTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("شماره تلفن مددکار باید فقط شامل ارقام و 10 رقم باشد!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (String.IsNullOrWhiteSpace(addressTextBox.Text))
{
addressTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("آدرس مددکار وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
DialogResult res = FMessegeBox.FarsiMessegeBox.Show("آیا نسبت به ویرایش این مددکار اطمینان دارید؟", "پرسش", FMessegeBox.FMessegeBoxButtons.YesNo, FMessegeBox.FMessegeBoxIcons.Question, FMessegeBox.FMessegeBoxDefaultButton.button1);
if (res != DialogResult.Yes)
{
return;
}
SqlConnection con = new SqlConnection(this.connection);
con.Open();
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; delete from helper where id = @prev; insert into helper(id, name, family, phone, address, subdate) Values(@id, @name, @family, @phone, @address, @sdate); insert into helperInfoHistory (id, name, family, phone, address, subdate) Values(@id, @name, @family, @phone, @address, @sdate); commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@prev", this.id);
cmd.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(idTextBox.Text));
cmd.Parameters.AddWithValue("@name", nameTextBox.Text);
cmd.Parameters.AddWithValue("@family", familyTextBox.Text);
cmd.Parameters.AddWithValue("@phone", ExtensionFunction.PersianToEnglish(phoneTextBox.Text));
cmd.Parameters.AddWithValue("@address", addressTextBox.Text);
cmd.Parameters.AddWithValue("@sdate", DateTime.Now.Date);
cmd.ExecuteNonQuery();
FMessegeBox.FarsiMessegeBox.Show("اطلاعات مددکار با موفقیت ویرایش شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
con.Close();
this.Close();
}
private void addButton_Click(object sender, EventArgs e)
{
if (String.IsNullOrWhiteSpace(idTextBox.Text))
{
idTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("شماره نامه وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (String.IsNullOrWhiteSpace(titleTextBox.Text))
{
titleTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("عنوان وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (String.IsNullOrWhiteSpace(senderTextBox.Text))
{
senderTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("فرستنده وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (String.IsNullOrWhiteSpace(signerTextBox.Text))
{
signerTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("امضاکننده وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (docLabel.BackColor == Color.Red)
{
FMessegeBox.FarsiMessegeBox.Show("فایل نامه انتخاب نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (attachmentCheckBox.Checked && attachmentLabel.BackColor == Color.Red)
{
FMessegeBox.FarsiMessegeBox.Show("فایلهای پیوست انتخاب نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
DialogResult res = FMessegeBox.FarsiMessegeBox.Show("آیا نسبت به ثبت نامه اطمینان دارید؟", "پرسش", FMessegeBox.FMessegeBoxButtons.YesNo, FMessegeBox.FMessegeBoxIcons.Question, FMessegeBox.FMessegeBoxDefaultButton.button1);
if (res != DialogResult.Yes)
{
return;
}
this.id = "RL" + ExtensionFunction.PersianToEnglish(idTextBox.Text);
string fileName = System.IO.Path.GetFileName(doc);
string iddir = this.receivedLettersPath + "\\" + this.id;
System.IO.Directory.CreateDirectory(iddir);
string targetPath = iddir + "\\" + "doc";
System.IO.Directory.CreateDirectory(targetPath);
string destFile = System.IO.Path.Combine(targetPath, fileName);
System.IO.File.Copy(doc, destFile, false);
SqlConnection con = new SqlConnection(this.connection);
con.Open();
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; insert into receivedLetters (id_i, id, title, sender, signer, attachment, recdate, subdate) Values(@id_i, @id, @title, @sender, @signer, @attach, @recdate, @subdate); insert into receivedLettersHistory (id_i, id, title, sender, signer, attachment, recdate, subdate) Values(@id_i, @id, @title, @sender, @signer, @attach, @recdate, @subdate); insert into doc(id, docname, docpath, subdate, doctype) Values(@id, @dname, @dpath, @subdate, @dtype); commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@id_i", idTextBox.Text);
cmd.Parameters.AddWithValue("@title", titleTextBox.Text);
cmd.Parameters.AddWithValue("@sender", senderTextBox.Text);
cmd.Parameters.AddWithValue("@signer", signerTextBox.Text);
if (attachmentCheckBox.Checked)
{
cmd.Parameters.AddWithValue("@attach", "بله");
}
else
{
cmd.Parameters.AddWithValue("@attach", "خیر");
}
cmd.Parameters.AddWithValue("@recdate", recDateTimePickerX.SelectedDateInDateTime.Date);
cmd.Parameters.AddWithValue("@subdate", DateTime.Now.Date);
cmd.Parameters.AddWithValue("@dname", fileName);
cmd.Parameters.AddWithValue("@dpath", destFile);
cmd.Parameters.AddWithValue("@dtype", "Letter");
cmd.ExecuteNonQuery();
if (attachmentCheckBox.Checked)
{
this.attachments = attli.ToArray();
foreach (string attachment in this.attachments)
{
int i = 2;
fileName = System.IO.Path.GetFileName(attachment);
targetPath = iddir + "\\" + "attachments";
System.IO.Directory.CreateDirectory(targetPath);
destFile = System.IO.Path.Combine(targetPath, fileName);
while (System.IO.File.Exists(destFile))
{
destFile = System.IO.Path.Combine(targetPath, fileName + "(" + i.ToString() + ")");
i++;
}
System.IO.File.Copy(doc, destFile, false);
SqlCommand cmdattach = new SqlCommand("insert into doc(id, docname, docpath, subdate, doctype) Values(@id, @dname, @dpath, @subdate, @dtype);", con);
cmdattach.Parameters.AddWithValue("@id", this.id);
cmdattach.Parameters.AddWithValue("@subdate", DateTime.Now.Date);
cmdattach.Parameters.AddWithValue("@dname", fileName);
cmdattach.Parameters.AddWithValue("@dpath", destFile);
cmdattach.Parameters.AddWithValue("@dtype", "LetterAttachment");
cmdattach.ExecuteNonQuery();
}
}
con.Close();
FMessegeBox.FarsiMessegeBox.Show("نامه دریافتی با موفقیت ثبت شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
this.Close();
}
private void addButton_Click(object sender, EventArgs e)
{
if (!helperIdTextbox.Text.All(char.IsDigit) || helperIdTextbox.TextLength != 10)
{
helperIdTextbox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("شناسه ملی اهداکننده باید فقط شامل ارقام و 10 رقم باشد!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (!String.IsNullOrWhiteSpace(helperIdTextbox.Text) && String.IsNullOrWhiteSpace(helperNameTextBox.Text))
{
helperIdTextbox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("شماره ملی وارد شده ولی نام اهداکننده بررسی نشده یا وجود ندارد!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (String.IsNullOrWhiteSpace(explainTextBox.Text))
{
explainTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("ذکر توضیحات الزامی است. توضیحی وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
SqlConnection con = new SqlConnection(this.connection);
con.Open();
decimal stock = 0, prestock = 0;
if (cashRadioButton.Checked && this.precashtype == "نقدی")
{
SqlCommand cmdget = new SqlCommand("select stock from bankAccount where id = @id", con);
cmdget.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
using (SqlDataReader reader = cmdget.ExecuteReader())
{
if (reader.Read())
{
stock = reader.GetDecimal(0);
}
}
if (this.prebId != ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text))
{
SqlCommand cmdget2 = new SqlCommand("select stock from bankAccount where id = @id", con);
cmdget2.Parameters.AddWithValue("@id", this.prebId);
using (SqlDataReader reader = cmdget2.ExecuteReader())
{
if (reader.Read())
{
prestock = reader.GetDecimal(0);
}
}
}
}
else if (cashRadioButton.Checked && this.precashtype != "نقدی")
{
SqlCommand cmdget = new SqlCommand("select stock from bankAccount where id = @id", con);
cmdget.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
using (SqlDataReader reader = cmdget.ExecuteReader())
{
if (reader.Read())
{
stock = reader.GetDecimal(0);
}
}
SqlCommand cmdget2 = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
switch (typeTextBox.Text)
{
case "گوشت":
cmdget2.Parameters.AddWithValue("@id", "meat");
break;
case "خواربار":
cmdget2.Parameters.AddWithValue("@id", "grocery");
break;
case "مرغ":
cmdget2.Parameters.AddWithValue("@id", "chicken");
break;
case "ازدواج":
cmdget2.Parameters.AddWithValue("@id", "marry");
break;
case "ایتام":
cmdget2.Parameters.AddWithValue("@id", "orphan");
break;
case "متفرقه":
cmdget2.Parameters.AddWithValue("@id", "stock");
break;
}
using (SqlDataReader reader = cmdget2.ExecuteReader())
{
if (reader.Read())
{
prestock = reader.GetDecimal(0);
}
}
}
else if (!cashRadioButton.Checked && this.precashtype == "نقدی")
{
SqlCommand cmdget2 = new SqlCommand("select stock from bankAccount where id = @id", con);
cmdget2.Parameters.AddWithValue("@id", this.prebId);
using (SqlDataReader reader = cmdget2.ExecuteReader())
{
if (reader.Read())
{
prestock = reader.GetDecimal(0);
}
}
SqlCommand cmdget = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
switch (typeTextBox.Text)
{
case "گوشت":
cmdget.Parameters.AddWithValue("@id", "meat");
break;
case "خواربار":
cmdget.Parameters.AddWithValue("@id", "grocery");
break;
case "مرغ":
cmdget.Parameters.AddWithValue("@id", "chicken");
break;
case "ازدواج":
cmdget.Parameters.AddWithValue("@id", "marry");
break;
case "ایتام":
cmdget.Parameters.AddWithValue("@id", "orphan");
break;
case "متفرقه":
cmdget.Parameters.AddWithValue("@id", "stock");
break;
}
using (SqlDataReader reader = cmdget.ExecuteReader())
{
if (reader.Read())
{
stock = reader.GetDecimal(0);
}
}
}
else
{
SqlCommand cmdget = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
switch (typeTextBox.Text)
{
case "گوشت":
cmdget.Parameters.AddWithValue("@id", "meat");
break;
case "خواربار":
cmdget.Parameters.AddWithValue("@id", "grocery");
break;
case "مرغ":
cmdget.Parameters.AddWithValue("@id", "chicken");
break;
case "ازدواج":
cmdget.Parameters.AddWithValue("@id", "marry");
break;
case "ایتام":
cmdget.Parameters.AddWithValue("@id", "orphan");
break;
case "متفرقه":
cmdget.Parameters.AddWithValue("@id", "stock");
break;
}
using (SqlDataReader reader = cmdget.ExecuteReader())
{
if (reader.Read())
{
stock = reader.GetDecimal(0);
}
}
}
if ((this.precashtype == "نقدی" && (nonCashRadioButton.Checked || this.prebId != ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text))) || (this.precashtype == "غیرنقدی" && cashRadioButton.Checked))
{
if (prestock < preFee)
{
FMessegeBox.FarsiMessegeBox.Show("موجودی حساب قبلی از ارزش ریالی ثبت شده قبلی کمتر میباشد!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
}
if ((this.precashtype == "نقدی" && cashRadioButton.Checked) || (this.precashtype == "غیرنقدی" && nonCashRadioButton.Checked))
{
if (feeNumericUpDown.Value < preFee && stock < preFee - feeNumericUpDown.Value)
{
FMessegeBox.FarsiMessegeBox.Show("موجودی برای ویرایش کافی نیست!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
}
DialogResult res = FMessegeBox.FarsiMessegeBox.Show("آیا نسبت به ثبت دریافت این کمک اطمینان دارید؟", "پرسش", FMessegeBox.FMessegeBoxButtons.YesNo, FMessegeBox.FMessegeBoxIcons.Question, FMessegeBox.FMessegeBoxDefaultButton.button1);
if (res != DialogResult.Yes)
{
return;
}
if (docLabel.BackColor == Color.YellowGreen)
{
string fileName = System.IO.Path.GetFileName(doc);
string targetPath = this.recHelpPath + "\\" + this.id + "\\";
System.IO.Directory.Delete(targetPath, true);
System.IO.Directory.CreateDirectory(targetPath);
string destFile = System.IO.Path.Combine(targetPath, fileName);
System.IO.File.Copy(doc, destFile, false);
SqlCommand cmdupdatefile = new SqlCommand("BEGIN TRY begin tran t1; delete from doc where id = @id; insert into doc(id, docname, docpath, subdate, doctype) Values(@id, @dname, @dpath, @sdate, @dtype); commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmdupdatefile.Parameters.AddWithValue("@id", this.id);
cmdupdatefile.Parameters.AddWithValue("@dname", fileName);
cmdupdatefile.Parameters.AddWithValue("@dpath", destFile);
cmdupdatefile.Parameters.AddWithValue("@sdate", DateTime.Now.Date);
cmdupdatefile.Parameters.AddWithValue("@dtype", "recHelp");
cmdupdatefile.ExecuteNonQuery();
}
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; update recHelps set fee = @fee, packet = @pack, recdate = @rdate, subdate = @sdate, helperId = @hId, helperName = @hName, bankAccountId = @bId, bankAccountName = @bName, description = @des, cashtype = @cashtype where id = @id; insert into recHelpsHistory (id, type, fee, packet, recdate, subdate, helperId, helperName, bankAccountId, bankAccountName, description, enactmentId, cashtype) Values(@id, @typ, @fee, @pack, @rdate, @sdate, @hId, @hName, @bId, @bName, @des, @eId, @cashtype); commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@typ", typeTextBox.Text);
cmd.Parameters.AddWithValue("@fee", feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@pack", packetNumericUpDown.Value);
cmd.Parameters.AddWithValue("@rdate", recDateTimePickerX.SelectedDateInDateTime.Date);
cmd.Parameters.AddWithValue("@sdate", DateTime.Now.Date);
cmd.Parameters.AddWithValue("@hId", ExtensionFunction.PersianToEnglish(helperIdTextbox.Text));
cmd.Parameters.AddWithValue("@hName", helperNameTextBox.Text);
cmd.Parameters.AddWithValue("@bId", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd.Parameters.AddWithValue("@bName", bankAccountNameComboBox.Text);
cmd.Parameters.AddWithValue("@des", explainTextBox.Text);
cmd.Parameters.AddWithValue("@eId", ExtensionFunction.PersianToEnglish(enactmentTextbox.Text));
if (cashRadioButton.Checked)
{
cmd.Parameters.AddWithValue("@cashtype", "نقدی");
}
else
{
cmd.Parameters.AddWithValue("@cashtype", "غیرنقدی");
}
cmd.ExecuteNonQuery();
SqlCommand cmd2;
if (this.precashtype == "نقدی" && cashRadioButton.Checked)
{
if (this.prebId != ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text))
{
cmd2 = new SqlCommand("BEGIN TRY begin tran t1; update bankAccount set stock = @st where id = @prev; update bankAccount set stock = @newst where id = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd2.Parameters.AddWithValue("@prev", this.prebId);
cmd2.Parameters.AddWithValue("@st", prestock - preFee);
cmd2.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd2.Parameters.AddWithValue("@newst", stock + feeNumericUpDown.Value);
cmd2.ExecuteNonQuery();
}
else
{
cmd2 = new SqlCommand("update bankAccount set stock = @st where id = @id;", con);
cmd2.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd2.Parameters.AddWithValue("@st", stock - (preFee - feeNumericUpDown.Value));
cmd2.ExecuteNonQuery();
}
}
else if (typeTextBox.Text == "گوشت")
{
if (this.precashtype == "نقدی" && nonCashRadioButton.Checked)
{
cmd2 = new SqlCommand("BEGIN TRY begin tran t1; update bankAccount set stock = @st where id = @prev; update budgetsCurrencies set amount = @newst where typename = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd2.Parameters.AddWithValue("@prev", this.prebId);
cmd2.Parameters.AddWithValue("@st", prestock - preFee);
cmd2.Parameters.AddWithValue("@id", "meet");
cmd2.Parameters.AddWithValue("@newst", stock + feeNumericUpDown.Value);
cmd2.ExecuteNonQuery();
}
else if (this.precashtype == "غیرنقدی" && cashRadioButton.Checked)
{
cmd2 = new SqlCommand("BEGIN TRY begin tran t1; update budgetsCurrencies set amount = @st where typename = @prev; update bankAccount set stock = @st where id = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd2.Parameters.AddWithValue("@prev", "meet");
cmd2.Parameters.AddWithValue("@st", prestock - preFee);
cmd2.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd2.Parameters.AddWithValue("@newst", stock + feeNumericUpDown.Value);
cmd2.ExecuteNonQuery();
}
else
{
cmd2 = new SqlCommand("update budgetsCurrencies set amount = @amount where typename = @typ;", con);
cmd2.Parameters.AddWithValue("@typ", "meat");
cmd2.Parameters.AddWithValue("@amount", stock - (preFee - feeNumericUpDown.Value));
cmd2.ExecuteNonQuery();
}
}
else if (typeTextBox.Text == "مرغ")
{
if (this.precashtype == "نقدی" && nonCashRadioButton.Checked)
{
cmd2 = new SqlCommand("BEGIN TRY begin tran t1; update bankAccount set stock = @st where id = @prev; update budgetsCurrencies set amount = @newst where typename = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd2.Parameters.AddWithValue("@prev", this.prebId);
cmd2.Parameters.AddWithValue("@st", prestock - preFee);
cmd2.Parameters.AddWithValue("@id", "chicken");
cmd2.Parameters.AddWithValue("@newst", stock + feeNumericUpDown.Value);
cmd2.ExecuteNonQuery();
}
else if (this.precashtype == "غیرنقدی" && cashRadioButton.Checked)
{
cmd2 = new SqlCommand("BEGIN TRY begin tran t1; update budgetsCurrencies set amount = @st where typename = @prev; update bankAccount set stock = @st where id = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd2.Parameters.AddWithValue("@prev", "chicken");
cmd2.Parameters.AddWithValue("@st", prestock - preFee);
cmd2.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd2.Parameters.AddWithValue("@newst", stock + feeNumericUpDown.Value);
cmd2.ExecuteNonQuery();
}
else
{
cmd2 = new SqlCommand("update budgetsCurrencies set amount = @amount where typename = @typ;", con);
cmd2.Parameters.AddWithValue("@typ", "chicken");
cmd2.Parameters.AddWithValue("@amount", stock - (preFee - feeNumericUpDown.Value));
cmd2.ExecuteNonQuery();
}
}
else if (typeTextBox.Text == "خواربار")
{
if (this.precashtype == "نقدی" && nonCashRadioButton.Checked)
{
cmd2 = new SqlCommand("BEGIN TRY begin tran t1; update bankAccount set stock = @st where id = @prev; update budgetsCurrencies set amount = @newst where typename = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd2.Parameters.AddWithValue("@prev", this.prebId);
cmd2.Parameters.AddWithValue("@st", prestock - preFee);
cmd2.Parameters.AddWithValue("@id", "grocery");
cmd2.Parameters.AddWithValue("@newst", stock + feeNumericUpDown.Value);
cmd2.ExecuteNonQuery();
}
else if (this.precashtype == "غیرنقدی" && cashRadioButton.Checked)
{
cmd2 = new SqlCommand("BEGIN TRY begin tran t1; update budgetsCurrencies set amount = @st where typename = @prev; update bankAccount set stock = @st where id = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd2.Parameters.AddWithValue("@prev", "grocery");
cmd2.Parameters.AddWithValue("@st", prestock - preFee);
cmd2.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd2.Parameters.AddWithValue("@newst", stock + feeNumericUpDown.Value);
cmd2.ExecuteNonQuery();
}
else
{
cmd2 = new SqlCommand("update budgetsCurrencies set amount = @amount where typename = @typ;", con);
cmd2.Parameters.AddWithValue("@typ", "grocery");
cmd2.Parameters.AddWithValue("@amount", stock - (preFee - feeNumericUpDown.Value));
cmd2.ExecuteNonQuery();
}
}
else if (typeTextBox.Text == "ازدواج")
{
if (this.precashtype == "نقدی" && nonCashRadioButton.Checked)
{
cmd2 = new SqlCommand("BEGIN TRY begin tran t1; update bankAccount set stock = @st where id = @prev; update budgetsCurrencies set amount = @newst where typename = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd2.Parameters.AddWithValue("@prev", this.prebId);
cmd2.Parameters.AddWithValue("@st", prestock - preFee);
cmd2.Parameters.AddWithValue("@id", "marry");
cmd2.Parameters.AddWithValue("@newst", stock + feeNumericUpDown.Value);
cmd2.ExecuteNonQuery();
}
else if (this.precashtype == "غیرنقدی" && cashRadioButton.Checked)
{
cmd2 = new SqlCommand("BEGIN TRY begin tran t1; update budgetsCurrencies set amount = @st where typename = @prev; update bankAccount set stock = @st where id = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd2.Parameters.AddWithValue("@prev", "marry");
cmd2.Parameters.AddWithValue("@st", prestock - preFee);
cmd2.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd2.Parameters.AddWithValue("@newst", stock + feeNumericUpDown.Value);
cmd2.ExecuteNonQuery();
}
else
{
cmd2 = new SqlCommand("update budgetsCurrencies set amount = @amount where typename = @typ;", con);
cmd2.Parameters.AddWithValue("@typ", "marry");
cmd2.Parameters.AddWithValue("@amount", stock - (preFee - feeNumericUpDown.Value));
cmd2.ExecuteNonQuery();
}
}
else if (typeTextBox.Text == "ایتام")
{
if (this.precashtype == "نقدی" && nonCashRadioButton.Checked)
{
cmd2 = new SqlCommand("BEGIN TRY begin tran t1; update bankAccount set stock = @st where id = @prev; update budgetsCurrencies set amount = @newst where typename = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd2.Parameters.AddWithValue("@prev", this.prebId);
cmd2.Parameters.AddWithValue("@st", prestock - preFee);
cmd2.Parameters.AddWithValue("@id", "orphan");
cmd2.Parameters.AddWithValue("@newst", stock + feeNumericUpDown.Value);
cmd2.ExecuteNonQuery();
}
else if (this.precashtype == "غیرنقدی" && cashRadioButton.Checked)
{
cmd2 = new SqlCommand("BEGIN TRY begin tran t1; update budgetsCurrencies set amount = @st where typename = @prev; update bankAccount set stock = @st where id = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd2.Parameters.AddWithValue("@prev", "orphan");
cmd2.Parameters.AddWithValue("@st", prestock - preFee);
cmd2.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd2.Parameters.AddWithValue("@newst", stock + feeNumericUpDown.Value);
cmd2.ExecuteNonQuery();
}
else
{
cmd2 = new SqlCommand("update budgetsCurrencies set amount = @amount where typename = @typ;", con);
cmd2.Parameters.AddWithValue("@typ", "orphan");
cmd2.Parameters.AddWithValue("@amount", stock - (preFee - feeNumericUpDown.Value));
cmd2.ExecuteNonQuery();
}
}
else if (typeTextBox.Text == "متفرقه")
{
if (this.precashtype == "نقدی" && nonCashRadioButton.Checked)
{
cmd2 = new SqlCommand("BEGIN TRY begin tran t1; update bankAccount set stock = @st where id = @prev; update budgetsCurrencies set amount = @newst where typename = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd2.Parameters.AddWithValue("@prev", this.prebId);
cmd2.Parameters.AddWithValue("@st", prestock - preFee);
cmd2.Parameters.AddWithValue("@id", "stock");
cmd2.Parameters.AddWithValue("@newst", stock + feeNumericUpDown.Value);
cmd2.ExecuteNonQuery();
}
else if (this.precashtype == "غیرنقدی" && cashRadioButton.Checked)
{
cmd2 = new SqlCommand("BEGIN TRY begin tran t1; update budgetsCurrencies set amount = @st where typename = @prev; update bankAccount set stock = @st where id = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd2.Parameters.AddWithValue("@prev", "stock");
cmd2.Parameters.AddWithValue("@st", prestock - preFee);
cmd2.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd2.Parameters.AddWithValue("@newst", stock + feeNumericUpDown.Value);
cmd2.ExecuteNonQuery();
}
else
{
cmd2 = new SqlCommand("update budgetsCurrencies set amount = @amount where typename = @typ;", con);
cmd2.Parameters.AddWithValue("@typ", "stock");
cmd2.Parameters.AddWithValue("@amount", stock - (preFee - feeNumericUpDown.Value));
cmd2.ExecuteNonQuery();
}
}
FMessegeBox.FarsiMessegeBox.Show("دریافت کمک با موفقیت ویرایش شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
con.Close();
this.Close();
}
private void setButton_Click(object sender, EventArgs e)
{
var newform = new editSendingLetterForm2(ExtensionFunction.PersianToEnglish(idTextbox.Text));
newform.ShowDialog(this);
}
private void bankAccountNameComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
bankAccountNumberTextBox.Text = ExtensionFunction.PersianToEnglish(li[bankAccountNameComboBox.SelectedIndex].Key);
}
private void addButton_Click(object sender, EventArgs e)
{
if (srcBankAccountNameComboBox.Enabled && srcBankAccountNameComboBox.SelectedIndex == -1)
{
FMessegeBox.FarsiMessegeBox.Show("حساب مبدا انتخاب نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (dstBankAccountNameComboBox.Enabled && dstBankAccountNameComboBox.SelectedIndex == -1)
{
FMessegeBox.FarsiMessegeBox.Show("حساب مقصد انتخاب نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (srcBankAccountNameComboBox.Enabled && dstBankAccountNameComboBox.Enabled && srcBankAccountNameComboBox.SelectedIndex == dstBankAccountNameComboBox.SelectedIndex)
{
FMessegeBox.FarsiMessegeBox.Show("حساب مبدا و مقصد نمیتواند یکسان باشد!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (String.IsNullOrWhiteSpace(transporterNameTextBox.Text))
{
transporterNameTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("نام انتقالدهنده وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (!transporterNameTextBox.Text.All(c => char.IsWhiteSpace(c) || char.IsLetter(c)))
{
transporterNameTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("نام انتقالدهنده باید فقط شامل حروف و فاصله باشد!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (docLabel.BackColor == Color.Red)
{
FMessegeBox.FarsiMessegeBox.Show("فایل رسید انتخاب نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (String.IsNullOrWhiteSpace(explainTextBox.Text))
{
explainTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("توضیحات وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
SqlConnection con = new SqlConnection(this.connection);
con.Open();
SqlCommand cmdgetstock = new SqlCommand("select stock from bankAccount where id = @id;", con);
decimal srcstock = 0;
cmdgetstock.Parameters.AddWithValue("@id", li[srcBankAccountNameComboBox.SelectedIndex].Key);
using (SqlDataReader reader = cmdgetstock.ExecuteReader())
{
if (reader.Read())
{
srcstock = reader.GetDecimal(0);
}
}
decimal dststock = 0;
SqlCommand cmdget = new SqlCommand("select stock from bankAccount where id = @id", con);
cmdget.Parameters.AddWithValue("@id", li[dstBankAccountNameComboBox.SelectedIndex].Key);
using (SqlDataReader reader = cmdget.ExecuteReader())
{
if (reader.Read())
{
dststock = reader.GetDecimal(0);
}
}
if (preFee + preTax < (feeNumericUpDown.Value + taxNumericUpDown.Value) && srcstock < (feeNumericUpDown.Value + taxNumericUpDown.Value) - (preFee + preTax))
{
FMessegeBox.FarsiMessegeBox.Show(String.Format("موجودی حساب مبدا {0} ریال و ما به تفاوت {0} ریال است و موجودی کافی نیست!", srcstock, (feeNumericUpDown.Value + taxNumericUpDown.Value) - (preFee + preTax)), "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
else if (preFee + preTax > (feeNumericUpDown.Value + taxNumericUpDown.Value) && dststock < (preFee + preTax) - (feeNumericUpDown.Value + taxNumericUpDown.Value))
{
FMessegeBox.FarsiMessegeBox.Show(String.Format("موجودی حساب مقصد {0} ریال و ما به تفاوت {0} ریال است و موجودی کافی نیست!", srcstock, (feeNumericUpDown.Value + taxNumericUpDown.Value) - (preFee + preTax)), "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
DialogResult res = FMessegeBox.FarsiMessegeBox.Show("آیا نسبت به ویرایش انتقال اطمینان دارید؟", "پرسش", FMessegeBox.FMessegeBoxButtons.YesNo, FMessegeBox.FMessegeBoxIcons.Question, FMessegeBox.FMessegeBoxDefaultButton.button1);
if (res != DialogResult.Yes)
{
return;
}
if (docLabel.BackColor == Color.YellowGreen)
{
string fileName = System.IO.Path.GetFileName(doc);
string targetPath = this.moneyTransferPath + "\\" + this.id + "\\";
System.IO.Directory.Delete(targetPath, true);
System.IO.Directory.CreateDirectory(targetPath);
string destFile = System.IO.Path.Combine(targetPath, fileName);
System.IO.File.Copy(doc, destFile, false);
SqlCommand cmdupdatefile = new SqlCommand("BEGIN TRY begin tran t1; delete from doc where id = @id; insert into doc(id, docname, docpath, subdate, doctype) Values(@id, @dname, @dpath, @sdate, @dtype); commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmdupdatefile.Parameters.AddWithValue("@id", this.id);
cmdupdatefile.Parameters.AddWithValue("@dname", fileName);
cmdupdatefile.Parameters.AddWithValue("@dpath", destFile);
cmdupdatefile.Parameters.AddWithValue("@sdate", DateTime.Now.Date);
cmdupdatefile.Parameters.AddWithValue("@dtype", "moneyTransfer");
cmdupdatefile.ExecuteNonQuery();
}
if (srcBankAccountNameComboBox.Text != "حساب حذف شده" && srcBankAccountNameComboBox.Text != "حساب حذف شده" && (preFee + preTax != (feeNumericUpDown.Value + taxNumericUpDown.Value)))
{
SqlCommand cmdupdate = new SqlCommand("BEGIN TRY begin tran t1; update bankAccount set stock = @srcst where id = @srcid; update bankAccount set stock = @dstst where id = @dstid; update moneyTransfer set fee = @fee, tax = @tax, transporterName = @tname, subdate = @sdate, transferdate = @tdate, description = @des where id = @id; insert into moneyTransferHistory (id, srcid, dstid, fee, tax, transporterName, subdate, transferdate, enactmentId, description) Values (@id, @srcid, @dstid, @fee, @tax, @tname, @sdate, @tdate, @eId, @des); commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmdupdate.Parameters.AddWithValue("@srcst", srcstock - ((feeNumericUpDown.Value + taxNumericUpDown.Value) - (preFee + preTax)));
cmdupdate.Parameters.AddWithValue("@dstst", dststock - ((preFee + preTax) - (feeNumericUpDown.Value + taxNumericUpDown.Value)));
cmdupdate.Parameters.AddWithValue("@srcid", li[srcBankAccountNameComboBox.SelectedIndex].Key);
cmdupdate.Parameters.AddWithValue("@dstid", li[dstBankAccountNameComboBox.SelectedIndex].Key);
cmdupdate.Parameters.AddWithValue("@sdate", DateTime.Now.Date);
cmdupdate.Parameters.AddWithValue("@fee", feeNumericUpDown.Value);
cmdupdate.Parameters.AddWithValue("@tax", taxNumericUpDown.Value);
cmdupdate.Parameters.AddWithValue("@tname", transporterNameTextBox.Text);
cmdupdate.Parameters.AddWithValue("@id", this.id);
cmdupdate.Parameters.AddWithValue("@tdate", transferDateTimePickerX.SelectedDateInDateTime.Date);
cmdupdate.Parameters.AddWithValue("@des", explainTextBox.Text);
cmdupdate.Parameters.AddWithValue("@eId", ExtensionFunction.PersianToEnglish(enactmentTextbox.Text));
cmdupdate.ExecuteNonQuery();
}
else
{
SqlCommand cmdupdate = new SqlCommand("BEGIN TRY begin tran t1; update moneyTransfer set transporterName = @tname, subdate = @sdate, transferdate = @tdate, description = @des where id = @id; insert into moneyTransferHistory (id, srcid, dstid, fee, tax, transporterName, subdate, transferdate, enactmentId, description) Values (@id, @srcid, @dstid, @fee, @tax, @tname, @sdate, @tdate, @eId, @des); commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmdupdate.Parameters.AddWithValue("@srcid", li[srcBankAccountNameComboBox.SelectedIndex].Key);
cmdupdate.Parameters.AddWithValue("@dstid", li[dstBankAccountNameComboBox.SelectedIndex].Key);
cmdupdate.Parameters.AddWithValue("@id", this.id);
cmdupdate.Parameters.AddWithValue("@fee", feeNumericUpDown.Value);
cmdupdate.Parameters.AddWithValue("@tax", taxNumericUpDown.Value);
cmdupdate.Parameters.AddWithValue("@tname", transporterNameTextBox.Text);
cmdupdate.Parameters.AddWithValue("@sdate", DateTime.Now.Date);
cmdupdate.Parameters.AddWithValue("@tdate", transferDateTimePickerX.SelectedDateInDateTime.Date);
cmdupdate.Parameters.AddWithValue("@des", explainTextBox.Text);
cmdupdate.Parameters.AddWithValue("@eId", ExtensionFunction.PersianToEnglish(enactmentTextbox.Text));
cmdupdate.ExecuteNonQuery();
}
con.Close();
FMessegeBox.FarsiMessegeBox.Show("انتقال با موفقیت ویرایش شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
this.Close();
}
private void setButton_Click(object sender, EventArgs e)
{
if (this.Text == "تایید کمک متفرقه فردی")
{
SqlConnection con = new SqlConnection(this.connection);
con.Open();
decimal budget = 0, consume = 0, stock = 0, familyBudget = 0;
SqlCommand cmdget = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
SqlCommand cmdget2 = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
SqlCommand cmdget3 = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
cmdget.Parameters.AddWithValue("@id", "othersBudget");
cmdget2.Parameters.AddWithValue("@id", "othersConsume");
cmdget3.Parameters.AddWithValue("@id", "stock");
using (SqlDataReader reader = cmdget.ExecuteReader())
{
if (reader.Read())
{
budget = reader.GetDecimal(0);
}
}
using (SqlDataReader reader = cmdget2.ExecuteReader())
{
if (reader.Read())
{
consume = reader.GetDecimal(0);
}
}
using (SqlDataReader reader = cmdget3.ExecuteReader())
{
if (reader.Read())
{
stock = reader.GetDecimal(0);
}
}
if (feeNumericUpDown.Value > this.fee && consume + feeNumericUpDown.Value - this.fee > budget)
{
FMessegeBox.FarsiMessegeBox.Show("این درخواست خارج از محدوده بودجه تعریف شده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
else if (feeNumericUpDown.Value > this.fee && feeNumericUpDown.Value - this.fee > stock)
{
FMessegeBox.FarsiMessegeBox.Show("موجودی کافی نیست!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
else
{
DialogResult dr = FMessegeBox.FarsiMessegeBox.Show("با تایید کمک، ویرایش اعمال پیش از تایید غیر ممکن خواهد شد. آیا نسبت به تایید اطمینان دارید؟", "هشدار!", FMessegeBox.FMessegeBoxButtons.YesNo, FMessegeBox.FMessegeBoxIcons.Question, FMessegeBox.FMessegeBoxDefaultButton.button1);
if (dr != DialogResult.Yes)
{
return;
}
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; update OtherHelpsIndiv Set confirmdescription = @des, confirmdate = @cdate, status = @stat, fee = @fee, fenactmentId = @feId where id = @id; update budgetsCurrencies Set amount = @amount2 where typename = @tname2; update budgetsCurrencies Set amount = @amount3 where typename = @tname3; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@des", "(توضیحات تایید: " + explainTextBox2.Text + ")");
cmd.Parameters.AddWithValue("@fee", feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@feId", ExtensionFunction.PersianToEnglish(enactmentTextbox.Text));
cmd.Parameters.AddWithValue("@cdate", DateTime.Now.Date);
cmd.Parameters.AddWithValue("@stat", "نهایی");
cmd.Parameters.AddWithValue("@amount2", consume + feeNumericUpDown.Value - this.fee);
cmd.Parameters.AddWithValue("@tname2", "othersConsume");
cmd.Parameters.AddWithValue("@amount3", stock - feeNumericUpDown.Value + this.fee);
cmd.Parameters.AddWithValue("@tname3", "stock");
cmd.ExecuteNonQuery();
con.Close();
FMessegeBox.FarsiMessegeBox.Show("کمک با موفقیت تایید و نهایی شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
this.Close();
}
}
else
{
SqlConnection con = new SqlConnection(this.connection);
con.Open();
decimal budget = 0, consume = 0, stock = 0, familyBudget = 0;
SqlCommand cmdget = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
SqlCommand cmdget2 = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
SqlCommand cmdget3 = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
cmdget.Parameters.AddWithValue("@id", "othersBudget");
cmdget2.Parameters.AddWithValue("@id", "othersConsume");
cmdget3.Parameters.AddWithValue("@id", "stock");
using (SqlDataReader reader = cmdget.ExecuteReader())
{
if (reader.Read())
{
budget = reader.GetDecimal(0);
}
}
using (SqlDataReader reader = cmdget2.ExecuteReader())
{
if (reader.Read())
{
consume = reader.GetDecimal(0);
}
}
using (SqlDataReader reader = cmdget3.ExecuteReader())
{
if (reader.Read())
{
stock = reader.GetDecimal(0);
}
}
if (feeNumericUpDown.Value > this.fee && consume + feeNumericUpDown.Value - this.fee > budget)
{
FMessegeBox.FarsiMessegeBox.Show("این درخواست خارج از محدوده بودجه تعریف شده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
else if (feeNumericUpDown.Value > this.fee && feeNumericUpDown.Value - this.fee > stock)
{
FMessegeBox.FarsiMessegeBox.Show("موجودی کافی نیست!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
else
{
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; update OtherHelpsIndiv Set confirmdescription = @des, fee = @fee, fenactmentId = @feId where id = @id; update budgetsCurrencies Set amount = @amount2 where typename = @tname2; update budgetsCurrencies Set amount = @amount3 where typename = @tname3; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@des", this.explain + "(توضیحات ویرایش تایید: " + explainTextBox2.Text + ")");
cmd.Parameters.AddWithValue("@fee", feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@feId", ExtensionFunction.PersianToEnglish(enactmentTextbox.Text));
cmd.Parameters.AddWithValue("@amount2", consume + feeNumericUpDown.Value - this.fee);
cmd.Parameters.AddWithValue("@tname2", "othersConsume");
cmd.Parameters.AddWithValue("@amount3", stock - feeNumericUpDown.Value + this.fee);
cmd.Parameters.AddWithValue("@tname3", "stock");
cmd.ExecuteNonQuery();
con.Close();
FMessegeBox.FarsiMessegeBox.Show("ویرایش تایید کمک با موفقیت انجام شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
this.Close();
}
}
}
private void addButton_Click(object sender, EventArgs e)
{
if (typeComboBox.Text.Length == 0)
{
FMessegeBox.FarsiMessegeBox.Show("نوع کمک انتخاب نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (String.IsNullOrWhiteSpace(buyerNameTextBox.Text))
{
buyerNameTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("نام خریدار وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (docLabel.BackColor == Color.Red)
{
FMessegeBox.FarsiMessegeBox.Show("فایل رسید انتخاب نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (String.IsNullOrWhiteSpace(explainTextBox.Text))
{
explainTextBox.BackColor = Color.Tomato;
FMessegeBox.FarsiMessegeBox.Show("ذکر توضیحات الزامی است. توضیحی وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
if (bankAccountNameComboBox.SelectedIndex == -1)
{
FMessegeBox.FarsiMessegeBox.Show("حساب مورد نظر انتخاب نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
SqlConnection con = new SqlConnection(this.connection);
con.Open();
decimal budget = 0, consume = 0, stock = 0, amount = 0;
if (typeComboBox.Text == "اداری فرهنگی")
{
SqlCommand cmdgetst = new SqlCommand("select stock from bankAccount where id = @id;", con);
SqlCommand cmdget = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
SqlCommand cmdget2 = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
cmdget.Parameters.AddWithValue("@id", "cultureBudget");
cmdget2.Parameters.AddWithValue("@id", "cultureConsume");
cmdgetst.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
using (SqlDataReader reader = cmdget.ExecuteReader())
{
if (reader.Read())
{
budget = reader.GetDecimal(0);
}
}
using (SqlDataReader reader = cmdget2.ExecuteReader())
{
if (reader.Read())
{
consume = reader.GetDecimal(0);
}
}
using (SqlDataReader reader = cmdgetst.ExecuteReader())
{
if (reader.Read())
{
stock = reader.GetDecimal(0);
}
}
if (consume + feeNumericUpDown.Value > budget)
{
FMessegeBox.FarsiMessegeBox.Show("این درخواست خارج از محدوده بودجه تعریف شده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
}
if (stock < feeNumericUpDown.Value)
{
FMessegeBox.FarsiMessegeBox.Show("موجودی حساب کافی نیست!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
DialogResult res = FMessegeBox.FarsiMessegeBox.Show("آیا نسبت به ثبت خرید این کمک اطمینان دارید؟", "پرسش", FMessegeBox.FMessegeBoxButtons.YesNo, FMessegeBox.FMessegeBoxIcons.Question, FMessegeBox.FMessegeBoxDefaultButton.button1);
if (res != DialogResult.Yes)
{
return;
}
string d = DateTime.Now.Date.ToPersian(); d = "Buy" + d.Substring(0, 4) + d.Substring(5, 2) + d.Substring(8, 2);
SqlCommand cmdgetid = new SqlCommand("select id from recHelps where id like '" + d + "%';", con);
int index = 1, mx = 1;
using (SqlDataReader reader = cmdgetid.ExecuteReader())
{
while (reader.Read())
{
string s = String.Format("{0}", reader["id"]);
if (s == "")
{
index = 1;
}
else
{
index = Convert.ToInt32(s.Substring(11)) + 1;
}
mx = Math.Max(mx, index);
}
}
d = d + mx.ToString();
string fileName = System.IO.Path.GetFileName(doc);
string targetPath = this.buyHelpPath + "\\" + d + "\\";
System.IO.Directory.CreateDirectory(targetPath);
string destFile = System.IO.Path.Combine(targetPath, fileName);
System.IO.File.Copy(doc, destFile, false);
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; insert into buyHelps(id, type, fee, packet, buydate, subdate, buyerName, bankAccountId, bankAccountName, description) Values(@id, @typ, @fee, @pack, @bdate, @sdate, @buName, @bId, @bName, @des); insert into buyHelpsHistory (id, type, fee, packet, buydate, subdate, buyerName, bankAccountId, bankAccountName, description) Values(@id, @typ, @fee, @pack, @bdate, @sdate, @buName, @bId, @bName, @des); insert into doc(id, docname, docpath, subdate, doctype) Values(@id, @dname, @dpath, @sdate, @dtype); update budgetsCurrencies set amount = @amount where typename = @dtyp; update bankAccount set stock = @newst where id = @bId; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id", d);
cmd.Parameters.AddWithValue("@typ", typeComboBox.Text);
cmd.Parameters.AddWithValue("@fee", feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@pack", packetNumericUpDown.Value);
cmd.Parameters.AddWithValue("@bdate", buyDateTimePickerX.SelectedDateInDateTime.Date);
cmd.Parameters.AddWithValue("@sdate", DateTime.Now.Date);
cmd.Parameters.AddWithValue("@buName", buyerNameTextBox.Text);
cmd.Parameters.AddWithValue("@bId", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd.Parameters.AddWithValue("@bName", bankAccountNameComboBox.Text);
cmd.Parameters.AddWithValue("@newst", stock - feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@des", explainTextBox.Text);
cmd.Parameters.AddWithValue("@dname", fileName);
cmd.Parameters.AddWithValue("@dpath", destFile);
cmd.Parameters.AddWithValue("@dtype", "buyHelp");
cmd.Parameters.AddWithValue("@dtyp", "cultureConsume");
cmd.Parameters.AddWithValue("@amount", consume + feeNumericUpDown.Value);
cmd.ExecuteNonQuery();
}
else
{
SqlCommand cmdgetst = new SqlCommand("select stock from bankAccount where id = @id;", con);
cmdgetst.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
using (SqlDataReader reader = cmdgetst.ExecuteReader())
{
if (reader.Read())
{
stock = reader.GetDecimal(0);
}
}
if (stock < feeNumericUpDown.Value)
{
FMessegeBox.FarsiMessegeBox.Show("موجودی حساب کافی نیست!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
DialogResult res = FMessegeBox.FarsiMessegeBox.Show("آیا نسبت به ثبت خرید این کمک اطمینان دارید؟", "پرسش", FMessegeBox.FMessegeBoxButtons.YesNo, FMessegeBox.FMessegeBoxIcons.Question, FMessegeBox.FMessegeBoxDefaultButton.button1);
if (res != DialogResult.Yes)
{
return;
}
string d = DateTime.Now.Date.ToPersian(); d = "Buy" + d.Substring(0, 4) + d.Substring(5, 2) + d.Substring(8, 2);
SqlCommand cmdgetid = new SqlCommand("select id from recHelps where id like '" + d + "%';", con);
int index = 1, mx = 1;
using (SqlDataReader reader = cmdgetid.ExecuteReader())
{
while (reader.Read())
{
string s = String.Format("{0}", reader["id"]);
if (s == "")
{
index = 1;
}
else
{
index = Convert.ToInt32(s.Substring(11)) + 1;
}
mx = Math.Max(mx, index);
}
}
d = d + mx.ToString();
SqlCommand cmdget = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
switch (typeComboBox.Text)
{
case "گوشت":
cmdget.Parameters.AddWithValue("@id", "meat");
break;
case "خواربار":
cmdget.Parameters.AddWithValue("@id", "grocery");
break;
case "مرغ":
cmdget.Parameters.AddWithValue("@id", "chicken");
break;
case "متفرقه":
cmdget.Parameters.AddWithValue("@id", "stock");
break;
}
using (SqlDataReader reader = cmdget.ExecuteReader())
{
if (reader.Read())
{
amount = reader.GetDecimal(0);
}
}
string fileName = System.IO.Path.GetFileName(doc);
string targetPath = this.buyHelpPath + "\\" + d + "\\";
System.IO.Directory.CreateDirectory(targetPath);
string destFile = System.IO.Path.Combine(targetPath, fileName);
System.IO.File.Copy(doc, destFile, false);
SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; insert into buyHelps(id, type, fee, packet, buydate, subdate, buyerName, bankAccountId, bankAccountName, description) Values(@id, @typ, @fee, @pack, @bdate, @sdate, @buName, @bId, @bName, @des); insert into buyHelpsHistory (id, type, fee, packet, buydate, subdate, buyerName, bankAccountId, bankAccountName, description) Values(@id, @typ, @fee, @pack, @bdate, @sdate, @buName, @bId, @bName, @des); insert into doc(id, docname, docpath, subdate, doctype) Values(@id, @dname, @dpath, @sdate, @dtype); update budgetsCurrencies set amount = @amount where typename = @dtyp; update bankAccount set stock = @newst where id = @bId; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@id", d);
cmd.Parameters.AddWithValue("@typ", typeComboBox.Text);
cmd.Parameters.AddWithValue("@fee", feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@pack", packetNumericUpDown.Value);
cmd.Parameters.AddWithValue("@bdate", buyDateTimePickerX.SelectedDateInDateTime.Date);
cmd.Parameters.AddWithValue("@sdate", DateTime.Now.Date);
cmd.Parameters.AddWithValue("@buName", buyerNameTextBox.Text);
cmd.Parameters.AddWithValue("@bId", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
cmd.Parameters.AddWithValue("@bName", bankAccountNameComboBox.Text);
cmd.Parameters.AddWithValue("@newst", stock - feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@des", explainTextBox.Text);
cmd.Parameters.AddWithValue("@dname", fileName);
cmd.Parameters.AddWithValue("@dpath", destFile);
cmd.Parameters.AddWithValue("@dtype", "buyHelp");
if (typeComboBox.Text == "گوشت")
{
cmd.Parameters.AddWithValue("@dtyp", "meat");
cmd.Parameters.AddWithValue("@amount", amount + feeNumericUpDown.Value);
}
else if (typeComboBox.Text == "مرغ")
{
cmd.Parameters.AddWithValue("@dtyp", "chicken");
cmd.Parameters.AddWithValue("@amount", amount + feeNumericUpDown.Value);
}
else if (typeComboBox.Text == "خواربار")
{
cmd.Parameters.AddWithValue("@dtyp", "grocery");
cmd.Parameters.AddWithValue("@amount", amount + feeNumericUpDown.Value);
}
else if (typeComboBox.Text == "متفرقه")
{
cmd.Parameters.AddWithValue("@dtyp", "stock");
cmd.Parameters.AddWithValue("@amount", amount + feeNumericUpDown.Value);
}
cmd.ExecuteNonQuery();
}
FMessegeBox.FarsiMessegeBox.Show("خرید کمک با موفقیت ثبت شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
con.Close();
this.Close();
}
private void chooseButton_Click(object sender, EventArgs e)
{
var newform = new observeBudgetsetsForm2(ExtensionFunction.PersianToEnglish(membersView.Rows[membersView.SelectedCells[0].RowIndex].Cells[membersView.SelectedCells[0].ColumnIndex].Value.ToString()));
newform.ShowDialog(this);
}
private void setButton_Click(object sender, EventArgs e)
{
var newform = new reportHelpsForm(this.typ, ExtensionFunction.PersianToEnglish(idTextbox.Text));
newform.ShowDialog(this);
}
private void setButton_Click(object sender, EventArgs e)
{
if (rad)
{
this.Close();
}
else
{
SqlConnection con = new SqlConnection(this.connection);
con.Open();
if (this.Text == "بررسی درخواست کمک ازدواج")
{
decimal budget = 0, consume = 0, stock = 0;
SqlCommand cmdget = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
SqlCommand cmdget2 = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
SqlCommand cmdget3 = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
cmdget.Parameters.AddWithValue("@id", "marryBudget");
cmdget2.Parameters.AddWithValue("@id", "marryConsume");
cmdget3.Parameters.AddWithValue("@id", "marry");
using (SqlDataReader reader = cmdget.ExecuteReader())
{
if (reader.Read())
{
budget = reader.GetDecimal(0);
}
}
using (SqlDataReader reader = cmdget2.ExecuteReader())
{
if (reader.Read())
{
consume = reader.GetDecimal(0);
}
}
using (SqlDataReader reader = cmdget3.ExecuteReader())
{
if (reader.Read())
{
stock = reader.GetDecimal(0);
}
}
if (consume + feeNumericUpDown.Value > budget)
{
FMessegeBox.FarsiMessegeBox.Show("این درخواست خارج از محدوده بودجه تعریف شده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
}
else if (typeComboBox.Text == "غیرنقدی" && feeNumericUpDown.Value > stock)
{
FMessegeBox.FarsiMessegeBox.Show("موجودی کافی نیست!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
}
else
{
string d = DateTime.Now.Date.ToPersian(); d = "M" + d.Substring(0, 4) + d.Substring(5, 2) + d.Substring(8, 2);
SqlCommand cmdgetid = new SqlCommand("select id from MarryHelps where id like '" + d + "%';", con);
int index = 1;
using (SqlDataReader reader = cmdgetid.ExecuteReader())
{
if (reader.Read())
{
string s = String.Format("{0}", reader["id"]);
if (s == "")
{
index = 1;
}
else
{
index = Convert.ToInt32(s.Substring(9)) + 1;
}
}
}
d = d + index.ToString();
this.id = d;
System.IO.Directory.CreateDirectory(this.helpPath + "\\" + this.id);
System.IO.Directory.CreateDirectory(this.helpPath + "\\" + this.id + "\\receipt");
SqlCommand cmd;
if (typeComboBox.Text == "غیرنقدی")
{
cmd = new SqlCommand("BEGIN TRY begin tran t1; insert into MarryHelps (id, type, reqId, subdate, description, enactmentId, status, fee) Values (@id, @typ, @rId, @sdate, @des, @eId, @stat, @fee); update MarryHelpReq Set status = @rstat, enactmentId = @eId where id = @rId; update budgetsCurrencies Set amount = @amount2 where typename = @tname2; update budgetsCurrencies Set amount = @amount3 where typename = @tname3; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@amount3", stock - feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@tname3", "marry");
}
else
{
cmd = new SqlCommand("BEGIN TRY begin tran t1; insert into MarryHelps (id, type, reqId, subdate, description, enactmentId, status, fee) Values (@id, @typ, @rId, @sdate, @des, @eId, @stat, @fee); update MarryHelpReq Set status = @rstat, enactmentId = @eId where id = @rId; update budgetsCurrencies Set amount = @amount2 where typename = @tname2; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
}
cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@typ", typeComboBox.Text);
cmd.Parameters.AddWithValue("@rId", this.rId);
cmd.Parameters.AddWithValue("@sdate", DateTime.Now.Date);
cmd.Parameters.AddWithValue("@des", "(توضیحات کمک: " + explainTextBox2.Text + ")");
cmd.Parameters.AddWithValue("@eId", ExtensionFunction.PersianToEnglish(enactmentTextbox.Text));
if (typeComboBox.Text == "غیرنقدی خیریه دیگر")
{
cmd.Parameters.AddWithValue("@stat", "ارسال معرفینامه");
System.IO.Directory.CreateDirectory(this.helpPath + "\\" + this.id + "\\intro");
System.IO.Directory.CreateDirectory(this.helpPath + "\\" + this.id + "\\assignment");
}
else
{
cmd.Parameters.AddWithValue("@stat", "ارائه");
}
cmd.Parameters.AddWithValue("@fee", feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@rstat", "تایید");
cmd.Parameters.AddWithValue("@amount2", consume + feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@tname2", "marryConsume");
cmd.ExecuteNonQuery();
FMessegeBox.FarsiMessegeBox.Show("کمک با موفقیت ثبت شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
con.Close();
this.Close();
}
}
else
{
decimal budget = 0, consume = 0, stock = 0;
SqlCommand cmdget = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
SqlCommand cmdget2 = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
SqlCommand cmdget3 = new SqlCommand("select amount from budgetsCurrencies where typename = @id", con);
cmdget.Parameters.AddWithValue("@id", "marryBudget");
cmdget2.Parameters.AddWithValue("@id", "marryConsume");
cmdget3.Parameters.AddWithValue("@id", "marry");
using (SqlDataReader reader = cmdget.ExecuteReader())
{
if (reader.Read())
{
budget = reader.GetDecimal(0);
}
}
using (SqlDataReader reader = cmdget2.ExecuteReader())
{
if (reader.Read())
{
consume = reader.GetDecimal(0);
}
}
using (SqlDataReader reader = cmdget3.ExecuteReader())
{
if (reader.Read())
{
stock = reader.GetDecimal(0);
}
}
if (feeNumericUpDown.Value > this.fee && consume + feeNumericUpDown.Value - this.fee > budget)
{
FMessegeBox.FarsiMessegeBox.Show("این درخواست خارج از محدوده بودجه تعریف شده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
else if (typeComboBox.Text == "غیرنقدی" && feeNumericUpDown.Value > this.fee && feeNumericUpDown.Value - this.fee > stock)
{
FMessegeBox.FarsiMessegeBox.Show("موجودی کافی نیست!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
return;
}
else
{
SqlCommand cmd;
if (typeComboBox.Text == "غیرنقدی")
{
cmd = new SqlCommand("BEGIN TRY begin tran t1; update MarryHelps Set description = @des, fee = @fee, enactmentId = @eId where id = @id; update MarryHelpReq Set enactmentId = @eId where id = @rId; update budgetsCurrencies Set amount = @amount2 where typename = @tname2; update budgetsCurrencies Set amount = @amount3 where typename = @tname3; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
cmd.Parameters.AddWithValue("@amount3", stock - feeNumericUpDown.Value + this.fee);
cmd.Parameters.AddWithValue("@tname3", "marry");
}
else
{
cmd = new SqlCommand("BEGIN TRY begin tran t1; update MarryHelps Set description = @des, fee = @fee, enactmentId = @eId where id = @id; update MarryHelpReq Set enactmentId = @eId where id = @rId; update budgetsCurrencies Set amount = @amount2 where typename = @tname2; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
}
cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@rId", this.rId);
cmd.Parameters.AddWithValue("@des", this.explain + " " + "(توضیحات ویرایش کمک: " + explainTextBox2.Text + ")");
cmd.Parameters.AddWithValue("@eId", ExtensionFunction.PersianToEnglish(enactmentTextbox.Text));
cmd.Parameters.AddWithValue("@fee", feeNumericUpDown.Value);
cmd.Parameters.AddWithValue("@amount2", consume + feeNumericUpDown.Value - this.fee);
cmd.Parameters.AddWithValue("@tname2", "marryConsume");
cmd.ExecuteNonQuery();
FMessegeBox.FarsiMessegeBox.Show("کمک با موفقیت ویرایش شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
con.Close();
this.Close();
}
}
}
}
private void setButton_Click(object sender, EventArgs e)
{
var newform = new bankAccountTransferEditForm2(ExtensionFunction.PersianToEnglish(idTextbox.Text));
newform.ShowDialog(this);
}