private void shomareSanad_Leave(object sender, EventArgs e) { var number = shomareSanad.Text; using (Model.Context dbcontext = new Model.Context()) { tamin model = dbcontext.tamins.FirstOrDefault(x => x.shomareSanad == number); if (model != null) { header.Text = "این شماره قبلا ثبت شده است"; header.ForeColor = Color.Red; } } }
private void filter_Click(object sender, EventArgs e) { var number = shomareSanad.Text; using (Model.Context dbcontext = new Model.Context()) { tamin model = dbcontext.tamins.FirstOrDefault(x => x.shomareSanad == number); if (model != null) { header.Text = "این شماره قبلا ثبت شده است"; return; } } if (radif.SelectedValue == null && subject.SelectedItem.ToString() != "سایر هزینه ها") { header.Text = "ردیف انتخاب نشده است"; header.ForeColor = Color.Red; return; } header.Text = "1"; string sanad = shomareSanad.Text; Int64 mbl = Int64.Parse(price.Text); string prj = project.SelectedValue.ToString(); var shenasname = context.shenasnames.SingleOrDefault(x => x.ID == prj); string shenasnameID = shenasname.ID; string shenasnameTitle = shenasname.title; string rd = subject.SelectedText != "مواد اولیه" ? "" : radif.SelectedValue.ToString(); header.Text = "2"; archive pastmodel = context.Archives.SingleOrDefault(x => x.hesab == "0" && x.shomareSanad == sanad && x.mablagh == mbl && x.shnesnameTitle == shenasnameTitle && x.radif == rd); if (pastmodel != null) { header.Text = "برای پارامتر های موجود فاکتور انتخاب شده است"; header.ForeColor = Color.Red; return; } functions fns = new functions(); var directory = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData); string mrk = ""; mrk = (from sh in context.shenasnames join ma in context.markazs on sh.markaz equals ma.parent where sh.title == shenasnameTitle select ma).First().title; header.Text = "3"; string root = Path.Combine(directory, "FIM"); System.IO.Directory.CreateDirectory(root); string taminPath = Path.Combine(root, "tamin"); System.IO.Directory.CreateDirectory(taminPath); string trkh = date.GetSelectedDateInPersianDateTime().ToShortDateString().Replace("/", ""); string finalPrice = ""; if (shomareSanad.Text == "") { header.Text = "شماره سند را وارد نمایید"; header.ForeColor = Color.Red; return; } if (price.Text == "") { header.Text = "مبلغ را وارد نمایید"; header.ForeColor = Color.Red; return; } float intprice = float.Parse(price.Text); if (intprice / 1000000 > 1) { finalPrice = (intprice / 1000000) + "MT"; } else { finalPrice = (intprice / 1000) + "HT"; } string finalname = ""; string random = RandomNumber(10000, 99999).ToString(); string sourcAddress = sourceLable.Text; finalname = random + Path.GetExtension(sourcAddress); imageName.Text = Path.Combine(taminPath, finalname).Replace(directory, ""); string finalPath = taminPath + "\\" + finalname; //try //{ // System.IO.File.Delete(sourcAddress); //} //catch (IOException error) //{ //} if (moneytype.SelectedItem == null) { header.Text = "واحد پولی را انتخاب کنید"; header.ForeColor = Color.Red; return; } if (pastmodel != null) { header.Text = "برای پارامتر های موجود فاکتور انتخاب شده است"; header.ForeColor = Color.Red; return; } //string rd = ""; string rdTitle = ""; string choosenSubject = subject.Text; if (radif.SelectedValue != null) { rd = radif.SelectedValue.ToString(); int intrd = Int32.Parse(rd); switch (choosenSubject) { case "اجراییات": rdTitle = context.ejraeiats.SingleOrDefault(x => x.ID == intrd).title; break; case "سرمایه": rdTitle = context.sarmayes.SingleOrDefault(x => x.ID == intrd).title; break; case "قرارداد": rdTitle = context.gharardads.SingleOrDefault(x => x.ID == intrd).title; break; case "عمرانی": rdTitle = context.omranis.SingleOrDefault(x => x.ID == intrd).title; break; case "اداری": rdTitle = context.edaris.SingleOrDefault(x => x.ID == intrd).title; break; case "مصرفی": rdTitle = context.masrafis.SingleOrDefault(x => x.ID == intrd).title; break; case "مواد": rdTitle = context.sayers.SingleOrDefault(x => x.ID == intrd).title; break; case "تشویقی": rdTitle = context.tashvighis.SingleOrDefault(x => x.ID == intrd).title; break; } } bool isreferbish = referbish.Text == "0" ? false : true; string sbj = choosenSubject; DateTime trk = date.GetSelectedDateInPersianDateTime().ToShortDateString().ToGeorgianDateTime(); string typ = moneytype.SelectedItem.ToString(); tamin newITem = new tamin() { radif = rd, mablagh = mbl, markaz = "", project = shenasnameID, shnesnameTitle = shenasnameTitle, radifTitle = rdTitle, shomareSanad = sanad, subject = sbj, tarikh = trk, type = typ, hesab = "0", imageName = imageName.Text, //bankName = bank.Text, //checkNumber = checkNumber.Text, //referbish = isreferbish }; context.tamins.Add(newITem); context.SaveChanges(); webBrowser1.Navigate("http://localhost/"); DataTable dt = new DataTable(); tamin_Report taminform = new tamin_Report(dt); taminform.Show(); this.Close(); File.Move(sourcAddress, finalPath); try { File.Delete(sourcAddress); } catch (IOException error) { } }
private void filter_Click(object sender, EventArgs e) { var tamintxt = tamin.Text; if (tamintxt == "") { header.Text = "تامین انتخاب نشده است"; header.ForeColor = Color.Red; return; } tamin model = context.tamins.SingleOrDefault(x => x.shomareSanad == tamintxt); if (model == null) { header.Text = "شماره تامین وجود ندارد"; header.ForeColor = Color.Red; return; } Context dbcontext = new Context(); string sanad = shomareSanad1.Text; if (sanad == "") { header.Text = "شماره سند انتخاب نشده است"; header.ForeColor = Color.Red; return; } Int64 mbl = model.mablagh; string shenasnameTitle = model.shnesnameTitle; archive pastmodel = dbcontext.Archives.SingleOrDefault(x => x.shomareTamin == tamintxt && x.shomareSanad == sanad); if (pastmodel != null) { header.Text = "برای پارامتر های موجود فاکتور انتخاب شده است"; header.ForeColor = Color.Red; return; } functions fns = new functions(); var directory = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData); string mrk = ""; mrk = (from sh in dbcontext.shenasnames join ma in dbcontext.markazs on sh.markaz equals ma.parent where sh.title == shenasnameTitle select ma).First().title; string root = Path.Combine(directory, "FIM"); System.IO.Directory.CreateDirectory(root); string markazPath = Path.Combine(root, mrk); System.IO.Directory.CreateDirectory(markazPath); string shenasnamePath = Path.Combine(markazPath, shenasnameTitle); System.IO.Directory.CreateDirectory(shenasnamePath); string pardPath = Path.Combine(shenasnamePath, "فاکتور های پرداختی"); System.IO.Directory.CreateDirectory(pardPath); string sourcAddress = sourceLable.Text; string trkh = date.GetSelectedDateInPersianDateTime().ToShortDateString().Replace("/", ""); string finalPrice = ""; float intprice = model.mablagh; if (intprice / 1000000 > 1) { finalPrice = (intprice / 1000000) + "MT"; } else { finalPrice = (intprice / 1000) + "HT"; } string finalname = ""; if (bank.Text == "") { finalname = "تامینی" + "_" + shomareSanad1.Text + Path.GetExtension(sourcAddress); } else { string sv = checkNumber.SelectedValue.ToString(); finalname = "check" + "_" + bank.Text + "_" + sv + Path.GetExtension(sourcAddress); } imageName.Text = Path.Combine(pardPath, finalname).Replace(directory, ""); string finalPath = pardPath + "\\" + finalname; bool isreferbish = referbish.Text == "0" ? false : true; DateTime trk = date.GetSelectedDateInPersianDateTime().ToShortDateString().ToGeorgianDateTime(); archive newITem = new archive() { radif = "", mablagh = 0, markaz = "", project = "", shnesnameTitle = "", radifTitle = "", shomareSanad = sanad, shomareTamin = tamintxt, subject = "", tarikh = trk, type = "", hesab = "0", imageName = imageName.Text, bankName = bank.Text, checkNumber = checkNumber.Text, referbish = isreferbish }; check checkitem = context.checks.SingleOrDefault(x => x.checkNumber == checkNumber.Text); checkitem.isUsed = true; context.Archives.Add(newITem); context.SaveChanges(); System.IO.File.Move(sourcAddress, finalPath); DataTable dt = new DataTable(); PardakhtiReport daryaftirp = new PardakhtiReport(dt); daryaftirp.Show(); this.Hide(); }