コード例 #1
0
ファイル: Default.aspx.cs プロジェクト: programs4/CES
 protected void DListApplicationsFamilyPartnersTypes_SelectedIndexChanged(object sender, EventArgs e)
 {
     for (int i = 0; i < DListApplicationsFamilyPartnersTypes.Items.Count; i++)
     {
         if (PnlPersons.FindControl("Txt" + DListApplicationsFamilyPartnersTypes.Items[i].Value) == null)
         {
             if (DListApplicationsFamilyPartnersTypes.Items[i].Selected)
             {
                 GenerateControls(i);
             }
         }
     }
 }
コード例 #2
0
ファイル: Default.aspx.cs プロジェクト: programs4/CES
    protected void BtnSave_Click(object sender, EventArgs e)
    {
        if (!Validations())
        {
            return;
        }

        if (_ApplicationsFamilyID == 0)
        {
            _ApplicationsFamilyID = int.Parse(BtnSave.CommandArgument);
        }
        if (_ApplicationsID == 0)
        {
            _ApplicationsID = int.Parse(BtnSave.CommandName);
        }

        DALC.Transaction Transaction = new DALC.Transaction();
        var Dictionary = new Dictionary <string, object>()
        {
            { "ApplicationsID", _ApplicationsID },
            { "ApplicationsFamilyTypesID", int.Parse(DListApplicationsFamilyTypes.SelectedValue) },
            { "Address", TxtAddress.Text },
            { "ApplicationsFamilyStatusID", int.Parse(DListApplicationsFamilyStatus.SelectedValue) },
            { "Tour_Dt", TxtDate.Text.DateTimeFormat() },
            { "Description", TxtDescriptions.Text },
        };

        //Insert edek
        if (_ApplicationsFamilyID == 0)
        {
            Dictionary.Add("Add_Dt", DateTime.Now);
            Dictionary.Add("Add_Ip", Request.UserHostAddress.IPToInteger());
            _Result = DALC.InsertDatabase(Tools.Table.ApplicationsFamily, Dictionary, Transaction);
            if (_Result < 1)
            {
                Config.MsgBoxAjax(Config._DefaultErrorMessages);
                return;
            }
            _ApplicationsFamilyID = _Result;

            DataTable DtUsers = new DataTable();
            DtUsers.Columns.Add("ApplicationsFamilyID", typeof(int));
            DtUsers.Columns.Add("UsersID", typeof(int));
            DtUsers.Columns.Add("IsDeleted", typeof(bool));

            for (int i = 0; i < DListUsers.Items.Count; i++)
            {
                if (DListUsers.Items[i].Selected)
                {
                    DtUsers.Rows.Add(_ApplicationsFamilyID, DListUsers.Items[i].Value, false);
                }
            }

            _Result = DALC.InsertBulk(Tools.Table.ApplicationsFamilyUsers, DtUsers, Transaction);
            if (_Result < 1)
            {
                Config.MsgBoxAjax(Config._DefaultErrorMessages);
                return;
            }


            DataTable DtPartners = new DataTable();
            DtPartners.Columns.Add("ApplicationsFamilyID", typeof(int));
            DtPartners.Columns.Add("ApplicationsFamilyPartnersTypesID", typeof(int));
            DtPartners.Columns.Add("PersonsFullname", typeof(string));
            DtPartners.Columns.Add("IsDeleted", typeof(bool));

            for (int i = 0; i < DListApplicationsFamilyPartnersTypes.Items.Count; i++)
            {
                if (DListApplicationsFamilyPartnersTypes.Items[i].Selected)
                {
                    DtPartners.Rows.Add(_ApplicationsFamilyID, DListApplicationsFamilyPartnersTypes.Items[i].Value, ((TextBox)PnlPersons.FindControl(string.Format("Txt{0}", DListApplicationsFamilyPartnersTypes.Items[i].Value))).Text, false);
                }
            }

            if (DtPartners.Rows.Count > 0)
            {
                _Result = DALC.InsertBulk(Tools.Table.ApplicationsFamilyPartners, DtPartners, Transaction, true);
                if (_Result < 1)
                {
                    Config.MsgBoxAjax(Config._DefaultErrorMessages);
                    return;
                }
            }
            else
            {
                TarnsactionCommitOrRollback(Transaction, true);
            }
        }
        else
        {
            Dictionary.Add("WhereID", _ApplicationsFamilyID);
            _Result = DALC.UpdateDatabase(Tools.Table.ApplicationsFamily, Dictionary, Transaction);
            if (_Result < 1)
            {
                Config.MsgBoxAjax(Config._DefaultErrorMessages);
                return;
            }
            Dictionary.Clear();


            //Butun sitifadecileri IsDeleted true edek ki sonra olanlari false, olmayanlari insert edeceyik
            Dictionary.Add("ApplicationsFamilyID", _ApplicationsFamilyID);
            Dictionary.Add("IsDeleted", true);
            Dictionary.Add("WhereApplicationsFamilyID", _ApplicationsFamilyID);
            _Result = DALC.UpdateDatabase(Tools.Table.ApplicationsFamilyUsers, Dictionary);
            if (_Result < 1)
            {
                //Eger xeta bash verirse Transactionla emeliyyatlari geri qaytaraq
                TarnsactionCommitOrRollback(Transaction);
                Config.MsgBoxAjax(Config._DefaultErrorMessages);
                return;
            }

            bool   IsUpdate = false;
            string DataID   = DALC.GetSingleValues("CONCAT(CAST(UsersID as varchar),',')", Tools.Table.ApplicationsFamilyUsers, "ApplicationsFamilyID", _ApplicationsFamilyID, "for xml path('')");
            if (DataID == "-1")
            {
                //Eger xeta bash verirse Transactionla emeliyyatlari geri qaytaraq
                TarnsactionCommitOrRollback(Transaction);
                Config.MsgBoxAjax(Config._DefaultErrorMessages);
                return;
            }

            for (int i = 0; i < DListUsers.Items.Count; i++)
            {
                if (DListUsers.Items[i].Selected)
                {
                    Dictionary.Clear();
                    IsUpdate = (("," + DataID).IndexOf("," + DListUsers.Items[i].Value + ",") > -1);
                    Dictionary.Add("ApplicationsFamilyID", _ApplicationsFamilyID);
                    Dictionary.Add("UsersID", int.Parse(DListUsers.Items[i].Value));
                    Dictionary.Add("IsDeleted", false);
                    _Result = DALC.InsertOrUpdateApplicationsFamilyUsersOrPartners(Tools.Table.ApplicationsFamilyUsers, Dictionary, IsUpdate, Transaction);
                    if (_Result < 1)
                    {
                        Config.MsgBoxAjax(Config._DefaultErrorMessages);
                        return;
                    }
                }
            }

            //Butun ApplicationsFamilyPartners IsDeleted true edek ki sonra olanlari false, olmayanlari insert edeceyik
            Dictionary.Clear();
            Dictionary.Add("ApplicationsFamilyID", _ApplicationsFamilyID);
            Dictionary.Add("IsDeleted", true);
            Dictionary.Add("WhereApplicationsFamilyID", _ApplicationsFamilyID);
            _Result = DALC.UpdateDatabase(Tools.Table.ApplicationsFamilyPartners, Dictionary);
            if (_Result < 1)
            {
                //Eger xeta bash verirse Transactionla emeliyyatlari geri qaytaraq
                TarnsactionCommitOrRollback(Transaction);
                Config.MsgBoxAjax(Config._DefaultErrorMessages);
                return;
            }

            int ApplicationsFamilyPartnersTypesID = 0;
            DataID = DALC.GetSingleValues("CONCAT(CAST(ApplicationsFamilyPartnersTypesID as varchar),',')", Tools.Table.ApplicationsFamilyPartners, "ApplicationsFamilyID", _ApplicationsFamilyID, "for xml path('')");
            if (DataID == "-1")
            {
                //Eger Count alanda xeta bash verirse Transactionla emeliyyatlari geri qaytaraq
                Transaction.SqlTransaction.Rollback();
                Transaction.Com.Connection.Close();
                Transaction.Com.Connection.Dispose();
                Transaction.Com.Dispose();
                Config.MsgBoxAjax(Config._DefaultErrorMessages);
                return;
            }
            for (int i = 0; i < DListApplicationsFamilyPartnersTypes.Items.Count; i++)
            {
                if (DListApplicationsFamilyPartnersTypes.Items[i].Selected)
                {
                    Dictionary.Clear();
                    ApplicationsFamilyPartnersTypesID = int.Parse(DListApplicationsFamilyPartnersTypes.Items[i].Value);

                    IsUpdate = (("," + DataID).IndexOf("," + ApplicationsFamilyPartnersTypesID._ToString() + ",") > -1);
                    Dictionary.Add("ApplicationsFamilyID", _ApplicationsFamilyID);
                    Dictionary.Add("ApplicationsFamilyPartnersTypesID", ApplicationsFamilyPartnersTypesID);
                    Dictionary.Add("IsDeleted", false);
                    _Result = DALC.InsertOrUpdateApplicationsFamilyUsersOrPartners(Tools.Table.ApplicationsFamilyPartners, Dictionary, IsUpdate, Transaction);
                    if (_Result < 1)
                    {
                        Config.MsgBoxAjax(Config._DefaultErrorMessages);
                        return;
                    }

                    if (PnlPersons.FindControl(string.Format("Txt{0}", ApplicationsFamilyPartnersTypesID)) != null)
                    {
                        Dictionary.Clear();
                        Dictionary.Add("PersonsFullname", ((TextBox)PnlPersons.FindControl(string.Format("Txt{0}", ApplicationsFamilyPartnersTypesID))).Text);
                        Dictionary.Add("WhereApplicationsFamilyID", _ApplicationsFamilyID);
                        Dictionary.Add("WhereApplicationsFamilyPartnersTypesID", ApplicationsFamilyPartnersTypesID);
                        _Result = DALC.UpdateDatabase(Tools.Table.ApplicationsFamilyPartners, Dictionary, Transaction);
                        if (_Result < 1)
                        {
                            Config.MsgBoxAjax(Config._DefaultErrorMessages);
                            return;
                        }
                    }
                }
            }
            TarnsactionCommitOrRollback(Transaction, true);
        }

        Config.MsgBoxAjax(Config._DefaultSuccessMessages, Request.RawUrl);
    }
コード例 #3
0
ファイル: Default.aspx.cs プロジェクト: programs4/CES
    protected void LnkEdit_Click(object sender, EventArgs e)
    {
        ((Literal)Master.FindControl("LtrTitle")).Text = "Seçilmiş səfər üzərində düzəliş";
        if (sender != null)
        {
            BtnSave.CommandArgument = (sender as LinkButton).CommandArgument;
            BtnSave.CommandName     = (sender as LinkButton).CommandName;
            _ApplicationsFamilyID   = int.Parse(BtnSave.CommandArgument);
        }

        //ApplicationsFamily ID ye gore melulatlari getirek
        DataTable Dt = DALC.GetApplicationsFamilyByID(_ApplicationsFamilyID);

        if (Dt == null || Dt.Rows.Count < 1)
        {
            Config.MsgBoxAjax(Config._DefaultErrorMessages);
            return;
        }

        DListApplicationsFamilyTypes.SelectedValue = Dt._Rows("ApplicationsFamilyTypesID");
        TxtAddress.Text = Dt._Rows("Address");
        DListApplicationsFamilyStatus.SelectedValue = Dt._Rows("ApplicationsFamilyStatusID");
        TxtDate.Text         = ((DateTime)Dt._RowsObject("Tour_Dt")).ToString("dd.MM.yyy");
        TxtDescriptions.Text = Dt._Rows("Description");

        //ApplicationsFamilyUsers-den ApplicationsFamilyID ye gore  melumatlari getirek
        DataTable DtApplicationsFamilyUsers = DALC.GetApplicationsFamilyUsers(_ApplicationsFamilyID);

        if (DtApplicationsFamilyUsers == null || DtApplicationsFamilyUsers.Rows.Count < 1)
        {
            Config.MsgBoxAjax(Config._DefaultErrorMessages);
            return;
        }

        //ApplicationsFamilyPartners-den ApplicationsFamilyID-ye gore  melumatlari getirek
        DataTable DtApplicationsFamilyPartners = DALC.GetApplicationsFamilyPartners(_ApplicationsFamilyID);

        if (DtApplicationsFamilyPartners == null || DtApplicationsFamilyPartners.Rows.Count < 1)
        {
            Config.MsgBoxAjax(Config._DefaultErrorMessages);
            return;
        }

        //ApplicationsFamilyUsers-den gelen melumatlara gore forla listbox-da secek
        foreach (DataRow Dr in DtApplicationsFamilyUsers.Rows)
        {
            for (int i = 0; i < DListUsers.Items.Count; i++)
            {
                if (!DListUsers.Items[i].Selected)
                {
                    DListUsers.Items[i].Selected = (DListUsers.Items[i].Value == Dr["UsersID"]._ToString());
                }
            }
        }

        //ApplicationsFamilyPartners-den gelen melumatlara gore forla listbox-da secek ve control generate edek
        foreach (DataRow Dr in DtApplicationsFamilyPartners.Rows)
        {
            for (int i = 0; i < DListApplicationsFamilyPartnersTypes.Items.Count; i++)
            {
                if (!DListApplicationsFamilyPartnersTypes.Items[i].Selected)
                {
                    if (DListApplicationsFamilyPartnersTypes.Items[i].Value == Dr["ApplicationsFamilyPartnersTypesID"]._ToString())
                    {
                        DListApplicationsFamilyPartnersTypes.Items[i].Selected = true;
                        GenerateControls(i);
                        ((TextBox)PnlPersons.FindControl("Txt" + Dr["ApplicationsFamilyPartnersTypesID"])).Text = Dr["PersonsFullname"]._ToString();
                    }
                }
            }
        }

        MultiView1.ActiveViewIndex = 0;
    }