Exemple #1
0
        public bool SaveConfigFile(Models.RegDataModel reg, string filePath)
        {
            bool result = false;

            try
            {
                //Registry.SetValue($@"HKEY_LOCAL_MACHINE\Software\BarayFormsCopier\", "Server1", reg.server1);
                //Registry.SetValue($@"HKEY_LOCAL_MACHINE\Software\BarayFormsCopier\", "DB1", reg.db1);
                //Registry.SetValue($@"HKEY_LOCAL_MACHINE\Software\BarayFormsCopier\", "Server2", reg.server2);
                //Registry.SetValue($@"HKEY_LOCAL_MACHINE\Software\BarayFormsCopier\", "DB2", reg.db2);

                if (File.Exists(filePath))
                {
                    File.Delete(filePath);
                }

                using (StreamWriter s = new StreamWriter(filePath))
                {
                    s.WriteLine(reg.Server1);
                    s.WriteLine(reg.Db1);
                    s.WriteLine(reg.Server2);
                    s.WriteLine(reg.Db2);
                    s.Close();
                }
                result = true;
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.Print("SetValues Error : " + ex.Message);
                result = false;
            }
            return(result);
        }
Exemple #2
0
        private void btnStart_Click(object sender, EventArgs e)
        {
            Func <object, int> CInt = (a) => { return(Convert.ToInt32(a)); };

            btnStart.Enabled = false;
            pb.Value         = 0;

            DialogResult mResult = 0;
            string       sResult = "";
            int          iResult = -1;
            var          opm     = new Models.OutputParamaterModel();

            // Saving Registry Values :
            var reg = new Models.RegDataModel(txtServer1.Text.Trim(), txtDB1.Text.Trim(), txtServer2.Text.Trim(), txtDB2.Text.Trim());

            using (var a = new FileAccess()) { a.SaveConfigFile(reg, configFilePath); };

            if (cmbFTID1.SelectedItem == null)
            {
                MessageBox.Show(Messages.cFormTypeNotSelected, Messages.cErr, MessageBoxButtons.OK, MessageBoxIcon.Warning);
                formState(true);
                return;
            }

            formState(false);

            //pb.Visible = true;
            lblWait.Visible = true;
            int ftId = -1;

            string[]    tName    = null;
            IList <int> ftIds    = new List <int>();
            int         newftId  = -1;
            IList <int> newftIds = new List <int>();

            string[] newtName = null;
            DateTime today    = System.DateTime.Today;
            string   pvToday  = "";

            // Fetching Data & Check Routines :
            using (DA d1 = new DA(txtServer1.Text.Trim(), txtDB1.Text.Trim()))
            {
                using (DA d2 = new DA(txtServer2.Text.Trim(), txtDB2.Text.Trim()))
                {
                    if (!d1.Connected())
                    {
                        MessageBox.Show(Messages.cDbConnFailed + " 1", Messages.cErr, MessageBoxButtons.OK, MessageBoxIcon.Stop);
                        formState(true);
                        return;
                    }
                    if (!d2.Connected())
                    {
                        MessageBox.Show(Messages.cDbConnFailed + " 2", Messages.cErr, MessageBoxButtons.OK, MessageBoxIcon.Stop);
                        formState(true);
                        return;
                    }

                    // Test SomeThing :
                    //var o = new List<Models.OutputParamaterModel>();
                    //sResult = (d1.ExecProcedure("spTestOutput", new string[] { "@ID", "@O" },
                    //    new object[] { -1, -1 },
                    //    new ParameterDirection[] { ParameterDirection.Input, ParameterDirection.InputOutput }, ref o) ?? "").ToString();
                    //

                    today   = (DateTime)d2.GetValueFromTable("GetDate()", "", "");
                    pvToday = d2.GetValueFromTable("dbo.GetParsDate(GetDate())", "", "").ToString();

                    ftId    = CInt(cmbFTID1.SelectedItem.ToString().Split('-')[0].Trim());
                    newftId = CInt(d2.GetValueFromTable("ID", "tblGreenFormTypeL", "ID = " + ftId.ToString(), false));

                    if (newftId > 0)
                    {
                        mResult = MessageBox.Show(Messages.cFormTypeExistsInDB2 + "\n\n" + Messages.cCreateNewFormTypeIDInDB2, Messages.cErr, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                        if (mResult == DialogResult.No)
                        {
                            MessageBox.Show(Messages.cRemoveCurrentFormTypeIDInDB2, Messages.cErr, MessageBoxButtons.OK, MessageBoxIcon.Stop);
                            formState(true);
                            return;
                        }
                    }

                    // Ask User To Continue :
                    mResult = MessageBox.Show(Messages.cFormCopyConfirmation, Messages.cErr, MessageBoxButtons.YesNo, MessageBoxIcon.Question); //, MessageBoxDefaultButton.Button1, MessageBoxOptions.RightAlign);
                    if (mResult == DialogResult.No)
                    {
                        formState(true);
                        return;
                    }

                    // Begin Copying New Form :
                    newftId = (int)d2.GetValueFromTable("IsNull(Max(ID), 0) + 1", "tblGreenFormTypeL", "");

                    // GreenFormTables :
                    tName    = d1.GetTablesNames(ftId).ToArray();
                    ftIds    = d1.GetFormTypeIDs(ftId).ToArray();
                    newtName = tName;

                    // Add New Tables To Target DB :
                    foreach (var item in tName)
                    {
                        string script = d1.GetTableScript(item);
                        sResult = d2.ExecSQL(script);

                        if (sResult != "")
                        {
                            MessageBox.Show(Messages.cErrorOccured + "\n\n" + sResult, Messages.cErr, MessageBoxButtons.OK, MessageBoxIcon.Error);
                            // Removing InComplete Added Objects :
                            foreach (var i in tName.Reverse <string>())
                            {
                                System.Diagnostics.Debug.Print(d2.RemoveObjectByName(i));
                            }
                            formState(true);
                            return;
                        }
                    }

                    // Executing spMGRUpdateGreenTables :
                    System.Diagnostics.Debug.Print((d2.ExecProcedure("spMGRUpdateGreenTables", new string[] { "@TableName", "@DROPPINGVIEW" }, new object[] { "", 0 }) ?? "").ToString());

                    List <Models.OutputParamaterModel> p = null;
                    foreach (var item in tName)
                    {
                        p       = new List <Models.OutputParamaterModel>();
                        sResult = (d2.ExecProcedure("spGreenFormBuilder", new string[] { "@TableName", "@CreatorID", "@CreateDate", "@PVCreateDate", "@FormTypeID" },
                                                    new object[] { item, 1, today, pvToday, -1 },
                                                    new ParameterDirection[] { ParameterDirection.Input, ParameterDirection.Input, ParameterDirection.Input, ParameterDirection.Input, ParameterDirection.InputOutput }, ref p) ?? "").ToString();

                        if (sResult == "")
                        {
                            opm = p.Where(x => x.ParamName == "@FormTypeID").FirstOrDefault <Models.OutputParamaterModel>();
                            //opm = (from x in p
                            //       where x.ParamName == "@FormTypeID"
                            //       select x).ToList<Models.OutputParamaterModel>().FirstOrDefault();

                            if (opm != null)
                            {
                                iResult = CInt(opm.ParamValue);
                                if (iResult <= 0)
                                {
                                    // Form Created...
                                    MessageBox.Show(iResult.ToString());
                                }
                                else
                                {
                                    // Add New Created FormTypeIDs To Collection...
                                    newftIds.Add(CInt(d2.GetValueFromTable("Max(ID)", "tblGreenFormTypeL", "")));
                                }
                            }
                        }
                        else
                        {
                            // Removing Added Tables :
                            foreach (var i in newftIds)
                            {
                                sResult = d2.GetValueFromTable("FormTypeID", "tblGreenFormTables", "").ToString();
                                System.Diagnostics.Debug.Print(d2.RemoveObjectByName(sResult));
                                System.Diagnostics.Debug.Print(d2.ExecProcedure("spMGRDeleteTableOfForm", new string[] { "@PrimaryTableName", "@FormID", "@Dropping" }, new object[] { sResult, i, 1 }).ToString());
                            }

                            formState(true);
                            MessageBox.Show(Messages.cErrorOccured + sResult, Messages.cErr, MessageBoxButtons.OK, MessageBoxIcon.Error);
                            return;
                        }
                    }

                    // Continue :


                    // Successful :
                    MessageBox.Show(Messages.cSuccessfull, "", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    formState(true);
                }
            }
        }