public daryaftiNew()
{
InitializeComponent();
try
{
FontClass fontclass = new FontClass();
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = mostaan.GlobalVariable.headerlistFONTsmall);
this.MaximizeBox = true;
this.CenterToScreen();
using (Context dbcontext = new Context())
{
List <shenasname> list = dbcontext.shenasnames.Where(x => x.master == "1" && x.final == 1).ToList();
project.DataSource = list;
project.DisplayMember = "title";
project.ValueMember = "ID";
List <Model.bank> bnks = dbcontext.banks.ToList();
bank.DataSource = bnks;
bank.DisplayMember = "FullName";
bank.ValueMember = "ID";
}
}
catch (Exception)
{
}
}
public Message()
{
InitializeComponent();
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = GlobalVariable.headerlistFONT);
setDataForGrid("");
this.CenterToScreen();
//
header.Font = GlobalVariable.shoonzdah;
int count = 0;
try
{
string srt = GlobalVariable.notSeenInbox.Substring(2, GlobalVariable.notSeenInbox.Count() - 3);
count = srt.Split(',').Count();
List <string> countList = srt.Split(',').ToList();
}
catch (Exception)
{
}
if (count > 0)
{
label1.Text = count.ToString() + " مورد خوانده نشده ";
}
else
{
label1.Visible = false;
}
}
public Form14_add_edari()
{
InitializeComponent();
FontClass fontclass = new FontClass();
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = mostaan.GlobalVariable.headerlistFONTsmall);
this.MaximizeBox = false;
this.CenterToScreen();
radPanel1.PanelElement.Shape = new RoundRectShape();
radPanel1.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel1.PanelElement.PanelFill.BackColor = Color.White;
radPanel2.PanelElement.Shape = new RoundRectShape();
radPanel2.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel2.PanelElement.PanelFill.BackColor = Color.White;
radPanel3.PanelElement.Shape = new RoundRectShape();
radPanel3.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel3.PanelElement.PanelFill.BackColor = Color.White;
radPanel7.PanelElement.Shape = new RoundRectShape();
radPanel7.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel7.PanelElement.PanelFill.BackColor = Color.Violet;
}
private void search_Load(object sender, EventArgs e)
{
log = JsonConvert.DeserializeObject <CatsAndAreasObject>(GlobalVariable.newCatsAndAreas);
this.MaximizeBox = true;
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = GlobalVariable.headerlistFONT);
Settings1.Default.IsLogedIn = "1";
setcat();
//log = GlobalVariable.catsAndAreas;
//Settings1.Default.IsLogedIn = "1";
//setcatforclient();
panel1.PanelElement.Shape = new RoundRectShape();
panel1.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
panel1.PanelElement.PanelFill.BackColor = Color.White;
panel2.PanelElement.Shape = new RoundRectShape();
panel2.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
panel2.PanelElement.PanelFill.BackColor = Color.White;
panel3.PanelElement.Shape = new RoundRectShape();
panel3.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
panel3.PanelElement.PanelFill.BackColor = Color.White;
radPanel38.PanelElement.Shape = new RoundRectShape();
mantagheNameText.Text = "";
mantagheNameText2.Text = "";
}
public PardakhtiFilter(string type)
{
InitializeComponent();
header.Text = "افزودن اطلاعات پرداختی جدید";
filterPanel1.PanelElement.Shape = new RoundRectShape();
filterPanel1.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
filterPanel1.PanelElement.PanelFill.BackColor = Color.Gray;
initFont();
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = mostaan.GlobalVariable.headerlistFONTsmall);
this.MaximizeBox = false;
this.CenterToScreen();
List <shenasname> list = context.shenasnames.Where(x => x.master == "1" && x.final == 1).ToList();
project.DataSource = list;
project.DisplayMember = "title";
project.ValueMember = "ID";
project.SelectedItem = null;
project.SelectedText = "--انتخاب شناسنامه--";
}
public login()
{
InitializeComponent();
FontClass fontclass = new FontClass();
initFont();
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = mostaan.GlobalVariable.headerlistFONTsmall);
this.MaximizeBox = false;
loginFormHeaderPanel.PanelElement.Shape = new RoundRectShape();
loginFormHeaderPanel.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
loginFormHeaderPanel.PanelElement.PanelFill.BackColor = Color.Gray;
loginBodyPanle.PanelElement.Shape = new RoundRectShape();
loginBodyPanle.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
loginBodyPanle.PanelElement.PanelFill.BackColor = Color.White;
verifPanel.PanelElement.Shape = new RoundRectShape();
verifPanel.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
verifPanel.PanelElement.PanelFill.BackColor = Color.Gray;
this.CenterToScreen();
}
private void main_Load(object sender, EventArgs e)
{
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = GlobalVariable.headerlistFONT);
this.CenterToScreen();
dataLable.Text = dateTimeConvert.ToPersianDateString(DateTime.Now);
}
private void dopreliminaries()
{
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = GlobalVariable.headerlistFONT);
DDTO.Text = dateTimeConvert.ToPersianDateString(System.DateTime.Now);
this.CenterToScreen();
}
public HamshahriAdd()
{
InitializeComponent();
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = GlobalVariable.headerlistFONT);
this.CenterToScreen();
label3.Font = GlobalVariable.HlistFONT;
label4.Font = GlobalVariable.headerlistFONTBold;
}
public DaReport_new()
{
InitializeComponent();
FontClass fontclass = new FontClass();
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = mostaan.GlobalVariable.headerlistFONTsmall);
this.MaximizeBox = false;
this.CenterToScreen();
}
public zero()
{
InitializeComponent();
FontClass fontclass = new FontClass();
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = mostaan.GlobalVariable.headerlistFONTsmall);
this.MaximizeBox = false;
this.CenterToScreen();
panle1.PanelElement.Shape = new RoundRectShape();
panle1.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
panle1.PanelElement.PanelFill.BackColor = Color.Gray;
radPanel1.PanelElement.Shape = new RoundRectShape();
radPanel1.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel1.PanelElement.PanelFill.BackColor = Color.Gray;
radPanel2.PanelElement.Shape = new RoundRectShape();
radPanel2.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel2.PanelElement.PanelFill.BackColor = Color.Gray;
radPanel3.PanelElement.Shape = new RoundRectShape();
radPanel3.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel3.PanelElement.PanelFill.BackColor = Color.Gray;
radPanel4.PanelElement.Shape = new RoundRectShape();
radPanel4.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel4.PanelElement.PanelFill.BackColor = Color.Gray;
radPanel5.PanelElement.Shape = new RoundRectShape();
radPanel5.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel5.PanelElement.PanelFill.BackColor = Color.Gray;
radPanel6.PanelElement.Shape = new RoundRectShape();
radPanel6.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel6.PanelElement.PanelFill.BackColor = Color.Gray;
radPanel7.PanelElement.Shape = new RoundRectShape();
radPanel7.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel7.PanelElement.PanelFill.BackColor = Color.Gray;
var directory = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData);
string root = Path.Combine(directory, "FIM");
string trashPath = Path.Combine(root, "trash");
if (Directory.Exists(trashPath))
{
var dir = new DirectoryInfo(trashPath);
dir.Delete(true);
}
this.CenterToScreen();
}
public Bank_List(DataTable dt1)
{
InitializeComponent();
FontClass fontclass = new FontClass();
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = mostaan.GlobalVariable.headerlistFONTsmall);
this.MaximizeBox = false;
this.CenterToScreen();
if (dt1.Columns.Count != 0)
{
dataGridView1.DataSource = dt1;
}
else
{
using (Context dbcontext = new Context())
{
List <Model.bank> lst = (from p in dbcontext.banks select p).ToList();
dataGridView1.DataSource = lst;
}
}
dataGridView1.Width = 550;
dataGridView1.Columns["ID"].HeaderText = "ردیف";
dataGridView1.Columns["ID"].Width = 120;
dataGridView1.Columns["ID"].DisplayIndex = 1;
dataGridView1.Columns["title"].HeaderText = "نام بانک";
dataGridView1.Columns["title"].Width = 200;
dataGridView1.Columns["title"].DisplayIndex = 2;
dataGridView1.Columns["title"].DefaultCellStyle.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns["number"].HeaderText = "شماره حساب";
dataGridView1.Columns["number"].Width = 200;
dataGridView1.Columns["number"].DisplayIndex = 3;
dataGridView1.Columns["number"].DefaultCellStyle.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns["type"].HeaderText = "نوع حساب";
dataGridView1.Columns["type"].Width = 200;
dataGridView1.Columns["type"].DisplayIndex = 3;
dataGridView1.Columns["type"].DefaultCellStyle.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns["fullname"].Visible = false;
dataGridView1.Columns[0].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[1].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[2].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[3].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
}
private void setPreliminaries()
{
this.WindowState = FormWindowState.Maximized;
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = GlobalVariable.headerlistFONT);
foreach (DataGridViewColumn c in listGrid.Columns)
{
c.DefaultCellStyle.Font = GlobalVariable.headerlistFONT;
}
}
public Intro()
{
InitializeComponent();
initFont();
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = mostaan.GlobalVariable.headerlistFONTsmall);
label1.Font = GlobalVariable.headerlistFONT;
this.MaximizeBox = false;
this.CenterToScreen();
}
private void main_Load(object sender, EventArgs e)
{
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = GlobalVariable.headerlistFONT);
this.CenterToScreen();
dataLable.Text = dateTimeConvert.ToPersianDateString(DateTime.Now);
manager.delinbox();
getInbox(); // admin only get any message from internetServer
getNewMessageNumber(System.Environment.MachineName); // user
}
public HamshahriList()
{
InitializeComponent();
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = GlobalVariable.headerlistFONT);
allControls.Where(x => x.Name == "label1").FirstOrDefault().Font = GlobalVariable.HlistFONT;
this.CenterToScreen();
setDataGrid();
}
public deleteVrification(string srt, string type, string extradata)
{
deltype = type;
EXTRA = extradata;
InitializeComponent();
id = srt;
this.CenterToScreen();
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = GlobalVariable.headerlistFONT);
label1.Font = GlobalVariable.shoonzdah;
}
public ChooseBank()
{
InitializeComponent();
initFont();
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = mostaan.GlobalVariable.headerlistFONTsmall);
this.MaximizeBox = false;
panle1.PanelElement.Shape = new RoundRectShape();
panle1.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
panle1.PanelElement.PanelFill.BackColor = Color.Gray;
panle2.PanelElement.Shape = new RoundRectShape();
panle2.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
panle2.PanelElement.PanelFill.BackColor = Color.Gray;
this.CenterToScreen();
}
private void dopreliminaries()
{
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = GlobalVariable.headerlistFONT);
this.CenterToScreen();
serialNumber.Text = " - - - - - - - - - - - - - - - - ";
serialNumber.Font = GlobalVariable.HlistFONT;
label1.Font = GlobalVariable.shoonzdah;
label3.Font = GlobalVariable.shoonzdah;
this.MaximizeBox = false;
if (Settings1.Default.SerialNumber != "")
{
checkSerial();
}
}
public checkAdd()
{
InitializeComponent();
FontClass fontclass = new FontClass();
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = mostaan.GlobalVariable.headerlistFONTsmall);
this.MaximizeBox = false;
this.CenterToScreen();
using (Context context = new Context())
{
List <Model.bank> bnks = context.banks.ToList();
bankCombo.DataSource = bnks;
bankCombo.DisplayMember = "FullName";
bankCombo.ValueMember = "ID";
}
}
public tamincheck(string id)
{
InitializeComponent();
FontClass fontclass = new FontClass();
this.MaximizeBox = false;
this.CenterToScreen();
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = mostaan.GlobalVariable.headerlistFONTsmall);
Model.tamin model = context.tamins.SingleOrDefault(x => x.shomareSanad == id);
shenasname.Text = model.shnesnameTitle;
jadval.Text = model.subject;
radif.Text = model.radifTitle;
gheymat.Text = model.mablagh.ToString();
vahed.Text = model.type;
}
public pardakhtiNew(string type)
{
InitializeComponent();
referbish.Text = type;
filterPanel1.PanelElement.Shape = new RoundRectShape();
filterPanel1.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
filterPanel1.PanelElement.PanelFill.BackColor = Color.Gray;
initFont();
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = mostaan.GlobalVariable.headerlistFONTsmall);
this.MaximizeBox = false;
this.CenterToScreen();
}
public void initFont()
{
byte[] fontData = Properties.Resources.IRANSans_FaNum_;
IntPtr fontPtr = System.Runtime.InteropServices.Marshal.AllocCoTaskMem(fontData.Length);
System.Runtime.InteropServices.Marshal.Copy(fontData, 0, fontPtr, fontData.Length);
uint dummy = 0;
fonts.AddMemoryFont(fontPtr, Properties.Resources.IRANSans_FaNum_.Length);
AddFontMemResourceEx(fontPtr, (uint)Properties.Resources.IRANSans_FaNum_.Length, IntPtr.Zero, ref dummy);
System.Runtime.InteropServices.Marshal.FreeCoTaskMem(fontPtr);
GlobalVariable.headerlistFONT = new Font(fonts.Families[0], 9.0F, System.Drawing.FontStyle.Regular);
GlobalVariable.headerlistFONTsmall = new Font(fonts.Families[0], 8.0F, System.Drawing.FontStyle.Regular);
GlobalVariable.headerlistFONTBold = new Font(fonts.Families[0], 11.0F, System.Drawing.FontStyle.Bold);
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = GlobalVariable.headerlistFONT);
}
private void setPreliminaries()
{
Settings1.Default.address = "A";
Settings1.Default.rahntotal = "A";
Settings1.Default.ejaremetri = "A";
listGrid.Columns[9].DefaultCellStyle.Format = "N3";
listGrid.Columns[10].DefaultCellStyle.Format = "N3";
this.WindowState = FormWindowState.Maximized;
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = GlobalVariable.headerlistFONT);
foreach (DataGridViewColumn c in listGrid.Columns)
{
c.DefaultCellStyle.Font = GlobalVariable.headerlistFONT;
}
}
private void setPreliminaries()
{
Settings1.Default.address = "A";
Settings1.Default.rahntotal = "A";
Settings1.Default.ejaremetri = "A";
listGrid.Columns["rahn_total"].DefaultCellStyle.Format = "N3";
listGrid.Columns["ejare_metri"].DefaultCellStyle.Format = "N3";
this.WindowState = FormWindowState.Maximized;
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = GlobalVariable.headerlistFONT);
foreach (DataGridViewColumn c in listGrid.Columns)
{
c.DefaultCellStyle.Font = GlobalVariable.headerlistFONT;
}
getDataBackGroundWorkerFileList.WorkerSupportsCancellation = true;
getDataBackGroundWorkerFileList.DoWork += new DoWorkEventHandler(getDataBackGroundWorkerFileList_do);
getDataBackGroundWorkerFileList.RunWorkerCompleted += new RunWorkerCompletedEventHandler(getDataBackGroundWorkerFileList_done);
}
public tamin_New(string type)
{
InitializeComponent();
referbish.Text = type;
List <shenasname> list = context.shenasnames.Where(x => x.master == "1" && x.final == 1).ToList();
project.DataSource = list;
project.DisplayMember = "title";
project.ValueMember = "ID";
filterPanel1.PanelElement.Shape = new RoundRectShape();
filterPanel1.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
filterPanel1.PanelElement.PanelFill.BackColor = Color.Gray;
initFont();
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = mostaan.GlobalVariable.headerlistFONTsmall);
this.MaximizeBox = false;
this.CenterToScreen();
}
public daryaftiReport(DataTable dt1)
{
InitializeComponent();
FontClass fontclass = new FontClass();
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = mostaan.GlobalVariable.headerlistFONTsmall);
this.MaximizeBox = false;
this.CenterToScreen();
if (dt1.Columns.Count != 0)
{
dataGridView1.DataSource = dt1;
}
else
{
using (Context dbcontext = new Context())
{
List <Model.archive> lst = (from p in dbcontext.Archives where p.hesab == "1" select p).OrderBy(x => x.ID).ToList();
dataGridView1.DataSource = lst;
}
}
dataGridView1.Width = 1020;
dataGridView1.Columns["ID"].HeaderText = "ردیف";
dataGridView1.Columns["ID"].Width = 120;
dataGridView1.Columns["ID"].DisplayIndex = 3;
dataGridView1.Columns["referbish"].HeaderText = "اصلاحیه";
dataGridView1.Columns["referbish"].Width = 200;
dataGridView1.Columns["referbish"].DisplayIndex = 9;
dataGridView1.Columns["referbish"].DefaultCellStyle.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns["shomareSanad"].HeaderText = "شماره سند";
dataGridView1.Columns["shomareSanad"].Width = 200;
dataGridView1.Columns["shomareSanad"].DisplayIndex = 4;
dataGridView1.Columns["shomareSanad"].DefaultCellStyle.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns["shnesnameTitle"].HeaderText = "عنوان شناسنامه";
dataGridView1.Columns["shnesnameTitle"].Width = 300;
dataGridView1.Columns["shnesnameTitle"].DisplayIndex = 5;
dataGridView1.Columns["shnesnameTitle"].DefaultCellStyle.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns["subject"].HeaderText = "عنوان";
dataGridView1.Columns["subject"].Width = 300;
dataGridView1.Columns["subject"].DisplayIndex = 6;
dataGridView1.Columns["subject"].DefaultCellStyle.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns["type"].HeaderText = "واحد پولی";
dataGridView1.Columns["type"].Width = 200;
dataGridView1.Columns["type"].DisplayIndex = 7;
dataGridView1.Columns["type"].DefaultCellStyle.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns["mablagh"].HeaderText = "مبلغ ";
dataGridView1.Columns["mablagh"].Width = 200;
dataGridView1.Columns["mablagh"].DisplayIndex = 8;
dataGridView1.Columns["mablagh"].DefaultCellStyle.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns["checkNumber"].HeaderText = "شماره چک ";
dataGridView1.Columns["checkNumber"].Width = 200;
dataGridView1.Columns["checkNumber"].DisplayIndex = 9;
dataGridView1.Columns["checkNumber"].DefaultCellStyle.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns["bankName"].HeaderText = "بانک عامل ";
dataGridView1.Columns["bankName"].Width = 200;
dataGridView1.Columns["bankName"].DisplayIndex = 10;
dataGridView1.Columns["bankName"].DefaultCellStyle.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns["imageName"].Visible = false;
dataGridView1.Columns["rank"].Visible = false;
dataGridView1.Columns["markaz"].Visible = false;
dataGridView1.Columns["tarikh"].Visible = false;
dataGridView1.Columns["variz"].Visible = false;
dataGridView1.Columns["hesab"].Visible = false;
dataGridView1.Columns["radif"].Visible = false;
dataGridView1.Columns["radifTitle"].Visible = false;
dataGridView1.Columns["project"].Visible = false;
}
public Form19_saryer()
{
string shenasnameID = GlobalVariable.shenasnameID;
InitializeComponent();
FontClass fontclass = new FontClass();
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = mostaan.GlobalVariable.headerlistFONTsmall);
header.Font = mostaan.GlobalVariable.headerlistFONT;
this.MaximizeBox = false;
this.CenterToScreen();
//panel1.PanelElement.Shape = new RoundRectShape();
//panel1.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
//panel1.PanelElement.PanelFill.BackColor = Color.White;
panel2.PanelElement.Shape = new RoundRectShape();
panel2.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
panel2.PanelElement.PanelFill.BackColor = Color.White;
panel3.PanelElement.Shape = new RoundRectShape();
panel3.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
panel3.PanelElement.PanelFill.BackColor = Color.Violet;
radPanel1.PanelElement.Shape = new RoundRectShape();
radPanel1.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel1.PanelElement.PanelFill.BackColor = Color.White;
radPanel2.PanelElement.Shape = new RoundRectShape();
radPanel2.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel2.PanelElement.PanelFill.BackColor = Color.White;
radPanel3.PanelElement.Shape = new RoundRectShape();
radPanel3.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel3.PanelElement.PanelFill.BackColor = Color.White;
radPanel4.PanelElement.Shape = new RoundRectShape();
radPanel4.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel4.PanelElement.PanelFill.BackColor = Color.White;
radPanel5.PanelElement.Shape = new RoundRectShape();
radPanel5.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel5.PanelElement.PanelFill.BackColor = Color.White;
radPanel6.PanelElement.Shape = new RoundRectShape();
radPanel6.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel6.PanelElement.PanelFill.BackColor = Color.White;
radPanel7.PanelElement.Shape = new RoundRectShape();
radPanel7.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel7.PanelElement.PanelFill.BackColor = Color.White;
radPanel8.PanelElement.Shape = new RoundRectShape();
radPanel8.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel8.PanelElement.PanelFill.BackColor = Color.Violet;
radPanel9.PanelElement.Shape = new RoundRectShape();
radPanel9.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel9.PanelElement.PanelFill.BackColor = Color.White;
radPanel10.PanelElement.Shape = new RoundRectShape();
radPanel10.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel10.PanelElement.PanelFill.BackColor = Color.White;
radPanel1.PanelElement.Shape = new RoundRectShape();
radPanel1.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel1.PanelElement.PanelFill.BackColor = Color.White;
radPanel13.PanelElement.Shape = new RoundRectShape();
radPanel13.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel13.PanelElement.PanelFill.BackColor = Color.Blue;
radPanel14.PanelElement.Shape = new RoundRectShape();
radPanel14.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel14.PanelElement.PanelFill.BackColor = Color.Gray;
label1.Font = GlobalVariable.headerlistFONTsupecSmall;
label4.Font = GlobalVariable.headerlistFONTsupecSmall;
label5.Font = GlobalVariable.headerlistFONTsupecSmall;
label6.Font = GlobalVariable.headerlistFONTsupecSmall;
label7.Font = GlobalVariable.headerlistFONTsupecSmall;
label8.Font = GlobalVariable.headerlistFONTsupecSmall;
label9.Font = GlobalVariable.headerlistFONTsupecSmall;
label10.Font = GlobalVariable.headerlistFONTsupecSmall;
label11.Font = GlobalVariable.headerlistFONTsupecSmall;
using (var dbcontext = new Model.Context())
{
List <Model.sayer> lst = (from p in dbcontext.sayers where p.shenasnameID == shenasnameID select p).ToList();
dataGridView1.DataSource = lst;
foreach (var item in lst)
{
item.ID = lst.IndexOf(item) + 1;
}
}
dataGridView1.Width = 2300;
dataGridView1.Columns["ID"].HeaderText = "ردیف";
dataGridView1.Columns["ID"].Width = 120;
dataGridView1.Columns["ID"].DisplayIndex = 1;
dataGridView1.Columns["title"].HeaderText = "نام دستگاه";
dataGridView1.Columns["title"].Width = 180;
dataGridView1.Columns["title"].DisplayIndex = 2;
dataGridView1.Columns["title"].DefaultCellStyle.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns["creatoreCo"].HeaderText = "شرکت سازنده یا فروشنده";
dataGridView1.Columns["creatoreCo"].Width = 180;
dataGridView1.Columns["creatoreCo"].DisplayIndex = 3;
dataGridView1.Columns["creatoreCo"].DefaultCellStyle.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns["count"].HeaderText = "تعداد";
dataGridView1.Columns["count"].Width = 180;
dataGridView1.Columns["count"].DisplayIndex = 4;
dataGridView1.Columns["vahedPR"].HeaderText = "قیمت واحد پیش بینی ریالی";
dataGridView1.Columns["vahedPR"].Width = 180;
dataGridView1.Columns["vahedPR"].DisplayIndex = 5;
dataGridView1.Columns["vahedNR"].HeaderText = "قیمت واحد نهایی ریالی";
dataGridView1.Columns["vahedNR"].Width = 180;
dataGridView1.Columns["vahedNR"].DefaultCellStyle.BackColor = Color.Gray;
dataGridView1.Columns["vahedNR"].DefaultCellStyle.ForeColor = Color.White;
dataGridView1.Columns["vahedNR"].DisplayIndex = 6;
dataGridView1.Columns["vahedPD"].HeaderText = "قیمت واحد پیش بینی دلاری";
dataGridView1.Columns["vahedPD"].Width = 180;
dataGridView1.Columns["vahedPD"].DisplayIndex = 7;
dataGridView1.Columns["vahedND"].HeaderText = "قیمت واحد نهایی دلاری";
dataGridView1.Columns["vahedND"].Width = 180;
dataGridView1.Columns["vahedND"].DisplayIndex = 8;
dataGridView1.Columns["vahedND"].DefaultCellStyle.BackColor = Color.Gray;
dataGridView1.Columns["vahedND"].DefaultCellStyle.ForeColor = Color.White;
dataGridView1.Columns["kollPR"].HeaderText = "کل پیش بینی ریالی";
dataGridView1.Columns["kollPR"].Width = 180;
dataGridView1.Columns["kollPR"].DisplayIndex = 9;
dataGridView1.Columns["kollNR"].HeaderText = "کل نهایی ریالی";
dataGridView1.Columns["kollNR"].Width = 180;
dataGridView1.Columns["kollNR"].DisplayIndex = 10;
dataGridView1.Columns["kollNR"].DefaultCellStyle.BackColor = Color.Gray;
dataGridView1.Columns["kollNR"].DefaultCellStyle.ForeColor = Color.White;
dataGridView1.Columns["kollPD"].HeaderText = "کل پیش بینی دلاری";
dataGridView1.Columns["kollPD"].Width = 180;
dataGridView1.Columns["kollPD"].DisplayIndex = 11;
dataGridView1.Columns["kollND"].HeaderText = "کل نهایی دلاری";
dataGridView1.Columns["kollND"].Width = 180;
dataGridView1.Columns["kollND"].DisplayIndex = 12;
dataGridView1.Columns["kollND"].DefaultCellStyle.BackColor = Color.Gray;
dataGridView1.Columns["kollND"].DefaultCellStyle.ForeColor = Color.White;
dataGridView1.Columns["shenasnameID"].Visible = false;
// dataGridView1.Columns["ID"].Visible = false;
dataGridView1.Columns[0].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[1].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[2].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[3].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[4].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[5].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[6].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[7].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[8].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[9].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[10].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[11].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[12].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[0].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[1].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[2].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[4].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[5].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[6].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[7].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[8].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[9].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[10].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[11].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[12].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.ColumnHeadersDefaultCellStyle.BackColor = Color.Gray;
dataGridView1.EnableHeadersVisualStyles = false;
dataGridView1.DefaultCellStyle.Font = GlobalVariable.headerlistFONTsmall;
dataGridView1.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
public checkList(DataTable dt1)
{
InitializeComponent();
FontClass fontclass = new FontClass();
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = mostaan.GlobalVariable.headerlistFONTsmall);
this.MaximizeBox = false;
this.CenterToScreen();
if (dt1.Columns.Count != 0)
{
dataGridView1.DataSource = dt1;
}
else
{
using (Context dbcontext = new Context())
{
var lst = (from p in dbcontext.checks
join b in dbcontext.banks on p.bankID equals b.ID
orderby p.ID descending
select new { ID = b.ID, checkNumber = p.checkNumber, banktitle = b.title, isused = p.isUsed, banknumber = b.number }
).ToList();
dataGridView1.DataSource = lst;
}
}
dataGridView1.Columns["ID"].HeaderText = "ردیف";
dataGridView1.Columns["ID"].Width = 120;
dataGridView1.Columns["ID"].DisplayIndex = 1;
dataGridView1.Columns["banktitle"].HeaderText = "نام بانک";
dataGridView1.Columns["banktitle"].Width = 200;
dataGridView1.Columns["banktitle"].DisplayIndex = 2;
dataGridView1.Columns["banktitle"].DefaultCellStyle.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns["banknumber"].HeaderText = "شماره حساب";
dataGridView1.Columns["banknumber"].Width = 200;
dataGridView1.Columns["banknumber"].DisplayIndex = 2;
dataGridView1.Columns["banknumber"].DefaultCellStyle.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns["checkNumber"].HeaderText = "شماره چک";
dataGridView1.Columns["checkNumber"].Width = 200;
dataGridView1.Columns["checkNumber"].DisplayIndex = 3;
dataGridView1.Columns["checkNumber"].DefaultCellStyle.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns["isUsed"].HeaderText = "استفاده شده";
dataGridView1.Columns["checkNumber"].Width = 200;
dataGridView1.Columns["checkNumber"].DisplayIndex = 3;
dataGridView1.Columns["checkNumber"].DefaultCellStyle.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[0].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[1].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[2].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[3].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[4].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
}
public Form2_shenasnameAdd()
{
string shenasnameID = GlobalVariable.shenasnameID;
Model.Context dbcontext = new Model.Context();
InitializeComponent();
FontClass fontclass = new FontClass();
List <Control> allControls = fontclass.GetAllControls(this);
allControls.ForEach(k => k.Font = mostaan.GlobalVariable.headerlistFONTsmall);
header.Font = mostaan.GlobalVariable.headerlistFONTBold;
//dateFrom.Font = GlobalVariable.headerlistFONTsupecSmall;
//dateTo.Font = GlobalVariable.headerlistFONTsupecSmall;
this.MaximizeBox = false;
this.CenterToScreen();
panel1.PanelElement.Shape = new RoundRectShape();
panel1.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
panel1.PanelElement.PanelFill.BackColor = Color.White;
panel2.PanelElement.Shape = new RoundRectShape();
panel2.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
panel2.PanelElement.PanelFill.BackColor = Color.White;
panel3.PanelElement.Shape = new RoundRectShape();
panel3.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
panel3.PanelElement.PanelFill.BackColor = Color.Violet;
radPanel10.PanelElement.Shape = new RoundRectShape();
radPanel10.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel10.PanelElement.PanelFill.BackColor = Color.White;
radPanel11.PanelElement.Shape = new RoundRectShape();
radPanel11.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel11.PanelElement.PanelFill.BackColor = Color.White;
//radPanel12.PanelElement.Shape = new RoundRectShape();
//radPanel12.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
//radPanel12.PanelElement.PanelFill.BackColor = Color.White;
radPanel13.PanelElement.Shape = new RoundRectShape();
radPanel13.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel13.PanelElement.PanelFill.BackColor = Color.White;
radPanel14.PanelElement.Shape = new RoundRectShape();
radPanel14.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel14.PanelElement.PanelFill.BackColor = Color.White;
radPanel16.PanelElement.Shape = new RoundRectShape();
radPanel16.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel16.PanelElement.PanelFill.BackColor = Color.Gray;
radPanel1.PanelElement.Shape = new RoundRectShape();
radPanel1.PanelElement.PanelFill.GradientStyle = GradientStyles.Solid;
radPanel1.PanelElement.PanelFill.BackColor = Color.Gray;
List <Model.markaz> bakhshlist = dbcontext.markazs.Where(x => x.master == "1").ToList();
List <Model.markaz> bakhshlist2 = dbcontext.markazs.Where(x => x.master == "1").ToList();
markazcombo.DataSource = bakhshlist;
markazcombo.DisplayMember = "title";
markazcombo.ValueMember = "parent";
dastgah.DataSource = bakhshlist2;
dastgah.DisplayMember = "title";
dastgah.ValueMember = "parent";
List <Model.user> userlist = dbcontext.users.ToList();
tarah.DataSource = userlist;
tarah.DisplayMember = "name";
tarah.ValueMember = "ID";
List <Model.shenasnameGam> lst = new List <Model.shenasnameGam>();
List <Model.shenasnameFounder> lstFounder = new List <Model.shenasnameFounder>();
if (shenasnameID != "")
{
Model.shenasname item = dbcontext.shenasnames.Where(x => x.ID == GlobalVariable.shenasnameID).FirstOrDefault();
List <string> taminIDKist = dbcontext.Archives.Where(x => x.hesab == "0").Select(x => x.shomareTamin).ToList();
List <Model.archive> arch = (from a in dbcontext.Archives
where a.project == shenasnameID && a.hesab == "1"
select a).ToList();
if (arch.Count() > 0)
{
startDate.Text = arch.First().tarikh.ToPersianDateString();
int pishbini = fns.IsDigitsOnly(item.datePishbini) == true?Int32.Parse(item.datePishbini) : 0;
endDate.Text = arch.First().tarikh.AddMonths(pishbini).ToPersianDateString();
}
List <Model.ejraeiat> PejraRially = dbcontext.ejraeiats.Where(x => x.shenasnameID == shenasnameID && x.riallyP != 0).ToList();
List <Model.ejraeiat> pejraDollary = dbcontext.ejraeiats.Where(x => x.shenasnameID == shenasnameID && x.dollaryP != 0).ToList();
prejraeeyat.Text = PejraRially.Count() > 0 ? string.Format("{0:n0}", PejraRially.Sum(x => x.riallyP)): "0";
pdejraiat.Text = pejraDollary.Count() > 0 ? string.Format("{0:n0}", pejraDollary.Sum(x => x.dollaryP)): "0";
List <Model.tamin> ejraRquery = dbcontext.tamins.Where(x => x.subject == "اجراییات" && x.type == "ریال" && x.hesab == "0" && x.project == shenasnameID && taminIDKist.Contains(x.shomareSanad)).ToList();
long ejraRially = ejraRquery != null?ejraRquery.ToList().Sum(x => x.mablagh) : 0;
List <Model.tamin> ejraDquery = dbcontext.tamins.Where(x => x.subject == "اجراییات" && x.type == "دلار" && x.hesab == "0" && x.project == shenasnameID && taminIDKist.Contains(x.shomareSanad)).ToList();
long ejrDorllay = ejraDquery != null?ejraDquery.ToList().Sum(x => x.mablagh) : 0;
hrejrayiat.Text = string.Format("{0:n0}", ejraRially.ToString());
hdejraeiat.Text = string.Format("{0:n0}", ejrDorllay.ToString());
List <Model.sarmaye> PsarRially = dbcontext.sarmayes.Where(x => x.shenasnameID == shenasnameID && x.kollPR != 0).ToList();
List <Model.sarmaye> PsarDollary = dbcontext.sarmayes.Where(x => x.shenasnameID == shenasnameID && x.kollPD != 0).ToList();
prsarmaye.Text = PsarRially.Count() > 0 ? string.Format("{0:n0}", PsarRially.Sum(x => x.kollPR)) : "0";
pdsarmaye.Text = PsarDollary.Count() > 0 ? string.Format("{0:n0}", PsarDollary.Sum(x => x.kollPD)) : "0";
List <Model.tamin> sarmaRquery = dbcontext.tamins.Where(x => x.subject == "سرمایه" && x.type == "ریال" && x.hesab == "0" && x.project == shenasnameID && taminIDKist.Contains(x.shomareSanad)).ToList();
List <Model.tamin> sarmaDquery = dbcontext.tamins.Where(x => x.subject == "سرمایه" && x.type == "دلار" && x.hesab == "0" && x.project == shenasnameID && taminIDKist.Contains(x.shomareSanad)).ToList();
long sarmRially = sarmaRquery != null?sarmaRquery.ToList().Sum(x => x.mablagh) : 0;
long sarmDorllay = sarmaDquery != null?sarmaDquery.ToList().Sum(x => x.mablagh) : 0;
hrsarmaye.Text = string.Format("{0:n0}", sarmRially.ToString());
hdsarmaye.Text = string.Format("{0:n0}", sarmDorllay.ToString());
List <Model.masrafi> PmasRially = dbcontext.masrafis.Where(x => x.shenasnameID == shenasnameID && x.kollPR != 0).ToList();
List <Model.masrafi> PmasDollary = dbcontext.masrafis.Where(x => x.shenasnameID == shenasnameID && x.kollPD != 0).ToList();
prmasrafi.Text = PmasRially.Count() > 0 ? string.Format("{0:n0}", PmasRially.Sum(x => x.kollPR)) : "0";
pdmasrafi.Text = PmasDollary.Count() > 0 ? string.Format("{0:n0}", PmasDollary.Sum(x => x.kollPD)) : "0";
List <Model.tamin> masrafiRquery = dbcontext.tamins.Where(x => x.subject == "مصرفی" && x.type == "ریال" && x.hesab == "0" && x.project == shenasnameID && taminIDKist.Contains(x.shomareSanad)).ToList();
List <Model.tamin> masrafiDquery = dbcontext.tamins.Where(x => x.subject == "مصرفی" && x.type == "دلار" && x.hesab == "0" && x.project == shenasnameID && taminIDKist.Contains(x.shomareSanad)).ToList();
long masrafRially = masrafiRquery != null?masrafiRquery.ToList().Sum(x => x.mablagh) : 0;
long masrafDorllay = masrafiDquery != null?masrafiDquery.ToList().Sum(x => x.mablagh) : 0;
hrmasrafi.Text = string.Format("{0:n0}", masrafRially.ToString());
hdmasrafi.Text = string.Format("{0:n0}", masrafDorllay.ToString());
List <Model.edari> PedaRially = dbcontext.edaris.Where(x => x.shenasnameID == shenasnameID && x.kollPR != 0).ToList();
List <Model.edari> PedaDollary = dbcontext.edaris.Where(x => x.shenasnameID == shenasnameID && x.kollPD != 0).ToList();
predari.Text = PedaRially.Count() > 0 ? string.Format("{0:n0}", PedaRially.Sum(x => x.kollPR)) : "0";
pdedari.Text = PedaDollary.Count() > 0 ? string.Format("{0:n0}", PedaDollary.Sum(x => x.kollPD)) : "0";
List <Model.tamin> edariRquery = dbcontext.tamins.Where(x => x.subject == "اداری" && x.type == "ریال" && x.hesab == "0" && x.project == shenasnameID && taminIDKist.Contains(x.shomareSanad)).ToList();
List <Model.tamin> edariDquery = dbcontext.tamins.Where(x => x.subject == "اداری" && x.type == "دلار" && x.hesab == "0" && x.project == shenasnameID && taminIDKist.Contains(x.shomareSanad)).ToList();
long edariRially = edariRquery != null?edariRquery.Sum(x => x.mablagh) : 0;
long edariDorllay = edariDquery != null?edariDquery.Sum(x => x.mablagh) : 0;
hredari.Text = string.Format("{0:n0}", edariRially.ToString());
hdedari.Text = string.Format("{0:n0}", edariDorllay.ToString());
List <Model.omrani> PomrRially = dbcontext.omranis.Where(x => x.shenasnameID == shenasnameID && x.kollPR != 0).ToList();
List <Model.omrani> PomrDollary = dbcontext.omranis.Where(x => x.shenasnameID == shenasnameID && x.kollPD != 0).ToList();
promrani.Text = PomrRially.Count() > 0 ? string.Format("{0:n0}", PomrRially.Sum(x => x.kollPR)) : "0";
pdomrani.Text = PomrDollary.Count() > 0 ? string.Format("{0:n0}", PomrDollary.Sum(x => x.kollPD)) : "0";
List <Model.tamin> omraniRquery = dbcontext.tamins.Where(x => x.subject == "عمرانی" && x.type == "ریال" && x.hesab == "0" && x.project == shenasnameID && taminIDKist.Contains(x.shomareSanad)).ToList();
List <Model.tamin> omraniDquery = dbcontext.tamins.Where(x => x.subject == "عمرانی" && x.type == "دلار" && x.hesab == "0" && x.project == shenasnameID && taminIDKist.Contains(x.shomareSanad)).ToList();
long omraniRially = omraniRquery != null?omraniRquery.Sum(x => x.mablagh) : 0;
long omraniDorllay = omraniDquery != null?omraniDquery.Sum(x => x.mablagh) : 0;
hromrani.Text = string.Format("{0:n0}", omraniRially.ToString());
hdomrani.Text = string.Format("{0:n0}", omraniDorllay.ToString());
List <Model.gharardad> PgharRially = dbcontext.gharardads.Where(x => x.shenasnameID == shenasnameID && x.kollPR != 0).ToList();
List <Model.gharardad> PgharDollary = dbcontext.gharardads.Where(x => x.shenasnameID == shenasnameID && x.kollPD != 0).ToList();
prgharardad.Text = PgharRially.Count() > 0 ? string.Format("{0:n0}", PgharRially.Sum(x => x.kollPR)) : "0";
pdgharardad.Text = PgharDollary.Count() > 0 ? string.Format("{0:n0}", PgharDollary.Sum(x => x.kollPD)) : "0";
List <Model.tamin> ghararRquery = dbcontext.tamins.Where(x => x.subject == "قرارداد" && x.type == "ریال" && x.hesab == "0" && x.project == shenasnameID && taminIDKist.Contains(x.shomareSanad)).ToList();
List <Model.tamin> ghararDquery = dbcontext.tamins.Where(x => x.subject == "قرارداد" && x.type == "دلار" && x.hesab == "0" && x.project == shenasnameID && taminIDKist.Contains(x.shomareSanad)).ToList();
long ghararRially = ghararRquery != null?ghararRquery.Sum(x => x.mablagh) : 0;
long ghararDorllay = ghararDquery != null?ghararDquery.Sum(x => x.mablagh) : 0;
hrgharardad.Text = string.Format("{0:n0}", ghararRially.ToString());
hdgharardad.Text = string.Format("{0:n0}", ghararDorllay.ToString());
List <Model.sayer> PsayerRially = dbcontext.sayers.Where(x => x.shenasnameID == shenasnameID && x.kollPR != 0).ToList();
List <Model.sayer> PsayerDollary = dbcontext.sayers.Where(x => x.shenasnameID == shenasnameID && x.kollPD != 0).ToList();
pravalie.Text = PsayerRially.Count() > 0 ? string.Format("{0:n0}", PsayerRially.Sum(x => x.kollPR)) : "0";
pdavalie.Text = PsayerDollary.Count() > 0 ? string.Format("{0:n0}", PsayerDollary.Sum(x => x.kollPD)) : "0";
List <Model.tamin> avalieRquery = dbcontext.tamins.Where(x => x.subject == "مواد" && x.type == "ریال" && x.hesab == "0" && x.project == shenasnameID && taminIDKist.Contains(x.shomareSanad)).ToList();
List <Model.tamin> avalieDquery = dbcontext.tamins.Where(x => x.subject == "مواد" && x.type == "دلار" && x.hesab == "0" && x.project == shenasnameID && taminIDKist.Contains(x.shomareSanad)).ToList();
long avalieRially = avalieRquery != null?avalieRquery.Sum(x => x.mablagh) : 0;
long avalieDorllay = avalieDquery != null?avalieDquery.Sum(x => x.mablagh) : 0;
hravalie.Text = string.Format("{0:n0}", avalieRially.ToString());
hdavalie.Text = string.Format("{0:n0}", avalieDorllay.ToString());
List <Model.tashvighi> PtashRially = dbcontext.tashvighis.Where(x => x.shenasnameID == shenasnameID && x.kollPR != 0).ToList();
List <Model.tashvighi> PtashDollary = dbcontext.tashvighis.Where(x => x.shenasnameID == shenasnameID && x.kollPD != 0).ToList();
prtashvighi.Text = PtashRially.Count() > 0 ? string.Format("{0:n0}", PtashRially.Sum(x => x.kollPR)) : "0";
pdtashvighi.Text = PtashDollary.Count() > 0 ? string.Format("{0:n0}", PtashDollary.Sum(x => x.kollPD)) : "0";
List <Model.tamin> tashvighiRquery = dbcontext.tamins.Where(x => x.subject == "تشویقی" && x.type == "ریال" && x.hesab == "0" && x.project == shenasnameID && taminIDKist.Contains(x.shomareSanad)).ToList();
List <Model.tamin> tashvighiDquery = dbcontext.tamins.Where(x => x.subject == "تشویقی" && x.type == "دلار" && x.hesab == "0" && x.project == shenasnameID && taminIDKist.Contains(x.shomareSanad)).ToList();
long tashvighiRially = tashvighiRquery != null?tashvighiRquery.Sum(x => x.mablagh) : 0;
long tashvighiDorllay = tashvighiDquery != null?tashvighiDquery.Sum(x => x.mablagh) : 0;
hrtashvighi.Text = string.Format("{0:n0}", tashvighiRially.ToString());
hdtashvighi.Text = string.Format("{0:n0}", tashvighiDorllay.ToString());
List <Model.tamin> sayerhazineRquery = dbcontext.tamins.Where(x => x.subject == "سایر هزینه ها" && x.type == "ریال" && x.hesab == "0" && x.project == shenasnameID && taminIDKist.Contains(x.shomareSanad)).ToList();
List <Model.tamin> sayerhazineDquery = dbcontext.tamins.Where(x => x.subject == "سایر هزینه ها" && x.type == "دلار" && x.hesab == "0" && x.project == shenasnameID && taminIDKist.Contains(x.shomareSanad)).ToList();
long sayerhazineRially = sayerhazineRquery != null?sayerhazineRquery.Sum(x => x.mablagh) : 0;
long sayerhazineDorllay = sayerhazineDquery != null?sayerhazineDquery.Sum(x => x.mablagh) : 0;
hrsayerhazine.Text = string.Format("{0:n0}", sayerhazineRially.ToString());
hdsayerhazine.Text = string.Format("{0:n0}", sayerhazineDorllay.ToString());
hrkoll.Text = string.Format("{0:n0}", (avalieRially + edariRially + ejraRially + ghararRially + masrafRially + omraniRially + sarmRially + sayerhazineRially + tashvighiRially).ToString());;
hdkoll.Text = string.Format("{0:n0}", (avalieDorllay + edariDorllay + ejrDorllay + ghararDorllay + masrafDorllay + omraniDorllay + sarmDorllay + sayerhazineDorllay + tashvighiDorllay).ToString());
prkoll.Text = string.Format("{0:n0}", (decimal.Parse(prejraeeyat.Text) + decimal.Parse(prsarmaye.Text) + decimal.Parse(predari.Text) + decimal.Parse(prmasrafi.Text) + decimal.Parse(promrani.Text) + decimal.Parse(pravalie.Text) + decimal.Parse(prtashvighi.Text)).ToString());
pdkoll.Text = string.Format("{0:n0}", (decimal.Parse(pdejraiat.Text) + decimal.Parse(pdsarmaye.Text) + decimal.Parse(pdedari.Text) + decimal.Parse(pdmasrafi.Text) + decimal.Parse(pdomrani.Text) + decimal.Parse(pdavalie.Text) + decimal.Parse(pdtashvighi.Text)).ToString());
lst = (from p in dbcontext.shenasnameGams where p.shenasnameID == shenasnameID select p).ToList();
dataGridView1.DataSource = lst;
lstFounder = (from p in dbcontext.shenasnameFounders where p.shenasnameID == shenasnameID select p).ToList();
//dataGridView2.DataSource = lstFounder;
hadaf.Text = item.hadaf;
title.Text = item.title;
datePishbini.Text = item.datePishbini;
//dateFrom.Text = item.dateFrom.ToShortDateString();
//dateTo.Text = item.dateTo.ToShortDateString();
if (item.markaz != null)
{
markazcombo.SelectedValue = item.markaz;
dastgah.SelectedValue = item.markaz;
}
if (item.tarah != null)
{
tarah.SelectedValue = item.tarah;
}
}
else
{
dataGridView1.DataSource = lst;
//dataGridView2.DataSource = lstFounder;
}
dataGridView1.Width = 1300;
dataGridView1.Columns[1].HeaderText = "گام های اصلی";
dataGridView1.Columns[1].Width = 200;
dataGridView1.Columns[2].HeaderText = "عنوان اصلی فعالیت";
dataGridView1.Columns[2].Width = 200;
dataGridView1.Columns[3].HeaderText = "شرح فعالیت اصلی در این گام";
dataGridView1.Columns[3].Width = 300;
dataGridView1.Columns[4].HeaderText = "مدت زمان تقریبی (ماه)";
dataGridView1.Columns[4].Width = 150;
dataGridView1.Columns[5].HeaderText = "درصد وزنی فعالیت";
dataGridView1.Columns[5].Width = 150;
dataGridView1.Columns[6].HeaderText = "دستاورد";
dataGridView1.Columns[6].Width = 300;
dataGridView1.Columns["shenasnameID"].Visible = false;
dataGridView1.Columns["ID"].Visible = false;
dataGridView1.Columns[6].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[1].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[2].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[3].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[4].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[5].HeaderCell.Style.Font = GlobalVariable.headerlistFONTsupecSmall;
dataGridView1.Columns[6].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[1].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[2].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[4].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[5].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.ColumnHeadersDefaultCellStyle.BackColor = Color.Gray;
dataGridView1.EnableHeadersVisualStyles = false;
dataGridView1.DefaultCellStyle.Font = GlobalVariable.headerlistFONTsmall;
dataGridView1.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
//Phazine.Text = String.Format("{0:n0}", pr) + " ریال و " + string.Format("{0:n0}", pd) + " دلار ";
//Nhazine.Text = string.Format("{0:n0}", nr) + " ریال و " + string.Format("{0:n0}", nd) + " دلار ";
}
