예제 #1
0
        public EquipSelectedScreen(SimulatorContext context, IList <PlayerCharacter> _list, BaseGoods goods) : base(context)
        {
            _goods    = goods;
            list      = _list;
            bg        = Context.Util.GetFrameBitmap(16 * 5 + 6, 6 + 16 * list.Count);
            itemsText = ExtensionFunction.DyadicArrayByte(list.Count, 11);//new byte[list.Count][11];

            for (int i = 0; i < itemsText.Length; i++)
            {
                itemsText[i] = new byte[11];
            }

            for (int i = 0; i < itemsText.Length; i++)
            {
                for (int j = 0; j < 10; j++)
                {
                    itemsText[i][j] = (byte)' ';
                }
                try
                {
                    byte[] tmp = list[i].Name.GetBytes();
                    Array.Copy(tmp, 0, itemsText[i], 0, tmp.Length);
                }
                catch (Exception ex)
                {
                    Debug.WriteLine(ex);
                }
            }
        }
예제 #2
0
        private void globalHelpEnactmentForm_Load(object sender, EventArgs e)
        {
            typeComboBox.DropDownStyle          = ComboBoxStyle.DropDownList;
            enactmentTextbox.SelectionAlignment = HorizontalAlignment.Center;
            if (this.Text == "ویرایش کمک جمعی با مصوبه")
            {
                this.BackColor = Color.Yellow; delButton.Visible = true;
                SqlConnection con = new SqlConnection(this.connection);
                con.Open();

                SqlCommand cmdget = new SqlCommand("select type, fee, packets, startdate, enactmentId, status, metric, description, subdate from GlobalHelps where id = @id;", con);
                cmdget.Parameters.AddWithValue("@id", this.id);
                using (SqlDataReader reader = cmdget.ExecuteReader())
                {
                    if (reader.Read())
                    {
                        this.type = typeComboBox.Text = reader.GetString(0);
                        this.fee  = feeNumericUpDown.Value = reader.GetDecimal(1);
                        startDateTimePickerX.SelectedDateInDateTime = Convert.ToDateTime(String.Format("{0}", reader["startdate"])).Date;
                        enactmentTextbox.Text     = ExtensionFunction.EnglishToPersian(reader.GetString(4));
                        this.packets              = reader.GetInt32(2);
                        packetNumericUpDown.Value = Convert.ToDecimal(this.packets);
                        this.status         = reader.GetString(5);
                        this.metric         = reader.GetDecimal(6);
                        explainTextBox.Text = String.Format("{0}", reader["description"]);
                        this.subdate        = Convert.ToDateTime(String.Format("{0}", reader["subdate"])).Date;
                    }
                }
                if (this.status != "تعریف شده")
                {
                    delButton.Enabled = startDateTimePickerX.Enabled = packetNumericUpDown.Enabled = feeNumericUpDown.Enabled = false;
                }
                con.Close();
            }
        }
예제 #3
0
        private void editMemeberButton_Click(object sender, EventArgs e)
        {
            string id;

            if (!editMemberTextbox.Text.Any(char.IsWhiteSpace) && editMemberTextbox.Text.All(char.IsDigit))
            {
                id = ExtensionFunction.PersianToEnglish(editMemberTextbox.Text);
                SqlConnection con = new SqlConnection(this.connection);
                con.Open();
                SqlCommand cmdcheck = new SqlCommand("select count(*) as existance from member where id = @id", con);
                cmdcheck.Parameters.AddWithValue("@id", id);
                int exist = 0;
                using (SqlDataReader reader = cmdcheck.ExecuteReader())
                {
                    if (reader.Read())
                    {
                        exist = int.Parse(String.Format("{0}", reader["existance"]));
                    }
                }
                con.Close();
                if (exist == 1)
                {
                    var newform = new editMemberForm2(id);
                    newform.ShowDialog(this);
                }
                else
                {
                    FMessegeBox.FarsiMessegeBox.Show("عضوی با این شماره ملی وجود ندارد!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
                }
            }
            else
            {
                FMessegeBox.FarsiMessegeBox.Show("!شماره ملی باید شامل اعداد و بدون هیچ فاصله‌ای باشد", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
            }
        }
예제 #4
0
        private void editHelperForm2_Load(object sender, EventArgs e)
        {
            idTextBox.SelectionAlignment      = HorizontalAlignment.Center;
            nameTextBox.SelectionAlignment    = HorizontalAlignment.Center;
            familyTextBox.SelectionAlignment  = HorizontalAlignment.Center;
            phoneTextBox.SelectionAlignment   = HorizontalAlignment.Center;
            addressTextBox.SelectionAlignment = HorizontalAlignment.Center;

            SqlConnection con = new SqlConnection(this.connection);

            con.Open();
            SqlCommand cmdget = new SqlCommand("select name, family, phone, address from helper where id = @id;", con);

            cmdget.Parameters.AddWithValue("@id", this.id);
            using (SqlDataReader reader = cmdget.ExecuteReader())
            {
                if (reader.Read())
                {
                    idTextBox.Text      = ExtensionFunction.EnglishToPersian(this.id);
                    nameTextBox.Text    = reader.GetString(0);
                    familyTextBox.Text  = reader.GetString(1);
                    phoneTextBox.Text   = ExtensionFunction.EnglishToPersian(reader.GetString(2));
                    addressTextBox.Text = ExtensionFunction.EnglishToPersian(reader.GetString(3));
                }
            }
            con.Close();
        }
예제 #5
0
        private void otherHelpIndivPresentForm_Load(object sender, EventArgs e)
        {
            idTextBox.SelectionAlignment  = HorizontalAlignment.Center;
            mIdTextbox.SelectionAlignment = HorizontalAlignment.Center;
            feeTextBox.SelectionAlignment = HorizontalAlignment.Center;
            idTextBox.Text = ExtensionFunction.EnglishToPersian(this.id);
            SqlConnection con = new SqlConnection(this.connection);

            con.Open();
            SqlCommand cmdget;

            if (this.Text == "ارائه کمک متفرقه فردی")
            {
                feeTextBox.Visible = label3.Visible = true;
                cmdget             = new SqlCommand("select mId, OtherHelpsIndiv.description, OtherHelpIndivReq.description, fee, cashtype from OtherHelpsIndiv, OtherHelpIndivReq where OtherHelpsIndiv.reqId = OtherHelpIndivReq.id and OtherHelpsIndiv.id = @id;", con);
                cmdget.Parameters.AddWithValue("@id", this.id);
                using (SqlDataReader reader = cmdget.ExecuteReader())
                {
                    if (reader.Read())
                    {
                        explainTextBox.Text = reader.GetString(2) + " " + reader.GetString(1);
                        this.mId            = reader.GetString(0); mIdTextbox.Text = ExtensionFunction.EnglishToPersian(this.mId);
                        feeTextBox.Text     = ExtensionFunction.EnglishToPersian(Convert.ToUInt64(reader.GetDecimal(3)).ToString());
                        this.fee            = reader.GetDecimal(3);
                        this.cashtype       = reader.GetString(4);
                    }
                }
            }
            else
            {
                this.BackColor = Color.Yellow;
                visitPreReceiptButton.Visible = delButton.Visible = true;
                receiptLabel.BackColor        = Color.YellowGreen;
                label22.Location              = new Point(label22.Location.X, label22.Location.Y - 12);
                receiptLabel.Location         = new Point(receiptLabel.Location.X, receiptLabel.Location.Y - 12);
                receiptAddFileButton.Location = new Point(receiptAddFileButton.Location.X, receiptAddFileButton.Location.Y - 12);
                feeTextBox.Visible            = label3.Visible = true;
                cmdget = new SqlCommand("select mId, OtherHelpsIndiv.description, OtherHelpIndivReq.description, presdescription, fee, cashtype, bankAccountName, bankAccountId from OtherHelpsIndiv, OtherHelpIndivReq where OtherHelpsIndiv.reqId = OtherHelpIndivReq.id and OtherHelpsIndiv.id = @id;", con);
                cmdget.Parameters.AddWithValue("@id", this.id);
                using (SqlDataReader reader = cmdget.ExecuteReader())
                {
                    if (reader.Read())
                    {
                        explainTextBox.Text           = reader.GetString(2) + " " + reader.GetString(1) + " " + reader.GetString(3); this.explain = reader.GetString(3);
                        this.mId                      = reader.GetString(0); mIdTextbox.Text = ExtensionFunction.EnglishToPersian(this.mId);
                        feeTextBox.Text               = ExtensionFunction.EnglishToPersian(Convert.ToUInt64(reader.GetDecimal(4)).ToString());
                        this.fee                      = reader.GetDecimal(4);
                        this.cashtype                 = reader.GetString(5);
                        this.prebId                   = reader.GetString(7);
                        bankAccountNumberTextBox.Text = ExtensionFunction.EnglishToPersian(this.prebId);
                        bankAccountNameComboBox.Text  = reader.GetString(6);
                    }
                }
            }
            if (cashtype == "غیرنقدی")
            {
                bankAccountNameComboBox.Enabled = false;
            }
            con.Close();
        }
예제 #6
0
        private void bankAccountEditForm2_Load(object sender, EventArgs e)
        {
            enactmentTextbox.SelectionAlignment            = HorizontalAlignment.Center;
            bankAccountNameTextBox.SelectionAlignment      = HorizontalAlignment.Center;
            bankAccountNumberTextBox.SelectionAlignment    = HorizontalAlignment.Center;
            bankNameTextBox.SelectionAlignment             = HorizontalAlignment.Center;
            bankAccountOwnerNameTextBox.SelectionAlignment = HorizontalAlignment.Center;
            SqlConnection con = new SqlConnection(this.connection);

            con.Open();
            SqlCommand cmdget = new SqlCommand("select name, bankName, ownerName from bankAccount where id = @id;", con);

            cmdget.Parameters.AddWithValue("@id", this.id);
            using (SqlDataReader reader = cmdget.ExecuteReader())
            {
                if (reader.Read())
                {
                    bankAccountNumberTextBox.Text    = ExtensionFunction.EnglishToPersian(this.id);
                    bankAccountNameTextBox.Text      = reader.GetString(0);
                    bankNameTextBox.Text             = reader.GetString(1);
                    bankAccountOwnerNameTextBox.Text = reader.GetString(2);
                }
            }
            con.Close();
        }
예제 #7
0
        private void addButton_Click(object sender, EventArgs e)
        {
            if (String.IsNullOrWhiteSpace(explainTextBox.Text))
            {
                explainTextBox.BackColor = Color.Tomato;
                FMessegeBox.FarsiMessegeBox.Show("توضیحات وارد نشده است!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
                return;
            }
            SqlConnection con = new SqlConnection(this.connection);

            con.Open();
            SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; insert into backAccountInfoHistory (id, name, bankName, ownerName, subdate, enactmentId, description) Values (@id, @name, @bname, @oname, @sdate, @eId, @des); delete from bankAccount where id = @id; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);

            cmd.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
            cmd.Parameters.AddWithValue("@name", bankAccountNameTextBox.Text);
            cmd.Parameters.AddWithValue("@bname", bankNameTextBox.Text);
            cmd.Parameters.AddWithValue("@oname", bankAccountOwnerNameTextBox.Text);
            cmd.Parameters.AddWithValue("@sdate", endDateTimePickerX.SelectedDateInDateTime.Date);
            cmd.Parameters.AddWithValue("@eId", ExtensionFunction.PersianToEnglish(enactmentTextbox.Text));
            cmd.Parameters.AddWithValue("@des", "(حذف حساب) " + explainTextBox.Text);
            cmd.ExecuteNonQuery();
            con.Close();
            FMessegeBox.FarsiMessegeBox.Show("حساب با موفقیت حذف شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
            this.Close();
        }
        /// <summary>
        /// 多人装备选择界面
        /// </summary>
        /// <param name="context"></param>
        /// <param name="characters">角色列表</param>
        /// <param name="goods">当前选择进行装备的装备</param>
        public MutilCharacterEquipScreen(SimulatorContext context, List <PlayerCharacter> characters, BaseGoods goods) : base(context)
        {
            //HACK 此处需要测试是否正常运行
            _characters = characters;
            _goods      = goods;

            _background = Context.Util.GetFrameBitmap(16 * 5 + 6, 6 + 16 * _characters.Count);
            _names      = ExtensionFunction.DyadicArrayByte(_characters.Count, 11);//new byte[list.Count][11];
            for (int i = 0; i < _names.Length; i++)
            {
                for (int j = 0; j < 10; j++)
                {
                    _names[i][j] = (byte)' ';
                }
                try
                {
                    byte[] tmp = _characters[i].Name.GetBytes();
                    Array.Copy(tmp, 0, _names[i], 0, tmp.Length);
                }
                catch (Exception ex)
                {
                    Debug.WriteLine(ex);
                }
            }
        }
예제 #9
0
 private void marryHelpReqForm_Load(object sender, EventArgs e)
 {
     idTextbox.SelectionAlignment = HorizontalAlignment.Center;
     if (this.Text == "ثبت درخواست کمک ازدواج")
     {
         idTextbox.Text = ExtensionFunction.EnglishToPersian(this.mId);
     }
     else
     {
         this.BackColor          = Color.Yellow; delButton.Visible = true;
         marryDocLabel.BackColor = reqLabel.BackColor = Color.YellowGreen;
         SqlConnection con = new SqlConnection(this.connection);
         con.Open();
         SqlCommand cmdget = new SqlCommand("select mId, reqdate, description from MarryHelpReq where id = @id;", con);
         cmdget.Parameters.AddWithValue("@id", this.id);
         using (SqlDataReader reader = cmdget.ExecuteReader())
         {
             if (reader.Read())
             {
                 idTextbox.Text = reader.GetString(0);
                 reqDateTimePickerX.SelectedDateInDateTime = Convert.ToDateTime(String.Format("{0}", reader["reqdate"])).Date;
                 explainTextBox.Text = reader.GetString(2);
             }
         }
         con.Close();
     }
 }
예제 #10
0
        private void comebackButton_Click(object sender, EventArgs e)
        {
            string id;

            id = ExtensionFunction.PersianToEnglish(comebackTextbox.Text);
            SqlCommand    cmdcheck;
            SqlConnection con = new SqlConnection(this.connection);

            con.Open();
            if (this.Text == "رجعت عضو")
            {
                cmdcheck = new SqlCommand("select count(*) as existance from abandoned where id = @id", con);
                cmdcheck.Parameters.AddWithValue("@id", id);
                int exist = 0;
                using (SqlDataReader reader = cmdcheck.ExecuteReader())
                {
                    if (reader.Read())
                    {
                        exist = int.Parse(String.Format("{0}", reader["existance"]));
                    }
                }
                con.Close();
                if (exist == 1)
                {
                    var newform = new comebackForm2(id);
                    newform.ShowDialog(this);
                }
                else
                {
                    FMessegeBox.FarsiMessegeBox.Show("!عضوی با این شماره ملی در لیست اعضای معلق وجود ندارد", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
                }
            }
            else
            {
                cmdcheck = new SqlCommand("select count(*) as existance from member, Inmember where member.id = Inmember.id and Inmember.kickdate is Null and member.id = @id", con);
                cmdcheck.Parameters.AddWithValue("@id", id);
                int exist = 0;
                using (SqlDataReader reader = cmdcheck.ExecuteReader())
                {
                    if (reader.Read())
                    {
                        exist = int.Parse(String.Format("{0}", reader["existance"]));
                    }
                }
                con.Close();
                if (exist == 1)
                {
                    var newform = new comebackForm2(id);
                    newform.ShowDialog(this);
                }
                else
                {
                    FMessegeBox.FarsiMessegeBox.Show("!عضوی با این شماره ملی در لیست اعضای رجعت یافته وجود ندارد", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
                }
            }
        }
예제 #11
0
        private void searchButton_Click(object sender, EventArgs e)
        {
            var newform = new searchForm("ویرایش اطلاعات مددکار");

            newform.ShowDialog(this);
            if (newform.Text.StartsWith("choose"))
            {
                idTextbox.Text = ExtensionFunction.EnglishToPersian(newform.Text.Substring(6));
            }
        }
예제 #12
0
        private void searchButton_Click(object sender, EventArgs e)
        {
            var newform = new searchEnactmentForm();

            newform.ShowDialog(this);
            if (newform.Text.StartsWith("choose"))
            {
                enactmentTextbox.Text = ExtensionFunction.EnglishToPersian(newform.Text.Substring(6));
            }
        }
예제 #13
0
        private void searchButton_Click(object sender, EventArgs e)
        {
            var newform = new searchEnactmentForm();

            newform.ShowDialog(this);
            if (newform.Text == "choose")
            {
                enactmentTextbox.Text = ExtensionFunction.EnglishToPersian(Clipboard.GetText());
            }
        }
예제 #14
0
        private void searchApplicantButton_Click(object sender, EventArgs e)
        {
            var newform = new searchForm("تقاضا جدید متقاضی");

            newform.ShowDialog(this);
            if (newform.Text.StartsWith("choose"))
            {
                idTextbox.Text = ExtensionFunction.EnglishToPersian(newform.Text.Substring(6));
                // ExtensionFunction.PersianToEnglish(idTextbox.Text);
            }
        }
예제 #15
0
        private void marrySendIntroForm_Load(object sender, EventArgs e)
        {
            idTextBox.SelectionAlignment = HorizontalAlignment.Center;
            idTextBox.Text = ExtensionFunction.EnglishToPersian(this.id);
            SqlConnection con = new SqlConnection(this.connection);
            SqlCommand    cmdget;

            con.Open();
            if (this.Text == "ارسال معرفی‌نامه جهیزیه")
            {
                cmdget = new SqlCommand("select reqId, MarryHelps.description, MarryHelps.enactmentId, MarryHelpReq.description from MarryHelps, MarryHelpReq where MarryHelps.reqId = MarryHelpReq.id and MarryHelps.id = @id;", con);
                cmdget.Parameters.AddWithValue("@id", this.id);
                using (SqlDataReader reader = cmdget.ExecuteReader())
                {
                    if (reader.Read())
                    {
                        this.rId            = reader.GetString(0);
                        explainTextBox.Text = reader.GetString(3) + " " + reader.GetString(1);
                        this.eId            = reader.GetString(2);
                    }
                }
            }
            else
            {
                this.BackColor              = Color.Yellow; delButton.Visible = visitPreIntroButton.Visible = true;
                introLabel.BackColor        = Color.YellowGreen;
                label22.Location            = new Point(label22.Location.X, label22.Location.Y - 12);
                introLabel.Location         = new Point(introLabel.Location.X, introLabel.Location.Y - 12);
                introAddFileButton.Location = new Point(introAddFileButton.Location.X, introAddFileButton.Location.Y - 12);
                cmdget = new SqlCommand("select reqId, MarryHelps.description, MarryHelps.enactmentId, MarryHelpReq.description, introdescription from MarryHelps, MarryHelpReq where MarryHelps.reqId = MarryHelpReq.id and MarryHelps.id = @id;", con);
                cmdget.Parameters.AddWithValue("@id", this.id);
                using (SqlDataReader reader = cmdget.ExecuteReader())
                {
                    if (reader.Read())
                    {
                        this.rId            = reader.GetString(0);
                        explainTextBox.Text = reader.GetString(3) + " " + reader.GetString(1) + " " + reader.GetString(4); this.explain = reader.GetString(4);
                        this.eId            = reader.GetString(2);
                    }
                }
            }

            cmdget = new SqlCommand("select docpath from enactment where id = @eId;", con);
            cmdget.Parameters.AddWithValue("@eId", this.eId);
            using (SqlDataReader reader = cmdget.ExecuteReader())
            {
                if (reader.Read())
                {
                    this.ePath = reader.GetString(0);
                }
            }
            con.Close();
        }
예제 #16
0
        public ActionResult EquipmentUserActivity(int id, string Puser, string statusvalue)
        {
            equipmetAcceptUser PEquipmentAccreptUser = new equipmetAcceptUser();

            PEquipmentAccreptUser.equipmentId    = id;
            PEquipmentAccreptUser.userName       = Puser;
            PEquipmentAccreptUser.statusSelected = statusvalue;
            PEquipmentAccreptUser.registerDate   = ExtensionFunction.ToPersian(DateTime.Now);
            Context.equipmetAcceptUsers.Add(PEquipmentAccreptUser);
            Context.SaveChanges();

            return(RedirectToAction("listEquipments"));
        }
예제 #17
0
        private void searchButton_Click(object sender, EventArgs e)
        {
            var newform = new searchEnactmentForm();

            newform.ShowDialog(this);
            if (newform.Text.StartsWith("choose"))
            {
                enactmentTextbox.Text = ExtensionFunction.EnglishToPersian(newform.Text.Substring(6));
            }
            if (this.Text == "ویرایش تایید معرفی‌نامه تحصیلی")
            {
                setButton.Enabled = true;
            }
        }
        private void exportButton_Click(object sender, EventArgs e)
        {
            // creating Excel Application
            Microsoft.Office.Interop.Excel._Application app = new Microsoft.Office.Interop.Excel.Application();
            // creating new WorkBook within Excel application
            Microsoft.Office.Interop.Excel._Workbook workbook = app.Workbooks.Add(Type.Missing);
            // creating new Excelsheet in workbook
            Microsoft.Office.Interop.Excel._Worksheet worksheet = null;

            // get the reference of first sheet. By default its name is Sheet1.
            // store its reference to worksheet
            worksheet = workbook.Sheets["Sheet1"];
            worksheet = workbook.ActiveSheet;

            // changing the name of active sheet
            //worksheet.Name = "Exported from gridview";
            worksheet.DisplayRightToLeft = true;
            DialogResult res = FMessegeBox.FarsiMessegeBox.Show("نسبت به گرفتن خروجی اکسل اطمینان دارید؟", "پرسش", FMessegeBox.FMessegeBoxButtons.YesNo, FMessegeBox.FMessegeBoxIcons.Question, FMessegeBox.FMessegeBoxDefaultButton.button1);

            if (res != DialogResult.Yes)
            {
                app.Quit();
                return;
            }
            for (int i = 1; i < membersView.Columns.Count + 1; i++)
            {
                worksheet.Cells[1, i] = membersView.Columns[i - 1].HeaderText;
            }
            // storing Each row and column value to excel sheet
            for (int i = 0; i < membersView.Rows.Count; i++)
            {
                for (int j = 0; j < membersView.Columns.Count; j++)
                {
                    if (membersView.Rows[i].Cells[j].Value.GetType().ToString() == "System.DateTime")
                    {
                        worksheet.Cells[i + 2, j + 1] = ExtensionFunction.ToPersian(Convert.ToDateTime(membersView.Rows[i].Cells[j].Value.ToString()));
                    }
                    else
                    {
                        worksheet.Cells[i + 2, j + 1] = membersView.Rows[i].Cells[j].Value.ToString();
                    }
                }
            }
            // see the excel sheet behind the program
            app.Visible = true;
            // save the application
            //workbook.SaveAs("c:\\output.xls", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
            // Exit from the application
            //app.Quit();
        }
예제 #19
0
        private void denyButton_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(this.connection);

            con.Open();
            SqlCommand cmd = new SqlCommand("update MarryHelpReq Set status = @rstat, enactmentId = @eId where id = @rId;", con);

            cmd.Parameters.AddWithValue("@rId", this.rId);
            cmd.Parameters.AddWithValue("@eId", ExtensionFunction.PersianToEnglish(enactmentTextbox.Text));
            cmd.Parameters.AddWithValue("@rstat", "رد شده");
            cmd.ExecuteNonQuery();
            con.Close();
            FMessegeBox.FarsiMessegeBox.Show("درخواست با موفقیت رد شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
            this.Close();
        }
예제 #20
0
        public ActionResult UserActivity(int id, string Puser, string statusvalue)
        {
            melkAcceptUser PmelkAccreptUser = new melkAcceptUser();

            PmelkAccreptUser.melkId         = id;
            PmelkAccreptUser.userName       = Puser;
            PmelkAccreptUser.statusSelected = statusvalue;
            PmelkAccreptUser.RegisterDate   = ExtensionFunction.ToPersian(DateTime.Now);
            Context.melkAcceptUsers.Add(PmelkAccreptUser);
            Context.SaveChanges();



            return(RedirectToAction("GetMelkInfo"));
        }
예제 #21
0
        public ActionResult JobUserActivity(int id, string Puser, string statusvalue)
        {
            jobAcceptUser PJobAccreptUser = new jobAcceptUser();

            PJobAccreptUser.jobId          = id;
            PJobAccreptUser.userName       = Puser;
            PJobAccreptUser.statusSelected = statusvalue;
            PJobAccreptUser.registerDate   = ExtensionFunction.ToPersian(DateTime.Now);
            Context.jobAcceptUsers.Add(PJobAccreptUser);
            Context.SaveChanges();



            return(RedirectToAction("listJobs"));
        }
예제 #22
0
        private void editBuyHelpsForm2_Load(object sender, EventArgs e)
        {
            typeComboBox.DropDownStyle                  = ComboBoxStyle.DropDownList;
            buyerNameTextBox.SelectionAlignment         = HorizontalAlignment.Center;
            bankAccountNumberTextBox.SelectionAlignment = HorizontalAlignment.Center;
            bankAccountNameComboBox.DropDownStyle       = ComboBoxStyle.DropDownList;
            enactmentTextbox.SelectionAlignment         = HorizontalAlignment.Center;
            SqlConnection con = new SqlConnection(this.connection);

            con.Open();
            SqlCommand cmdget = new SqlCommand("select id, name from bankAccount;", con);

            using (SqlDataReader reader = cmdget.ExecuteReader())
            {
                while (reader.Read())
                {
                    li.Add(new KeyValuePair <string, string>(reader.GetString(0), reader.GetString(1)));
                    bankAccountNameComboBox.Items.Add(reader.GetString(1));
                }
            }
            cmdget = new SqlCommand("select type, fee, packet, buyerName, buydate, bankAccountId ,bankAccountName, description from buyHelps where id = @id;", con);
            cmdget.Parameters.AddWithValue("@id", this.id);
            using (SqlDataReader reader = cmdget.ExecuteReader())
            {
                if (reader.Read())
                {
                    pretype     = typeComboBox.Text = reader.GetString(0);
                    this.preFee = feeNumericUpDown.Value = reader.GetDecimal(1);
                    packetNumericUpDown.Value = reader.GetInt32(2);
                    buyerNameTextBox.Text     = reader.GetString(3);
                    buyDateTimePickerX.SelectedDateInDateTime = Convert.ToDateTime(String.Format("{0}", reader["buydate"])).Date;
                    bankAccountNumberTextBox.Text             = ExtensionFunction.EnglishToPersian(reader.GetString(5));
                    this.prebId = reader.GetString(5);
                    bankAccountNameComboBox.Text = reader.GetString(6);
                    explainTextBox.Text          = reader.GetString(7);
                }
            }
            cmdget = new SqlCommand("select docpath from doc where id = @id;", con);
            cmdget.Parameters.AddWithValue("@id", this.id);
            using (SqlDataReader reader = cmdget.ExecuteReader())
            {
                if (reader.Read())
                {
                    preFile = reader.GetString(0);
                }
            }
            con.Close();
        }
예제 #23
0
        private void delButton_Click(object sender, EventArgs e)
        {
            DialogResult res = FMessegeBox.FarsiMessegeBox.Show("آیا نسیت به حذف ارائه این کمک اطمینان دارید؟", "پرسش", FMessegeBox.FMessegeBoxButtons.YesNo, FMessegeBox.FMessegeBoxIcons.Question, FMessegeBox.FMessegeBoxDefaultButton.button1);

            if (res != DialogResult.Yes)
            {
                return;
            }
            SqlConnection con = new SqlConnection(this.connection);

            con.Open();
            string dpath = System.IO.Directory.GetFiles(this.helpPath + "\\" + this.id + "\\receipt")[0];

            System.IO.File.Delete(dpath);
            if (cashtype == "نقدی")
            {
                decimal    stock  = 0;
                SqlCommand cmdget = new SqlCommand("select stock from bankAccount where id = @bId;", con);
                cmdget.Parameters.AddWithValue("@bId", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
                using (SqlDataReader reader = cmdget.ExecuteReader())
                {
                    if (reader.Read())
                    {
                        stock = reader.GetDecimal(0);
                    }
                }
                SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; update OtherHelpsIndiv Set presdescription = Null, enddate = Null, status = @stat where id = @bId; update bankAccount set stock = @st where id = @id; delete from doc where id = @id and doctype = @dtype; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
                cmd.Parameters.AddWithValue("@id", this.id);
                cmd.Parameters.AddWithValue("@stat", "ارائه");
                cmd.Parameters.AddWithValue("@bId", ExtensionFunction.PersianToEnglish(bankAccountNumberTextBox.Text));
                cmd.Parameters.AddWithValue("@st", stock + fee);
                cmd.Parameters.AddWithValue("@dtype", "OIhelp:receipt");
                cmd.ExecuteNonQuery();
            }
            else
            {
                SqlCommand cmd = new SqlCommand("BEGIN TRY begin tran t1; update OtherHelpsIndiv Set presdescription = Null, enddate = Null, status = @stat where id = @id; update bankAccount set stock = @st where id = @id; delete from doc where id = @id and doctype = @dtype; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
                cmd.Parameters.AddWithValue("@id", this.id);
                cmd.Parameters.AddWithValue("@stat", "ارائه");
                cmd.Parameters.AddWithValue("@dtype", "OIhelp:receipt");
                cmd.ExecuteNonQuery();
            }

            con.Close();
            FMessegeBox.FarsiMessegeBox.Show("ارائه کمک با موفقیت حذف شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
            this.Close();
        }
예제 #24
0
 private void searchButton_Click(object sender, EventArgs e)
 {
     if (this.Text == "بررسی تقاضا" || this.Text == "ویرایش تقاضا")
     {
         var newform = new searchForm("ویرایش تقاضا");
         newform.ShowDialog(this);
         if (newform.Text.StartsWith("choose"))
         {
             idTextbox.Text = ExtensionFunction.EnglishToPersian(newform.Text.Substring(6));;
         }
     }
     else if (this.Text == "ثبت ارائه معرفی‌نامه" || this.Text == "ویرایش بررسی")
     {
         searchForm newform;
         if (this.Text == "ویرایش بررسی")
         {
             newform = new searchForm("ویرایش بررسی");
         }
         else
         {
             newform = new searchForm("ثبت ارائه معرفی‌نامه");
         }
         newform.ShowDialog(this);
         if (newform.Text.StartsWith("choose"))
         {
             idTextbox.Text = ExtensionFunction.EnglishToPersian(newform.Text.Substring(6));;
         }
     }
     else if (this.Text == "ویرایش مصوبه")
     {
         var newform = new searchForm("ویرایش مصوبه");
         newform.ShowDialog(this);
         if (newform.Text.StartsWith("choose"))
         {
             idTextbox.Text = ExtensionFunction.EnglishToPersian(newform.Text.Substring(6));;
         }
     }
     else
     {
         var newform = new searchForm("ویرایش ارائه معرفی‌نامه");
         newform.ShowDialog(this);
         if (newform.Text.StartsWith("choose"))
         {
             idTextbox.Text = ExtensionFunction.EnglishToPersian(newform.Text.Substring(6));;
         }
     }
 }
예제 #25
0
 private void chooseButton_Click(object sender, EventArgs e)
 {
     if (membersView.Rows[membersView.SelectedCells[0].RowIndex].Cells[7].Value.ToString() == "نامشخص")
     {
         FMessegeBox.FarsiMessegeBox.Show("این تقاضا فایل یا اطلاعات بیشتری ندارد!", "توجه", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
     }
     else if(membersView.Rows[membersView.SelectedCells[0].RowIndex].Cells[6].Value.ToString() == "")
     {
         var newform = new observereqForm2_2(ExtensionFunction.PersianToEnglish(membersView.Rows[membersView.SelectedCells[0].RowIndex].Cells[membersView.SelectedCells[0].ColumnIndex].Value.ToString()));
         newform.ShowDialog(this);
     }
     else
     {
         var newform = new observereqForm3_2(ExtensionFunction.PersianToEnglish(membersView.Rows[membersView.SelectedCells[0].RowIndex].Cells[membersView.SelectedCells[0].ColumnIndex].Value.ToString()));
         newform.ShowDialog(this);
     }
 }
예제 #26
0
        private void setButton_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(this.connection);

            con.Open();
            SqlCommand cmdmember = new SqlCommand("select count(*) from member where id = @id and id = supporter_id;", con);

            cmdmember.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(idTextbox.Text));
            int c = 0;

            using (SqlDataReader reader = cmdmember.ExecuteReader())
            {
                if (reader.Read())
                {
                    c = reader.GetInt32(0);
                }
            }
            if (c != 0)
            {
                var newform = new newReqForm2(ExtensionFunction.PersianToEnglish(idTextbox.Text), "member");
                newform.ShowDialog(this);
            }
            else
            {
                SqlCommand cmdapplicant = new SqlCommand("select count(*) from otherApplicant where id = @id;", con);
                cmdapplicant.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(idTextbox.Text));
                c = 0;
                using (SqlDataReader reader = cmdapplicant.ExecuteReader())
                {
                    if (reader.Read())
                    {
                        c = reader.GetInt32(0);
                    }
                }
                if (c != 0)
                {
                    var newform = new newReqForm2(ExtensionFunction.PersianToEnglish(idTextbox.Text), "applicant");
                    newform.ShowDialog(this);
                }
                else
                {
                    FMessegeBox.FarsiMessegeBox.Show("شماره ملی عضو موجود نیست!", "خطا!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error, FMessegeBox.FMessegeBoxDefaultButton.button1);
                }
            }
            con.Close();
        }
예제 #27
0
        private void setButton_Click(object sender, EventArgs e)
        {
            DialogResult res = FMessegeBox.FarsiMessegeBox.Show("آیا نسبت به ثبت بودجه اطمینان دارید؟", "پرسش", FMessegeBox.FMessegeBoxButtons.YesNo, FMessegeBox.FMessegeBoxIcons.Question, FMessegeBox.FMessegeBoxDefaultButton.button1);

            if (res != DialogResult.Yes)
            {
                return;
            }
            SqlConnection con = new SqlConnection(this.connection);

            con.Open();
            SqlCommand cmdsavehistory = new SqlCommand("BEGIN TRY begin tran t1; insert into budgetsCurrenciesHistory select @y, * from budgetsCurrencies; update budgetsCurrencies set amount = 0 where typename like '%Consume'; commit tran t1; END TRY BEGIN CATCH ROLLBACK END CATCH", con);
            SqlCommand cmdgetbsid     = new SqlCommand("select max(id) from budgetsets;", con);
            string     bsid           = "1398";

            using (SqlDataReader reader = cmdgetbsid.ExecuteReader())
            {
                if (reader.Read())
                {
                    bsid = reader.GetString(0);
                }
            }
            cmdsavehistory.Parameters.AddWithValue("@y", bsid);
            cmdsavehistory.ExecuteNonQuery();
            string     d   = DateTime.Now.Date.ToPersian(); d = d.Substring(0, 4) + d.Substring(5, 2) + d.Substring(8, 2);
            SqlCommand cmd = new SqlCommand("insert into budgetsets (id, subdate, enactmentId) Values(@id, @sdate, @eId);", con);

            cmd.Parameters.AddWithValue("@id", "bs" + d);
            cmd.Parameters.AddWithValue("@sdate", DateTime.Now.Date);
            cmd.Parameters.AddWithValue("@eId", ExtensionFunction.PersianToEnglish(enactmentTextbox.Text));
            cmd.ExecuteNonQuery();
            NumericUpDown nu;

            foreach (var budget in budgets)
            {
                cmd = new SqlCommand("update budgetsCurrencies Set amount = @amount where typename = @tname;", con);
                nu  = (NumericUpDown)this.Controls.Find(budget + "NumericUpDown", true)[0];
                cmd.Parameters.AddWithValue("@amount", nu.Value);
                cmd.Parameters.AddWithValue("@tname", budget + "Budget");
                cmd.ExecuteNonQuery();
            }
            FMessegeBox.FarsiMessegeBox.Show("بودجه با موفقیت تعیین شد!", "تبریک!", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Information, FMessegeBox.FMessegeBoxDefaultButton.button1);
            con.Close();
            this.Close();
            con.Close();
        }
예제 #28
0
        private void searchButton_Click(object sender, EventArgs e)
        {
            searchForm newform;

            if (this.Text == "ویرایش متقاضی")
            {
                newform = new searchForm("متقاضی سایر");
            }
            else
            {
                newform = new searchForm("متقاضی");
            }
            newform.ShowDialog(this);
            if (newform.Text.StartsWith("choose"))
            {
                idTextbox.Text = ExtensionFunction.EnglishToPersian(newform.Text.Substring(6));;
            }
        }
        private void chooseButton_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(this.connection);

            con.Open();
            SqlCommand cmd = new SqlCommand("select docpath from enactment where id = @id;", con);

            cmd.Parameters.AddWithValue("@id", ExtensionFunction.PersianToEnglish(membersView.Rows[membersView.SelectedCells[0].RowIndex].Cells[membersView.SelectedCells[0].ColumnIndex + membersView.ColumnCount - 1].Value.ToString()));
            string p = "";

            using (SqlDataReader reader = cmd.ExecuteReader())
            {
                if (reader.Read())
                {
                    p = reader.GetString(0);
                }
            }
            con.Close();
            System.Diagnostics.Process.Start(p);
        }
 private void searchButton_Click(object sender, EventArgs e)
 {
     if (this.typ == "خانوار")
     {
         var newform = new searchForm("انتخاب خانوار");
         newform.ShowDialog(this);
         if (newform.Text.StartsWith("choose"))
         {
             idTextbox.Text = ExtensionFunction.EnglishToPersian(newform.Text.Substring(6));
         }
     }
     else
     {
         var newform = new searchForm("ویرایش عضو");
         newform.ShowDialog(this);
         if (newform.Text.StartsWith("choose"))
         {
             idTextbox.Text = ExtensionFunction.EnglishToPersian(newform.Text.Substring(6));
         }
     }
 }