private void setMarriageButton_Click(object sender, EventArgs e) { int res; if (int.TryParse(idTextbox.Text, out res) && !idTextbox.Text.Any(char.IsWhiteSpace)) { SqlConnection con = new SqlConnection(this.connection); con.Open(); SqlCommand cmdcheck = new SqlCommand("select count(*) as sup from member where id = @sup and sex = N'زن'", con); cmdcheck.Parameters.AddWithValue("@sup", idTextbox.Text); int sup = 0; using (SqlDataReader reader = cmdcheck.ExecuteReader()) { if (reader.Read()) { sup = int.Parse(String.Format("{0}", reader["sup"])); } } if (sup == 0) { MessageBox.Show("شماره ملی عضو خانم در لیست موجود نیست!", "هشدار!", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); } else { SqlCommand cmdchecksup = new SqlCommand("select count(*) as sup from member where supporter_id = @sup and id != @sup", con); cmdcheck.Parameters.AddWithValue("@sup", idTextbox.Text); int su = 0; using (SqlDataReader reader = cmdchecksup.ExecuteReader()) { if (reader.Read()) { su = int.Parse(String.Format("{0}", reader["sup"])); } } if (su != 0) { var newform = new changeSupporterForm(this.Text, idTextbox.Text); newform.ShowDialog(this); } su = 0; using (SqlDataReader reader = cmdchecksup.ExecuteReader()) { if (reader.Read()) { su = int.Parse(String.Format("{0}", reader["sup"])); } } if (sup != 0) { MessageBox.Show("این عضو سرپرست خانوار است و ابتدا باید وضعیت سرپرستی آنها را مشخص کنید!", "اخطار!", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); con.Close(); } else { SqlCommand cmdget = new SqlCommand("select name, family, fatherName, id, supporter_id, sex, job, house, birthdate, folderdate, checkdate, health, lifehood, marriage, orphan, student, homephone, cellphone, address, explain, rate, folder_id from member where id = @tmp", con); cmdget.Parameters.AddWithValue("@tmp", idTextbox.Text); SqlCommand cmd = new SqlCommand("begin tran t1; insert into abandoned(name, family, fatherName, id, supporter_id, sex, job, house, birthdate, folderdate, checkdate, health, lifehood, marriage, orphan, student, homephone, cellphone, address, explain, folder_id, abandoneddate)" + " Values(@name, @family, @fatherName, @id, @supporter_id, @sex, @job, @house, @birthdate, @folderdate, @checkdate, @health, @lifehood, @marriage, @orphan, @student, @homephone, @cellphone, @address, @explain, @folder_id, @abandoneddate); " + "insert into married (id, marrieddate, description, setupdate, folder_id) Values(@id, @marrieddate, @description, @abandoneddate, @folder_id); " + "delete from member where id = @id; commit tran t1;", con); using (SqlDataReader reader = cmdget.ExecuteReader()) { if (reader.Read()) { cmd.Parameters.AddWithValue("@name", String.Format("{0}", reader["name"])); cmd.Parameters.AddWithValue("@family", String.Format("{0}", reader["family"])); cmd.Parameters.AddWithValue("@fatherName", String.Format("{0}", reader["fatherName"])); cmd.Parameters.AddWithValue("@id", String.Format("{0}", reader["id"])); cmd.Parameters.AddWithValue("@supporter_id", String.Format("{0}", reader["supporter_id"])); cmd.Parameters.AddWithValue("@sex", String.Format("{0}", reader["sex"])); cmd.Parameters.AddWithValue("@job", String.Format("{0}", reader["job"])); cmd.Parameters.AddWithValue("@house", String.Format("{0}", reader["house"])); cmd.Parameters.AddWithValue("@health", String.Format("{0}", reader["health"])); cmd.Parameters.AddWithValue("@lifehood", String.Format("{0}", reader["lifehood"])); cmd.Parameters.AddWithValue("@marriage", "متأهل"); cmd.Parameters.AddWithValue("@homephone", String.Format("{0}", reader["homephone"])); cmd.Parameters.AddWithValue("@cellphone", String.Format("{0}", reader["cellphone"])); cmd.Parameters.AddWithValue("@address", String.Format("{0}", reader["address"])); cmd.Parameters.AddWithValue("@explain", String.Format("{0}", reader["explain"]) + marriedDescriptionTextBox.Text + "(خروج از پوشش به علت ازدواج در تاریخ" + DateTime.Now.Date.ToString().Substring(8, 2) + "/" + DateTime.Now.Date.ToString().Substring(3, 2) + "/" + DateTime.Now.Date.ToString().Substring(0, 2) + ")"); cmd.Parameters.AddWithValue("@folder_id", String.Format("{0}", reader["folder_id"])); cmd.Parameters.AddWithValue("@birthdate", Convert.ToDateTime(String.Format("{0}", reader["birthdate"])).Date); cmd.Parameters.AddWithValue("@folderdate", Convert.ToDateTime(String.Format("{0}", reader["folderdate"])).Date); cmd.Parameters.AddWithValue("@checkdate", Convert.ToDateTime(String.Format("{0}", reader["checkdate"])).Date); cmd.Parameters.AddWithValue("@marrieddate", marriedTimePicker.Value.Date); cmd.Parameters.AddWithValue("@abandoneddate", DateTime.Now.Date); cmd.Parameters.AddWithValue("@description", marriedDescriptionTextBox.Text + "(خروج از پوشش به علت ازدواج در تاریخ" + DateTime.Now.Date.ToString().Substring(8, 2) + "/" + DateTime.Now.Date.ToString().Substring(3, 2) + "/" + DateTime.Now.Date.ToString().Substring(0, 2) + ")"); } } cmd.ExecuteNonQuery(); } MessageBox.Show("ازدواج عضو با موفقیت ثبت شد", "تبریک!", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); con.Close(); setMarriageButton.Enabled = false; idTextbox.Text = ""; marriedDescriptionTextBox.Text = ""; marriedTimePicker.Value = DateTime.Now; } } else { MessageBox.Show("اخطار شماره ملی باید شامل اعداد و بدون هیچ فاضلهای باشد", "اخظار!", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); } }
private void setButton_Click(object sender, EventArgs e) { bool isempty = true; reason = ""; if (this.Text == "حذف پوشش خانوار") { foreach (CheckBox cb in deleteFamilygroupBox.Controls) { if (cb.Checked) { reason += cb.Text + "و "; isempty = false; } } } else { foreach (CheckBox cb in deletePersongroupBox.Controls) { if (cb.Checked) { if (cb.Text == "ازدواج") { reason += cb.Text + " در تاریخ " + marrydateTimePickerX.SelectedDateInDateTime.Date.ToPersian() + " و "; } else { reason += cb.Text + " و "; } isempty = false; } } } if (isempty) { 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; } SqlConnection con1 = new SqlConnection(this.connection); con1.Open(); if (this.Text == "حذف پوشش خانوار") { List <string> li = new List <string>(); string[] arr; SqlCommand cmdchild = new SqlCommand("select id from member where supporter_id = @sup and id != @sup", con1); cmdchild.Parameters.AddWithValue("@sup", this.id); using (SqlDataReader reader = cmdchild.ExecuteReader()) { while (reader.Read()) { li.Add(reader.GetString(0)); } arr = li.ToArray(); } SqlCommand cmdgetc, cmdc; foreach (var i in arr) { cmdgetc = new SqlCommand("select name, family, fatherName, id, supporter_id, sex, job, house, birthdate, folderdate, checkdate, health, otherSup, annual, seyed, car, homephone, cellphone, address, explain, rate, marriage, insurance, orphan, student, folder_id, identifierName, identifierPhone, enactmentId from member where id = @tmp", con1); cmdgetc.Parameters.AddWithValue("@tmp", i); cmdc = new SqlCommand("begin tran t1; insert into abandoned(name, family, fatherName, id, supporter_id, sex, job, house, birthdate, folderdate, checkdate, health, otherSup, annual, seyed, car, marriage, insurance, orphan, student, homephone, cellphone, address, explain, folder_id, identifierName, identifierPhone, abandoneddate, reason, enactmentId)" + " Values(@name, @family, @fatherName, @id, @supporter_id, @sex, @job, @house, @birthdate, @folderdate, @checkdate, @health, @otherSup, @annual, @seyed, @car, @marriage, @ins, @orphan, @student, @homephone, @cellphone, @address, @explain, @folder_id, @iName, @iPhone, @abandoneddate, @reason, @eId); " + "insert into outmember (id, setupdate, description, status, folder_id, familyRegion, financial) Values(@id, @setupdate, @reason, @status, @folder_id, @famReg, @fin);" + "delete from onindependency where id = @id;" + "delete from member where id = @id; update Inmember Set kickdate= @abandoneddate where id = @id and kickdate is Null; commit tran t1;", con1); using (SqlDataReader reader = cmdgetc.ExecuteReader()) { if (reader.Read()) { cmdc.Parameters.AddWithValue("@name", String.Format("{0}", reader["name"])); cmdc.Parameters.AddWithValue("@family", String.Format("{0}", reader["family"])); cmdc.Parameters.AddWithValue("@fatherName", String.Format("{0}", reader["fatherName"])); cmdc.Parameters.AddWithValue("@id", String.Format("{0}", reader["id"])); cmdc.Parameters.AddWithValue("@supporter_id", String.Format("{0}", reader["supporter_id"])); cmdc.Parameters.AddWithValue("@eId", String.Format("{0}", reader["enactmentId"])); cmdc.Parameters.AddWithValue("@sex", String.Format("{0}", reader["sex"])); cmdc.Parameters.AddWithValue("@job", String.Format("{0}", reader["job"])); cmdc.Parameters.AddWithValue("@house", String.Format("{0}", reader["house"])); cmdc.Parameters.AddWithValue("@health", String.Format("{0}", reader["health"])); cmdc.Parameters.AddWithValue("@otherSup", String.Format("{0}", reader["otherSup"])); cmdc.Parameters.AddWithValue("@annual", String.Format("{0}", reader["annual"])); cmdc.Parameters.AddWithValue("@seyed", String.Format("{0}", reader["seyed"])); cmdc.Parameters.AddWithValue("@car", String.Format("{0}", reader["car"])); cmdc.Parameters.AddWithValue("@marriage", String.Format("{0}", reader["marriage"])); cmdc.Parameters.AddWithValue("@ins", String.Format("{0}", reader["insurance"])); cmdc.Parameters.AddWithValue("@orphan", String.Format("{0}", reader["orphan"])); cmdc.Parameters.AddWithValue("@student", String.Format("{0}", reader["student"])); cmdc.Parameters.AddWithValue("@homephone", String.Format("{0}", reader["homephone"])); cmdc.Parameters.AddWithValue("@cellphone", String.Format("{0}", reader["cellphone"])); cmdc.Parameters.AddWithValue("@address", String.Format("{0}", reader["address"])); cmdc.Parameters.AddWithValue("@explain", String.Format("{0}", reader["explain"]) + DescriptionTextBox.Text + "(خروج از پوشش خانواری به علت " + reason + "در تاریخ " + DateTime.Now.Date.ToPersian() + ")"); cmdc.Parameters.AddWithValue("@reason", DescriptionTextBox.Text + "(خروج از پوشش خانواری به علت " + reason + "در تاریخ " + DateTime.Now.Date.ToPersian() + ")"); cmdc.Parameters.AddWithValue("@folder_id", String.Format("{0}", reader["folder_id"])); cmdc.Parameters.AddWithValue("@birthdate", Convert.ToDateTime(String.Format("{0}", reader["birthdate"])).Date); cmdc.Parameters.AddWithValue("@folderdate", Convert.ToDateTime(String.Format("{0}", reader["folderdate"])).Date); cmdc.Parameters.AddWithValue("@iName", String.Format("{0}", reader["identifierName"])); cmdc.Parameters.AddWithValue("@iPhone", String.Format("{0}", reader["identifierPhone"])); cmdc.Parameters.AddWithValue("@checkdate", Convert.ToDateTime(String.Format("{0}", reader["checkdate"])).Date); cmdc.Parameters.AddWithValue("@setupdate", DateTime.Now.Date); cmdc.Parameters.AddWithValue("@abandoneddate", DateTime.Now.Date); cmdc.Parameters.AddWithValue("@status", "خروج خانواری"); if (familyRegioncheckBox.Checked) { cmdc.Parameters.AddWithValue("@famReg", "بله"); } else { cmdc.Parameters.AddWithValue("@famReg", "خیر"); } if (financialcheckBox.Checked) { cmdc.Parameters.AddWithValue("@fin", "بله"); } else { cmdc.Parameters.AddWithValue("@fin", "خیر"); } } } cmdc.ExecuteNonQuery(); System.Globalization.PersianCalendar _persian = new System.Globalization.PersianCalendar(); foreach (var fm in doc) { string fileName = System.IO.Path.GetFileName(fm); string targetPath = defaultPath + "\\" + this.fold + "\\" + i + "\\deletion"; string destFile = System.IO.Path.Combine(targetPath, fileName); if (System.IO.File.Exists(destFile)) { destFile = System.IO.Path.Combine(targetPath, fileName.Substring(0, fileName.Length - 4) + _persian.GetYear(DateTime.Now.Date).ToString() + _persian.GetMonth(DateTime.Now.Date).ToString() + _persian.GetDayOfMonth(DateTime.Now.Date).ToString() + ".pdf"); } System.IO.File.Copy(fm, destFile, false); cmdc = new SqlCommand("insert into doc(id, docname, docpath, subdate, doctype) Values(@id, @dname, @dpath, @subdate, @dtype);", con1); cmdc.Parameters.AddWithValue("@id", i); cmdc.Parameters.AddWithValue("@dname", fileName); cmdc.Parameters.AddWithValue("@dpath", destFile); cmdc.Parameters.AddWithValue("@subdate", DateTime.Now.Date); cmdc.Parameters.AddWithValue("@dtype", "deletion"); cmdc.ExecuteNonQuery(); } } SqlCommand cmdget = new SqlCommand("select name, family, fatherName, id, supporter_id, sex, job, house, birthdate, folderdate, checkdate, health, otherSup, annual, seyed, car, homephone, cellphone, address, explain, rate, marriage, insurance, orphan, student, folder_id, identifierName, identifierPhone, enactmentId from member where id = @tmp", con1); cmdget.Parameters.AddWithValue("@tmp", this.id); SqlCommand cmd = new SqlCommand("begin tran t1; insert into abandoned(name, family, fatherName, id, supporter_id, sex, job, house, birthdate, folderdate, checkdate, health, otherSup, annual, seyed, car, marriage, insurance, orphan, student, homephone, cellphone, address, explain, folder_id, identifierName, identifierPhone, abandoneddate, reason, enactmentId)" + " Values(@name, @family, @fatherName, @id, @supporter_id, @sex, @job, @house, @birthdate, @folderdate, @checkdate, @health, @otherSup, @annual, @seyed, @car, @marriage, @ins, @orphan, @student, @homephone, @cellphone, @address, @explain, @folder_id, @iName, @iPhone, @abandoneddate, @description, @eId); " + "insert into outmember (id, setupdate, description, status, folder_id, familyRegion, financial) Values(@id, @setupdate, @description, @status, @folder_id, @famReg, @fin); " + "delete from onindependency where id = @id;" + "delete from member where id = @id; update Inmember Set kickdate= @abandoneddate where id = @id and kickdate is Null; commit tran t1;", con1); using (SqlDataReader reader = cmdget.ExecuteReader()) { if (reader.Read()) { cmd.Parameters.AddWithValue("@name", String.Format("{0}", reader["name"])); cmd.Parameters.AddWithValue("@family", String.Format("{0}", reader["family"])); cmd.Parameters.AddWithValue("@fatherName", String.Format("{0}", reader["fatherName"])); cmd.Parameters.AddWithValue("@id", String.Format("{0}", reader["id"])); cmd.Parameters.AddWithValue("@supporter_id", String.Format("{0}", reader["supporter_id"])); cmd.Parameters.AddWithValue("@eId", String.Format("{0}", reader["enactmentId"])); cmd.Parameters.AddWithValue("@sex", String.Format("{0}", reader["sex"])); cmd.Parameters.AddWithValue("@job", String.Format("{0}", reader["job"])); cmd.Parameters.AddWithValue("@house", String.Format("{0}", reader["house"])); cmd.Parameters.AddWithValue("@health", String.Format("{0}", reader["health"])); cmd.Parameters.AddWithValue("@otherSup", String.Format("{0}", reader["otherSup"])); cmd.Parameters.AddWithValue("@annual", String.Format("{0}", reader["annual"])); cmd.Parameters.AddWithValue("@seyed", String.Format("{0}", reader["seyed"])); cmd.Parameters.AddWithValue("@car", String.Format("{0}", reader["car"])); cmd.Parameters.AddWithValue("@marriage", String.Format("{0}", reader["marriage"])); cmd.Parameters.AddWithValue("@ins", String.Format("{0}", reader["insurance"])); cmd.Parameters.AddWithValue("@orphan", String.Format("{0}", reader["orphan"])); cmd.Parameters.AddWithValue("@student", String.Format("{0}", reader["student"])); cmd.Parameters.AddWithValue("@homephone", String.Format("{0}", reader["homephone"])); cmd.Parameters.AddWithValue("@cellphone", String.Format("{0}", reader["cellphone"])); cmd.Parameters.AddWithValue("@address", String.Format("{0}", reader["address"])); cmd.Parameters.AddWithValue("@explain", String.Format("{0}", reader["explain"]) + DescriptionTextBox.Text + "(خروج از پوشش خانواری به علت " + reason + "در تاریخ " + DateTime.Now.Date.ToPersian() + ")"); cmd.Parameters.AddWithValue("@folder_id", String.Format("{0}", reader["folder_id"])); cmd.Parameters.AddWithValue("@birthdate", Convert.ToDateTime(String.Format("{0}", reader["birthdate"])).Date); cmd.Parameters.AddWithValue("@folderdate", Convert.ToDateTime(String.Format("{0}", reader["folderdate"])).Date); cmd.Parameters.AddWithValue("@iName", String.Format("{0}", reader["identifierName"])); cmd.Parameters.AddWithValue("@iPhone", String.Format("{0}", reader["identifierPhone"])); cmd.Parameters.AddWithValue("@checkdate", Convert.ToDateTime(String.Format("{0}", reader["checkdate"])).Date); cmd.Parameters.AddWithValue("@setupdate", DateTime.Now.Date); cmd.Parameters.AddWithValue("@abandoneddate", DateTime.Now.Date); cmd.Parameters.AddWithValue("@description", DescriptionTextBox.Text + "(خروج از پوشش خانواری به علت " + reason + "در تاریخ " + DateTime.Now.Date.ToPersian() + ")"); cmd.Parameters.AddWithValue("@status", "خروج خانواری"); if (familyRegioncheckBox.Checked) { cmd.Parameters.AddWithValue("@famReg", "بله"); } else { cmd.Parameters.AddWithValue("@famReg", "خیر"); } if (financialcheckBox.Checked) { cmd.Parameters.AddWithValue("@fin", "بله"); } else { cmd.Parameters.AddWithValue("@fin", "خیر"); } } } cmd.ExecuteNonQuery(); foreach (var fm in doc) { string fileName = System.IO.Path.GetFileName(fm); string targetPath = defaultPath + "\\" + this.fold + "\\" + this.id + "\\deletion"; string destFile = System.IO.Path.Combine(targetPath, fileName); if (System.IO.File.Exists(destFile)) { destFile = System.IO.Path.Combine(targetPath, fileName.Substring(0, fileName.Length - 4) + " " + DateTime.Now.Date.ToPersian() + ".pdf"); } System.IO.File.Copy(fm, destFile, false); cmd = new SqlCommand("insert into doc(id, docname, docpath, subdate, doctype) Values(@id, @dname, @dpath, @subdate, @dtype);", con1); cmd.Parameters.AddWithValue("@id", this.id); cmd.Parameters.AddWithValue("@dname", fileName); cmd.Parameters.AddWithValue("@dpath", destFile); cmd.Parameters.AddWithValue("@subdate", DateTime.Now.Date); cmd.Parameters.AddWithValue("@dtype", "deletion"); cmd.ExecuteNonQuery(); } cmd = new SqlCommand("update research Set confirmed = @conf where id = (select max(research.id) from research, member where memberId = member.id and member.supporter_id = @sup and confirmed = N'خیر');", con1); cmd.Parameters.AddWithValue("@sup", this.id); cmd.Parameters.AddWithValue("@conf", "بله"); cmd.ExecuteNonQuery(); FMessegeBox.FarsiMessegeBox.Show("خانوار با موفقیت از پوشش خارج شد", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1); con1.Close(); this.Close(); } else { SqlCommand cmdcheck = new SqlCommand("select count(*) as sup from member where supporter_id = @sup and id != @sup", con1); cmdcheck.Parameters.AddWithValue("@sup", this.id); int sup = 0; using (SqlDataReader reader = cmdcheck.ExecuteReader()) { if (reader.Read()) { sup = int.Parse(String.Format("{0}", reader["sup"])); } } if (sup != 0) { var newform = new changeSupporterForm(this.Text, this.id); newform.ShowDialog(this); } sup = 0; using (SqlDataReader reader = cmdcheck.ExecuteReader()) { if (reader.Read()) { sup = int.Parse(String.Format("{0}", reader["sup"])); } } if (sup != 0) { FMessegeBox.FarsiMessegeBox.Show("این عضو سرپرست خانوار است و ابتدا باید وضعیت سرپرستی آنها را مشخص کنید!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1); con1.Close(); } else { SqlCommand cmdget = new SqlCommand("select name, family, fatherName, id, supporter_id, sex, job, house, birthdate, folderdate, checkdate, health, otherSup, annual, seyed, car, homephone, cellphone, address, explain, rate, marriage, insurance, orphan, student, folder_id, identifierName, identifierPhone from member where id = @tmp", con1); cmdget.Parameters.AddWithValue("@tmp", this.id); SqlCommand cmd = new SqlCommand("begin tran t1; insert into abandoned(name, family, fatherName, id, supporter_id, sex, job, house, birthdate, folderdate, checkdate, health, otherSup, annual, seyed, car, marriage, insurance, orphan, student, homephone, cellphone, address, explain, folder_id, identifierName, identifierPhone, abandoneddate, reason)" + " Values(@name, @family, @fatherName, @id, @supporter_id, @sex, @job, @house, @birthdate, @folderdate, @checkdate, @health, @otherSup, @annual, @seyed, @car, @marriage, @ins, @orphan, @student, @homephone, @cellphone, @address, @explain, @folder_id, @iName, @iPhone, @abandoneddate, @description); " + "insert into outmember (id, setupdate, description, status, folder_id, personRegion, dead, jobing, marry, service) Values(@id, @setupdate, @description, @status, @folder_id, @perReg, @dead, @jb, @mar, @serv); " + "delete from onindependency where id = @id;" + "delete from member where id = @id; update Inmember Set kickdate= @abandoneddate where id = @id and kickdate is Null; commit tran t1;", con1); using (SqlDataReader reader = cmdget.ExecuteReader()) { if (reader.Read()) { cmd.Parameters.AddWithValue("@name", String.Format("{0}", reader["name"])); cmd.Parameters.AddWithValue("@family", String.Format("{0}", reader["family"])); cmd.Parameters.AddWithValue("@fatherName", String.Format("{0}", reader["fatherName"])); cmd.Parameters.AddWithValue("@id", String.Format("{0}", reader["id"])); cmd.Parameters.AddWithValue("@supporter_id", String.Format("{0}", reader["supporter_id"])); cmd.Parameters.AddWithValue("@sex", String.Format("{0}", reader["sex"])); cmd.Parameters.AddWithValue("@job", String.Format("{0}", reader["job"])); cmd.Parameters.AddWithValue("@house", String.Format("{0}", reader["house"])); cmd.Parameters.AddWithValue("@health", String.Format("{0}", reader["health"])); cmd.Parameters.AddWithValue("@otherSup", String.Format("{0}", reader["otherSup"])); cmd.Parameters.AddWithValue("@annual", String.Format("{0}", reader["annual"])); cmd.Parameters.AddWithValue("@seyed", String.Format("{0}", reader["seyed"])); cmd.Parameters.AddWithValue("@car", String.Format("{0}", reader["car"])); if (marrycheckBox.Checked) { cmd.Parameters.AddWithValue("@marriage", "متأهل"); } else { cmd.Parameters.AddWithValue("@marriage", String.Format("{0}", reader["marriage"])); } cmd.Parameters.AddWithValue("@ins", String.Format("{0}", reader["insurance"])); cmd.Parameters.AddWithValue("@orphan", String.Format("{0}", reader["orphan"])); cmd.Parameters.AddWithValue("@student", String.Format("{0}", reader["student"])); cmd.Parameters.AddWithValue("@homephone", String.Format("{0}", reader["homephone"])); cmd.Parameters.AddWithValue("@cellphone", String.Format("{0}", reader["cellphone"])); cmd.Parameters.AddWithValue("@address", String.Format("{0}", reader["address"])); cmd.Parameters.AddWithValue("@explain", String.Format("{0}", reader["explain"]).ToString() + DescriptionTextBox.Text + "(خروج از پوشش فردی به علت " + reason + "در تاریخ " + DateTime.Now.Date.ToPersian() + ")"); cmd.Parameters.AddWithValue("@folder_id", String.Format("{0}", reader["folder_id"])); cmd.Parameters.AddWithValue("@birthdate", Convert.ToDateTime(String.Format("{0}", reader["birthdate"])).Date); cmd.Parameters.AddWithValue("@folderdate", Convert.ToDateTime(String.Format("{0}", reader["folderdate"])).Date); cmd.Parameters.AddWithValue("@iName", String.Format("{0}", reader["identifierName"])); cmd.Parameters.AddWithValue("@iPhone", String.Format("{0}", reader["identifierPhone"])); cmd.Parameters.AddWithValue("@checkdate", Convert.ToDateTime(String.Format("{0}", reader["checkdate"])).Date); cmd.Parameters.AddWithValue("@setupdate", DateTime.Now.Date); cmd.Parameters.AddWithValue("@abandoneddate", DateTime.Now.Date); cmd.Parameters.AddWithValue("@description", DescriptionTextBox.Text + "(خروج از پوشش فردی به علت " + reason + "در تاریخ " + DateTime.Now.Date.ToPersian() + ")"); cmd.Parameters.AddWithValue("@status", "خروج فردی"); if (personRegioncheckBox.Checked) { cmd.Parameters.AddWithValue("@perReg", "بله"); } else { cmd.Parameters.AddWithValue("@perReg", "خیر"); } if (deadcheckBox.Checked) { cmd.Parameters.AddWithValue("@dead", "بله"); } else { cmd.Parameters.AddWithValue("@dead", "خیر"); } if (servicecheckBox.Checked) { cmd.Parameters.AddWithValue("@serv", "بله"); } else { cmd.Parameters.AddWithValue("@serv", "خیر"); } if (jobingcheckBox.Checked) { cmd.Parameters.AddWithValue("@jb", "بله"); } else { cmd.Parameters.AddWithValue("@jb", "خیر"); } if (marrycheckBox.Checked) { cmd.Parameters.AddWithValue("@mar", "بله"); } else { cmd.Parameters.AddWithValue("@mar", "خیر"); } } } cmd.ExecuteNonQuery(); foreach (var fm in doc) { string fileName = System.IO.Path.GetFileName(fm); string targetPath = defaultPath + "\\" + this.fold + "\\" + this.id + "\\deletion"; string destFile = System.IO.Path.Combine(targetPath, fileName); if (System.IO.File.Exists(destFile)) { destFile = System.IO.Path.Combine(targetPath, fileName.Substring(0, fileName.Length - 4) + " " + DateTime.Now.Date.ToPersian() + ".pdf"); } System.IO.File.Copy(fm, destFile, false); cmd = new SqlCommand("insert into doc(id, docname, docpath, subdate, doctype) Values(@id, @dname, @dpath, @subdate, @dtype);", con1); cmd.Parameters.AddWithValue("@id", this.id); cmd.Parameters.AddWithValue("@dname", fileName); cmd.Parameters.AddWithValue("@dpath", destFile); cmd.Parameters.AddWithValue("@subdate", DateTime.Now.Date); cmd.Parameters.AddWithValue("@dtype", "deletion"); cmd.ExecuteNonQuery(); } FMessegeBox.FarsiMessegeBox.Show("عضو با موفقیت از پوشش خارج شد", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1); con1.Close(); this.Close(); } } }