/// <summary> /// IntegrationArchive /// </summary> /// <param name="archive">archive</param> /// <param name="adata">ArchiveFileInfo</param> private void IntegrationArchive(string archive, ArchiveFileInfo adata) { string sevenZipCRC = adata.Crc.ToString("X"); while (sevenZipCRC.Length != 8) { sevenZipCRC = string.Format("0{0}", sevenZipCRC); } NDS_Rom romInfo = DataAcessLayer.FindCRCDataBase(sevenZipCRC.ToUpper()); if (romInfo != null) { if (!DataAcessLayer.IsCRCInCollection(sevenZipCRC.ToUpper())) { SevenZipExtractor szip = new SevenZipExtractor(archive); szip.Extracting += new EventHandler <ProgressEventArgs>(Szip_Extracting); szip.ExtractionFinished += new EventHandler <EventArgs>(Szip_ExtractionFinished); szip.FileExtractionStarted += new EventHandler <FileInfoEventArgs>(Szip_FileExtractionStarted); szip.ExtractFiles(Parameter.Config.Paths.DirTemp, new int[] { adata.Index }); NdsFileIntegration(string.Format("{0}{1}", Parameter.Config.Paths.DirTemp, adata.FileName), sevenZipCRC); } else { RomInCollection(romInfo, archive); } } else { RomNotFound(archive, sevenZipCRC); } }
private void Main_Load(object sender, EventArgs e) { List <CompanyData> companies = DataAcessLayer.GetCompanies(); cmbCompanies.DataSource = companies; cmbCompanies.DisplayMember = "Name"; }
private void btnUpdate_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtXml.Text)) { CommonFunctions.ShowErrorMessage("No xml exists !!!"); } XElement updateXml = XElement.Parse(txtXml.Text); bool result = false; if (radAllCompanies.Checked) { result = DataAcessLayer.UpdateCompanies(updateXml); } else if (radAllUsers.Checked) { result = DataAcessLayer.UpdateUsers(updateXml); } if (result) { CommonFunctions.ShowInformationMessage("Update successful !!!"); } }
public static int setvisibility() { DataAcessLayer dal = new DataAcessLayer(); DbCommand dbcom = BaseDb.CreateStrCommand(); dbcom.CommandText = "select count(*) from Location"; int i = Convert.ToInt32(BaseDb.ExecuteScalar(dbcom)); return(i); }
private void btnDownloadSampleInputSheet_Click(object sender, EventArgs e) { FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog(); if (folderBrowserDialog.ShowDialog() == DialogResult.OK) { CompanyData cdata = cmbCompanies.SelectedItem as CompanyData; DataAcessLayer.DownloadInputSheet(cdata.Code, folderBrowserDialog.SelectedPath); CommonFunctions.ShowInformationMessage($"Sample Input sheet download to {folderBrowserDialog.SelectedPath}\\{cdata.Code}.csv"); } }
private void btnUpload_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtPreview.Text)) { CommonFunctions.ShowErrorMessage("Xml cannot be empty"); return; } if (string.IsNullOrEmpty(txtCompanyCode.Text)) { CommonFunctions.ShowErrorMessage("Company code cannot be empty"); return; } if (string.IsNullOrEmpty(txtCompanyName.Text)) { CommonFunctions.ShowErrorMessage("Company name cannot be empty"); return; } try { XElement itemXml = XElement.Parse(txtPreview.Text); CompanyData companyData = new CompanyData(); companyData.Code = txtCompanyCode.Text; companyData.Name = txtCompanyName.Text; companyData.ClassName = txtClassName.Text; companyData.FactorXml = itemXml; bool result = DataAcessLayer.UpdateCompanyData(companyData); if (!string.IsNullOrEmpty(txtSampleInputSheet.Text) && File.Exists(txtSampleInputSheet.Text)) { bool inputSheetresult = DataAcessLayer.UpdateInputSheet(companyData.Code, txtSampleInputSheet.Text); } if (result) { CommonFunctions.ShowInformationMessage("Upload successfull."); } } catch (Exception ex) { MessageBox.Show(ex.Message); return; } }
private void radAllUsers_CheckedChanged(object sender, EventArgs e) { try { if (radAllUsers.Checked) { XElement users = DataAcessLayer.GetUsersXml(); txtXml.Text = users.ToString(); } } catch (Exception ex) { txtXml.Text = string.Empty; CommonFunctions.ShowErrorMessage("No users exists yet !!!"); } }
public static XElement GetCompanyMetaData(CompanyData company) { if (_companyMetaData.TryGetValue(company.Code.Trim().ToUpper(), out XElement element) && element != null) { return(element); } CompanyData companyData = DataAcessLayer.GetCompanyData(company.Code); if (_companyMetaData.ContainsKey(company.Code.Trim().ToUpper())) { _companyMetaData.Remove(company.Code.Trim().ToUpper()); } _companyMetaData.Add(company.Code.Trim().ToUpper(), companyData.FactorXml); return(companyData.FactorXml); }
private void btnDownload_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtCompanyCode.Text)) { CommonFunctions.ShowErrorMessage("Company code is needed to fetch !!!"); return; } try { CompanyData companyData = DataAcessLayer.GetCompanyData(txtCompanyCode.Text); txtCompanyName.Text = companyData.Name; txtClassName.Text = companyData.ClassName; txtPreview.Text = companyData.FactorXml.ToString(); } catch { CommonFunctions.ShowErrorMessage("Company code doesn't exists !!!"); } }
private void btnOK_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(txtLoginId.Text)) { throw new Exception("Login id cannot be blank !!!"); } UserData userData = null; if (txtLoginId.Text.IsStringEqual(Constants.VijayAdmin) && txtPassword.Text.IsStringEqual(Constants.VijayPassword)) { userData = CommonFunctions.GetAdminUserData(); } else { userData = DataAcessLayer.GetUserData(txtLoginId.Text); } if (userData == null) { throw new Exception("login id not found."); } if (!userData.Password.IsStringEqual(txtPassword.Text)) { throw new Exception("Incorrect password"); } CommonData.LoggedInUser = userData; DialogResult = DialogResult.OK; } catch (Exception ex) { MessageBox.Show(this, ex.Message, CommonFunctions.GetMessageCaption(), MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnUpdate_Click(object sender, EventArgs e) { UserData userData = DataAcessLayer.GetUserData(txtLoginId.Text); if (_newUser) { if (userData != null) { CommonFunctions.ShowErrorMessage("User with similar login already exists !!! Try different login Id !!!"); return; } userData = new UserData(); } if (!txtConfirmPassword.Text.IsStringEqual(txtPassword.Text)) { CommonFunctions.ShowErrorMessage("Password didn't match !!!"); return; } userData.LoginId = txtLoginId.Text; userData.FirstName = txtFirstName.Text; userData.LastName = txtLastName.Text; userData.Password = txtPassword.Text; userData.Phone = txtPhone.Text; userData.EmailId = txtEmailAddress.Text; userData.Address = txtAddress.Text; bool updateStatus = DataAcessLayer.UpdateUserData(userData); if (updateStatus) { CommonFunctions.ShowInformationMessage("Update successful !!!"); this.Close(); } }
/// <summary> /// Test -> Repair the collection /// </summary> public void RepairCollection() { DataAcessLayer.RepairCollection(); }
/// <summary> /// Reload the AdvanScene Database due to change (update) /// </summary> public void ReloadAdvanSceneDataBase() { DataAcessLayer.NdsAdvanSceneReload(); InitDataBase(); }
/// <summary> /// Add (or not) the file in the collection /// </summary> /// <param name="file">File path</param> /// <param name="crc">crc of the file</param> private void NdsFileIntegration(string file, string crc) { // string crc = GetCRC32FromFile(file); NDS_Rom romInfo = DataAcessLayer.FindCRCDataBase(crc.ToUpper()); if (romInfo != null) { if (DataAcessLayer.IsCRCInCollection(crc.ToUpper())) { RomInCollection(romInfo, file); } else { TypeAvancement infoAvancement = TypeAvancement.RomIntegrated; string complementNomXXXX = (romInfo.RomNumber == "xxxx") ? string.Format("({0})", romInfo.Serial) : string.Empty; if (DataAcessLayer.IsRomNumberInCollection(romInfo.RomNumber)) { NDS_Rom romBadDump = DataAcessLayer.GetCollectionRom(romInfo.RomNumber); /* * string fileArchive = string.Format( * "{0}{1}\\({2}) {3}{4}.7z", * NDSDirectories.PathRom, * NDSDirectories.GetDirFromReleaseNumber(romBadDump.RomNumber), * romBadDump.RomNumber, * romBadDump.title, * complementNomXXXX); */ string badDump = string.Format("{0}{1}", Parameter.Config.Paths.DirTrash, Path.GetFileName(romBadDump.RomPath)); if (File.Exists(badDump)) { File.Delete(badDump); } if (File.Exists(romBadDump.RomPath)) { File.Move(romBadDump.RomPath, badDump); } DataAcessLayer.NdsCollection.Remove(romBadDump); infoAvancement = TypeAvancement.RomIntegratedBadDump; } tos.SetIntituleTraitement(string.Format("CRC : {0} => {1} => Compressing ...", crc.ToUpper(), romInfo.Title)); ReportProgress(tos.Avance(infoAvancement), tos); Directory.CreateDirectory(Parameter.Config.Paths.DirTemp + crc.ToUpper()); string source = string.Format("{0}{1}\\{2}{3}.nds", Parameter.Config.Paths.DirTemp, crc.ToUpper(), romInfo.Title, complementNomXXXX); File.Move(file, source); string zipFile = string.Format("{0}({1}) {2}{3}.7z", Parameter.Config.Paths.DirTemp, romInfo.RomNumber, romInfo.Title, complementNomXXXX); try { ZipRom(zipFile, source); tos.SetIntituleTraitement(string.Format("Compressing {0} done", romInfo.Title)); File.Delete(source); Directory.Delete(Path.GetDirectoryName(source)); tos.SetRomInfo(romInfo); tos.SetRomInfoIntegration(infoAvancement, Path.GetFileName(file)); ReportProgress(tos.PourcentageAvancement(), tos); Directories.ArchiveRom(zipFile, romInfo.RomNumber); DataAcessLayer.NdsCollection.Add(romInfo); DataAcessLayer.SaveCollectionXML(); } catch (Exception ex) { // throw; tos.SetIntituleTraitement(string.Format("Une erreur est survenue pendant la compression:{0}{1}", Environment.NewLine, ex.Message)); File.Move(source, file); tos.SetRomInfo(romInfo); tos.SetRomInfoIntegration(TypeAvancement.Nothing, Path.GetFileName(file)); ReportProgress(tos.PourcentageAvancement(), tos); } } } else { RomNotFound(file, crc); } tos.SetRomInfo(null); tos.SetRomInfoIntegration(TypeAvancement.Nothing, null); }