private void Daryafti_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
tamin_Report form = new tamin_Report(dt);
form.Show();
this.Hide();
}
private void button2_Click(object sender, EventArgs e)
{
using (Context dbcontext = new Context())
{
List <Model.tamin> lst = dbcontext.tamins.Where(c => !dbcontext.Archives.Select(b => b.shomareTamin).Contains(c.shomareSanad)).ToList();
tamin_Report tr = new tamin_Report(ToDataTable(lst));
tr.Show();
}
}
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)
{
}
}