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();
}
