private void menuItemResetUsers_Click(object sender, EventArgs e) { FGSyncService client = new FGSyncService(); DBClass db = new DBClass(); List <UserInfo> users = new List <UserInfo>(); try { panelWait.Visible = true; DialogResult dialogRes = MessageBox.Show("Do you want to reset User Records on this device?", "Reset Users [" + AppVariables.DeviceName + "]", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1); if (dialogRes == DialogResult.Yes) { List <UserData> data = client.GetUserData().ToList(); foreach (UserData oneRec in data) { users.Add(new UserInfo() { UserName = oneRec.UserName, Password = oneRec.Password, Role = oneRec.UserType }); } client.Dispose(); db.InsertBulkUsers(users); MessageBox.Show("Bulk user have been reset successfully.", "Reset Users [" + AppVariables.DeviceName + "]", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1); } } catch (Exception exp) { MessageBox.Show(exp.Message); } finally { panelWait.Visible = false; } }
private void menuItemResetData_Click(object sender, EventArgs e) { string msg = string.Empty; this.Refresh(); this.SuspendLayout(); panelWait.Visible = true; this.ResumeLayout(); try { DialogResult dialogRes = MessageBox.Show("Do you want to reset the Data on this device?", "Reset Data [" + AppVariables.DeviceName + "]", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1); if (dialogRes == DialogResult.Yes) { DateTime dtStart = DateTime.Now; bool isResume = true; int iCount = 0; FGSyncService client = new FGSyncService(); DBClass db = new DBClass(); //List<WebRefFGSync.PalletEntity> data = client.ResetData().ToList(); //int total = db.ResetDataAll(data); //delete all data from mobile device db.ResetDataAll(); //now add data into device. do { List <InventAvailContract> data = client.GetFGYearInventory(iCount, true).ToList(); if (data.Count.Equals(0)) { isResume = false; } else { iCount = db.InsertDataAll(data); iCount++; } }while (isResume); client.Dispose(); DateTime dtEnd = DateTime.Now; var dateDiff = (dtEnd - dtStart).TotalMinutes; MessageBox.Show("Data has been reset. Total number of rows Imported: " + iCount.ToString() + "\nTime taken (Minutes): " + dateDiff.ToString(), "Reset Data", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1); } } catch (WebException exp) { if (exp.Status == WebExceptionStatus.ConnectFailure) { msg = "Unable to connect to Dynamics AX. Please contact Network administrator."; } else { msg = exp.Message; } MessageBox.Show(msg, "Connect Failure [" + AppVariables.DeviceName + "]", MessageBoxButtons.OK, MessageBoxIcon.Hand, MessageBoxDefaultButton.Button1); } catch (Exception exp) { MessageBox.Show(exp.Message); } finally { panelWait.Visible = false; } }