예제 #1
0
        public static void FreeDate()
        {
            var bank = new LinqDataContext();

            var query = from p in bank.sarbazs
                        //   where p.Id_Sarbaz == Id_sarbaz
                        select p;

            foreach (var items in query)
            {
                var x = items.مدت_كسر_خدمت_به_روز;
                var y = items.خدمت_قبلی_روز;
                var z = items.مدت_اضافه_خدمت_روز;
                if (x == "" || x == null)
                {
                    x = "0";
                }
                if (y == "" || y == null)
                {
                    y = "0";
                }
                if (z == "" || z == null)
                {
                    z = "0";
                }
                int Day_variable = -Convert.ToInt32(x)
                                   - Convert.ToInt32(y)
                                   + Convert.ToInt32(z);
                PersianCalendar pcalender = new PersianCalendar();
                PersianDate     pDateObj  = new PersianDate();

                int year  = Convert.ToDateTime(items.تاریخ_اعزام).Year;
                int month = Convert.ToDateTime(items.تاریخ_اعزام).Month;
                int day   = Convert.ToDateTime(items.تاریخ_اعزام).Day;

                pDateObj.increasePersianMonth(ref year, ref month, 21);



                DateTime date = pcalender.ToDateTime(year,
                                                     month,
                                                     day, 0, 0, 0, 0, 0
                                                     );
                //  DateTime date_FreeDate = date.AddMonths(21);
                DateTime date_FreeDate1 = date.AddDays(Day_variable);
                items.تاریخ_ترخیص = pcalender.GetYear(date_FreeDate1) + "/" +
                                    pcalender.GetMonth(date_FreeDate1) + "/" +
                                    pcalender.GetDayOfMonth(date_FreeDate1);
            }
            //return date_FreeDate;
            bank.SubmitChanges();
        }
예제 #2
0
        private void FrmApply_S_Load(object sender, EventArgs e)
        {
            txt_JazbDate.Text = PersianDate.GetPersianDate();



            var bank  = new LinqDataContext();
            var query = (from p in bank.Gradetbls
                         orderby p.Id_Grade
                         select new { p.Id_Grade, p.Grade }).Distinct();

            comboBox_Grade.DataSource    = query;
            comboBox_Grade.DisplayMember = "Grade";
            comboBox_Grade.ValueMember   = "Id_Grade";

            var query1 = (from p in bank.Darajes
                          orderby p.ID
                          select new { p.ID, p.NameDaraje }).Distinct();

            comboBox_Darajeh.DataSource    = query1;
            comboBox_Darajeh.DisplayMember = "NameDaraje";
            comboBox_Darajeh.ValueMember   = "ID";
        }