Пример #1
0
        /// <summary>
        /// Process Makkebun & Lawatan
        /// </summary>
        public static void SyncToServerForMakKebun()
        {
            IAppInfoRepo    AppInfoRepo    = new AppInfoRepo();
            IMakkebunRepo   MakkebunRepo   = new MakkebunRepo();
            ISemakTapakRepo SemakTapakRepo = new SemakTapakRepo();

            IList <makkebun> lstMakKebun = MakkebunRepo.GetAllToSync();

            for (int i = 0; i < lstMakKebun.Count; i++)
            {
                makkebun makkebunsqlite = lstMakKebun[i];
                using (IDbTransaction sqlTrans = MakkebunRepo.MySQLBeginTransaction())
                {
                    // INSERT MAKKEBUN TO MYSQL
                    int iSaveMakkebun = MakkebunRepo.CreateMySQL(makkebunsqlite, sqlTrans);
                    if (iSaveMakkebun > 0)
                    {
                        makkebun lastmakkebun = MakkebunRepo.GetLastMakkebunBy(makkebunsqlite.appinfo_id);
                        makkebunsqlite.newid_makkebun = lastmakkebun.id_makkebun;
                        makkebunsqlite.syncdate       = DateTime.Now;
                        // UPDATE MAKKEBUN SQLITE
                        MakkebunRepo.UpdateSync(makkebunsqlite);

                        // GET LAWATAN SQLITE DATA
                        semak_tapak semak_tapakSqlite = SemakTapakRepo.GetBy(makkebunsqlite.appinfo_id, makkebunsqlite.id_makkebun);
                        semak_tapakSqlite.newmakkebun_id = makkebunsqlite.newid_makkebun;

                        // INSERT LAWATAN TO MYSQL
                        int iSaveSemakTapak = SemakTapakRepo.CreateMySQL(semak_tapakSqlite, sqlTrans);
                        if (iSaveSemakTapak > 0)
                        {
                            semak_tapak lastsemak_tapak = SemakTapakRepo.GetLastSemakTapakBy(makkebunsqlite.appinfo_id, semak_tapakSqlite.newmakkebun_id);
                            semak_tapakSqlite.newid    = lastsemak_tapak.id;
                            semak_tapakSqlite.syncdate = DateTime.Now;
                            // UPDATE MAKKEBUN SQLITE
                            int iSemakTapakUpdateSync = SemakTapakRepo.UpdateSync(semak_tapakSqlite);
                        }
                    }
                    sqlTrans.Commit();
                }
                AppInfoRepo.CloseMySQLDB();
            }
        }
Пример #2
0
        private void SetupFormMakKebun(int appinfo_id, int id_makkebun)
        {
            this.appinfo_id  = appinfo_id;
            this.id_makkebun = id_makkebun;
            makkebun makkebun = MakkebunRepo.GetBy(id_makkebun);

            txtaddr1.Text      = makkebun.addr1;
            txtaddr2.Text      = makkebun.addr2;
            txtaddr3.Text      = makkebun.addr3;
            txtcatatan.Text    = makkebun.catatan;
            txtluaslesen.Text  = makkebun.luaslesen.ToString("#.##");
            txtluasmatang.Text = makkebun.luasmatang.ToString("#.##");
            txtnolesen.Text    = makkebun.nolesen;
            txtnolot.Text      = makkebun.nolot;
            if (makkebun.tebang == "SUDAH")
            {
                rbSudah.Checked = true;
                DateTime dttarikhtebang = DateTime.ParseExact(makkebun.tarikhtebang, "dd-MM-yyyy", CultureInfo.InvariantCulture);
                txttarikhtebang.Text  = dttarikhtebang.ToString();
                txttarikhtebang.Value = dttarikhtebang;
            }
            else if (makkebun.tebang == "BELUM")
            {
                rbBelum.Checked = true;
            }
            else
            {
                rbBelum.Checked = false;
                rbSudah.Checked = false;
            }

            cbnegeri.SelectedValue             = makkebun.negeri;
            cbdaerah.SelectedValue             = makkebun.daerah;
            cbdun.SelectedValue                = makkebun.dun;
            cbparlimen.SelectedValue           = makkebun.parlimen;
            cbsyarattanah.SelectedValue        = makkebun.syarattanah;
            cbjenishakmiliktanah.SelectedValue = makkebun.hakmiliktanah;
            cbpemilikan.SelectedValue          = makkebun.pemilikan;
            cbpengurusan.SelectedValue         = makkebun.pengurusan;
            cbtncr.SelectedValue               = makkebun.tncr;
        }
Пример #3
0
        /// <summary>
        /// Process Normal
        /// </summary>
        public static void SyncToServer()
        {
            try
            {
                IAppInfoRepo AppInfoRepo = new AppInfoRepo();
                AppInfoRepo.ResetMySQLConnection(true);
                IMakkebunRepo   MakkebunRepo   = new MakkebunRepo();
                ISemakTapakRepo SemakTapakRepo = new SemakTapakRepo();

                IList <appinfo> lstAppInfoToSync = AppInfoRepo.GetAllWithoutSync();
                for (int i = 0; i < lstAppInfoToSync.Count; i++)
                {
                    appinfo appinfoSqlite = lstAppInfoToSync[i];
                    AppInfoRepo.OpenMySQLDB();
                    WriteLog("MySQLBeginTransaction");
                    using (IDbTransaction sqlTrans = AppInfoRepo.MySQLBeginTransaction())
                    {
                        string newrefno = GenerateRefNo(appinfoSqlite.negeri, null);
                        appinfoSqlite.newrefno = newrefno;
                        // Insert To MySQL Server - AppInfo
                        WriteLog("AppInfoRepo.CreateMySQL");
                        try
                        {
                            if (AppInfoRepo.CreateMySQL(appinfoSqlite, sqlTrans) > 0)
                            {
                                // Update data local sqlite
                                appinfoSqlite.syncdate = DateTime.Now;
                                AppInfoRepo.UpdateSync(appinfoSqlite);
                                WriteLog(string.Format("AppInfoRepo.CreateMySQL & Update SQLite - {0} - {1} - {2}", appinfoSqlite.id, appinfoSqlite.refno_new, appinfoSqlite.newrefno));

                                IList <makkebun> lstMakkebunSqlite = MakkebunRepo.GetAllByAppInfo(appinfoSqlite.id);
                                for (int j = 0; j < lstMakkebunSqlite.Count; j++)
                                {
                                    makkebun makkebunSqlite = lstMakkebunSqlite[j];
                                    // INSERT MAKKEBUN TO MYSQL
                                    WriteLog("MakkebunRepo.CreateMySQL");
                                    try
                                    {
                                        int iSaveMakkebun = MakkebunRepo.CreateMySQL(makkebunSqlite, sqlTrans);
                                        if (iSaveMakkebun > 0)
                                        {
                                            makkebun lastmakkebun = MakkebunRepo.GetLastMakkebunBy(appinfoSqlite.id);
                                            makkebunSqlite.newid_makkebun = lastmakkebun.id_makkebun;
                                            makkebunSqlite.syncdate       = DateTime.Now;
                                            // UPDATE MAKKEBUN SQLITE

                                            MakkebunRepo.UpdateSync(makkebunSqlite);
                                            WriteLog(string.Format("MakkebunRepo.CreateMySQL & Update SQLite - {0} - {1} - {2}", appinfoSqlite.id, makkebunSqlite.id_makkebun, makkebunSqlite.newid_makkebun));

                                            // GET LAWATAN SQLITE DATA
                                            semak_tapak semak_tapakSqlite = SemakTapakRepo.GetBy(appinfoSqlite.id, makkebunSqlite.id_makkebun);
                                            if (semak_tapakSqlite != null)
                                            {
                                                semak_tapakSqlite.newmakkebun_id = makkebunSqlite.newid_makkebun;
                                                // INSERT LAWATAN TO MYSQL
                                                WriteLog("SemakTapakRepo.CreateMySQL");
                                                try
                                                {
                                                    int iSaveSemakTapak = SemakTapakRepo.CreateMySQL(semak_tapakSqlite, sqlTrans);
                                                    if (iSaveSemakTapak > 0)
                                                    {
                                                        semak_tapak lastsemak_tapak = SemakTapakRepo.GetLastSemakTapakBy(appinfoSqlite.id, semak_tapakSqlite.newmakkebun_id);
                                                        semak_tapakSqlite.newid    = lastsemak_tapak.id;
                                                        semak_tapakSqlite.syncdate = DateTime.Now;
                                                        // UPDATE MAKKEBUN SQLITE
                                                        int iSemakTapakUpdateSync = SemakTapakRepo.UpdateSync(semak_tapakSqlite);
                                                        WriteLog(string.Format("SemakTapakRepo.CreateMySQL & Update SQLite - {0} - {1} - {2}", appinfoSqlite.id, semak_tapakSqlite.id, semak_tapakSqlite.newid));
                                                    }
                                                }
                                                catch (Exception ex)
                                                {
                                                    WriteLog(string.Format("ERROR-SemakTapakRepo.CreateMySQL-{0}", ex.GetFullMessage()));
                                                }
                                            }
                                            else
                                            {
                                                WriteLog(string.Format("Maklumat Kebun Belum Lawat - {0}", makkebunSqlite.id_makkebun));
                                            }
                                        }
                                    }
                                    catch (Exception ex)
                                    {
                                        WriteLog(string.Format("ERROR-MakkebunRepo.CreateMySQL-{0}", ex.GetFullMessage()));
                                    }
                                }
                            }
                        }
                        catch (Exception ex)
                        {
                            WriteLog(string.Format("ERROR-AppInfoRepo.CreateMySQL-appinfo:{0}-refno_new:{1}-MESSAGE:{2}", appinfoSqlite.id, appinfoSqlite.refno_new, ex.GetFullMessage()));
                        }

                        sqlTrans.Commit();
                    }
                    AppInfoRepo.CloseMySQLDB();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.GetFullMessage());
            }
        }
Пример #4
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                if (appinfo_id <= 0)
                {
                    MessageBox.Show("Harap masukan data dari Maklumat Pemohon.");
                    return;
                }

                IList <Control> lstCtrlEmptyCheck = new List <Control>();
                lstCtrlEmptyCheck.Add(txtaddr1);
                lstCtrlEmptyCheck.Add(txtaddr2);
                lstCtrlEmptyCheck.Add(cbnegeri);
                //lstCtrlEmptyCheck.Add(cbdaerah);
                //lstCtrlEmptyCheck.Add(cbdun);
                //lstCtrlEmptyCheck.Add(cbparlimen);
                lstCtrlEmptyCheck.Add(txtnolot);
                lstCtrlEmptyCheck.Add(txtluasmatang);
                lstCtrlEmptyCheck.Add(cbsyarattanah);
                lstCtrlEmptyCheck.Add(txtnolesen);
                lstCtrlEmptyCheck.Add(cbjenishakmiliktanah);
                lstCtrlEmptyCheck.Add(cbpengurusan);
                lstCtrlEmptyCheck.Add(cbpemilikan);

                if (WFUtils.CheckControllCollectionEmpty(lstCtrlEmptyCheck))
                {
                    return;
                }

                bool     IsNew    = false;
                makkebun makkebun = MakkebunRepo.GetBy(id_makkebun);
                if (makkebun == null)
                {
                    makkebun = new makkebun();
                    IsNew    = true;
                }
                makkebun.appinfo_id    = appinfo_id;
                makkebun.addr1         = txtaddr1.Text;
                makkebun.addr2         = txtaddr2.Text;
                makkebun.addr3         = txtaddr3.Text;
                makkebun.catatan       = txtcatatan.Text;
                makkebun.luaslesen     = Convert.ToDouble(string.IsNullOrEmpty(txtluaslesen.Text) ? 0 : Convert.ToDouble(txtluaslesen.Text));
                makkebun.luasmatang    = Convert.ToDouble(txtluasmatang.Text);
                makkebun.nolesen       = txtnolesen.Text;
                makkebun.nolot         = txtnolot.Text;
                makkebun.tarikhtebang  = txttarikhtebang.Text;
                makkebun.negeri        = cbnegeri.SelectedValue.ToString();
                makkebun.daerah        = cbdaerah.SelectedValue == null ? "" : cbdaerah.SelectedValue.ToString();
                makkebun.dun           = cbdun.SelectedValue == null ? "" : cbdun.SelectedValue.ToString();
                makkebun.parlimen      = ParlimenRepo.GetParlimenIDBy(cbparlimen.SelectedValue.ToString());
                makkebun.syarattanah   = cbsyarattanah.SelectedValue.ToString();
                makkebun.hakmiliktanah = cbjenishakmiliktanah.SelectedValue.ToString();
                makkebun.pemilikan     = cbpemilikan.SelectedValue.ToString();
                makkebun.pengurusan    = cbpengurusan.SelectedValue.ToString();
                makkebun.tncr          = cbtncr.SelectedValue.ToString();
                makkebun.tebang        = rbSudah.Checked ? "SUDAH" : rbBelum.Checked ? "BELUM" : "";


                if (IsNew)
                {
                    try
                    {
                        makkebun.created   = DateTime.Now;
                        makkebun.createdby = VariableSettingRepo.GetBy("UserKeyIn").Value;
                        MakkebunRepo.Create(makkebun);
                        MessageBox.Show("Data berhasil disimpan [" + refno_new + " | " + txtnolot.Text + "]");
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.GetFullMessage());
                    }
                }
                else
                {
                    try
                    {
                        MakkebunRepo.Edit(makkebun);
                        MessageBox.Show("Data berhasil disimpan [" + refno_new + " | " + txtnolot.Text + "]");
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.GetFullMessage());
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.GetFullMessage() + " - Harap periksa data input kembali");
                return;
            }
            BindGrid(page);

            btnReset.PerformClick();
        }