private void btnExport_Click(object sender, EventArgs e) { try { if (Convert.ToInt32(cmbExpLocation.SelectedValue) < 1) { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["MessageText"] = "Export Location"; IQCareWindowMsgBox.ShowWindowConfirm("BlankDropDown", theBuilder, this); return; } if (Convert.ToDateTime(dtFrmDate.Value) > Convert.ToDateTime(dtToDate.Value)) { IQCareWindowMsgBox.ShowWindow("FromDTgreaterToDate", this); return; } this.Cursor = Cursors.WaitCursor; IImportExport theExportManager = (IImportExport)ObjectFactory.CreateInstance("BusinessProcess.FormBuilder.BImportExport, BusinessProcess.FormBuilder"); DataTable theDT = theExportManager.ExportIQCareDB(Convert.ToInt32(cmbExpLocation.SelectedValue), dtFrmDate.Value, dtToDate.Value); this.Cursor = Cursors.Default; Int32 theRec = theDT.Rows.Count - 1; MsgBuilder theExpBuilder = new MsgBuilder(); theExpBuilder.DataElements["Control"] = theDT.Rows[theRec][0].ToString(); IQCareWindowMsgBox.ShowWindowConfirm("ExportSuccess", theExpBuilder, this); } catch (Exception err) { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["MessageText"] = err.Message.ToString(); IQCareWindowMsgBox.ShowWindowConfirm("#C1", theBuilder, this); return; } }
private void btnImport_Click(object sender, EventArgs e) { try { if (txtFileName.Text.Trim() == "") { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["MessageText"] = "Import Database"; IQCareWindowMsgBox.ShowWindowConfirm("BlankTextBox", theBuilder, this); return; } this.Cursor = Cursors.WaitCursor; IImportExport theImportManager = (IImportExport)ObjectFactory.CreateInstance("BusinessProcess.FormBuilder.BImportExport, BusinessProcess.FormBuilder"); theImportManager.ImportIQCareData(Convert.ToInt32(cmbImpLocation.SelectedValue), txtFileName.Text.ToString()); this.Cursor = Cursors.Default; IQCareWindowMsgBox.ShowWindowConfirm("ImportDBSuccess", this); } catch (Exception err) { MsgBuilder theBuilder = new MsgBuilder(); theBuilder.DataElements["MessageText"] = err.Message.ToString(); IQCareWindowMsgBox.ShowWindowConfirm("#C1", theBuilder, this); return; } }
private void btnexport_Click(object sender, EventArgs e) { if (!fnValidate()) { IQCareWindowMsgBox.ShowWindow("SelectSCMList", this); return; } string dir = @"C:\SCMExport"; IImportExport theExportManager = (IImportExport)ObjectFactory.CreateInstance("BusinessProcess.FormBuilder.BImportExport, BusinessProcess.FormBuilder"); DataSet theDS = theExportManager.ExportSCMIQCare(); if (!Directory.Exists(dir)) { Directory.CreateDirectory(dir); } else { string[] filePaths = Directory.GetFiles(@"c:\SCMExport\"); foreach (string filePath in filePaths) { File.Delete(filePath); } } theDS.WriteXml("C:\\SCMExport\\SCMMaster.xml", XmlWriteMode.WriteSchema); lblmessage.Text = "Exported file has saved in c:\\SCMExport\\SCMMaster.xml"; exportItem(); dropDBBackup(); }
string GetWorkFlowXml() { List <String> points = new List <string>(); List <String> activitys = new List <string>(); foreach (var v in print.Children) { IImportExport iie = v as IImportExport; if (null == iie) { continue; } points.Add(iie.ExportLocation()); if (v is IActivity) { activitys.Add((v as IActivity).ExportControlRelationship()); } } string _xmlValue = string.Format("<Root>\r\n{0}\r\n{1}\r\n</Root>", string.Format("<Controls Index=\"{0}\" Height=\"{1}\" Width=\"{2}\">{3}</Controls>", Index, this.print.Height, this.print.Width, string.Join("\r\n", points)), string.Format("<Relationship>{0}</Relationship>", string.Join("\r\n", activitys))); return(XElement.Parse(_xmlValue).ToString()); }
public LibraryManager() { SongManager = new SongManager(); ImportExport = new XMLImportExport <Library>(); if (File.Exists(LIBRARY_INFO_ROOT_PATH)) { try { Library = ImportExport.Import(LIBRARY_INFO_ROOT_PATH).First(); } catch { Library = new Library(); } } else { Library = new Library(); } }
private void btnImport_Click(object sender, EventArgs e) { if (txtfile.Text != "") { lblmessage.Text = ""; string strExportList = "C:\\SCMExportFile\\ExportMaster.xml"; string myXMLfile = txtfile.Text; string strext = Path.GetExtension(myXMLfile); if (strext != ".xml") { IQCareWindowMsgBox.ShowWindow("BrowseFile", this); return; } if (myXMLfile.ToUpper() != "C:\\SCMEXPORT\\SCMMASTER.XML") { IQCareWindowMsgBox.ShowWindow("Browswrongfile", this); return; } DataSet dsExportList = new DataSet(); System.IO.FileStream fsReadXml1 = new System.IO.FileStream(strExportList, System.IO.FileMode.Open); dsExportList.ReadXml(fsReadXml1); fsReadXml1.Close(); DataSet ds = new DataSet(); System.IO.FileStream fsReadXml = new System.IO.FileStream (myXMLfile, System.IO.FileMode.Open); try { ds.ReadXml(fsReadXml); //if (ds.Tables[0].Rows[0]["AppVer"].ToString() != GblIQCare.AppVersion || ((DateTime)ds.Tables[0].Rows[0]["RelDate"]).ToString("dd-MMM-yyyy") != GblIQCare.ReleaseDate) //{ // IQCareWindowMsgBox.ShowWindow("ImportScmMasterCheckVersion", this); // return; //} IImportExport theExportManager = (IImportExport)ObjectFactory.CreateInstance("BusinessProcess.FormBuilder.BImportExport, BusinessProcess.FormBuilder"); if (ds.Tables.Count == 21) { theExportManager.DBBackUpImportData(); foreach (DataRow r in dsExportList.Tables[0].Rows) { if (r["Name"].ToString() == "PharmacyMaster") { theExportManager.BulkInsert(ds.Tables[1], "Mst_Drug"); theExportManager.BulkInsert(ds.Tables[2], "Mst_Generic"); theExportManager.BulkInsert(ds.Tables[3], "Lnk_DrugGeneric"); theExportManager.BulkInsert(ds.Tables[4], "Mst_DrugType"); theExportManager.BulkInsert(ds.Tables[5], "Lnk_DrugTypeGeneric"); theExportManager.BulkInsert(ds.Tables[21], "mst_strength"); theExportManager.BulkInsert(ds.Tables[22], "lnk_DrugStrength"); } if (r["Name"].ToString() == "ItemConfiguration") { theExportManager.ImportSCM(ds.Tables[6], "ItemConfiguration"); } if (r["Name"].ToString() == "Manufacturerdetail") { theExportManager.BulkInsert(ds.Tables[7], "mst_manufacturer"); } if (r["Name"].ToString() == "Programitemlinking") { theExportManager.ImportSCM(ds.Tables[8], "Programitemlinking"); } if (r["Name"].ToString() == "Storeitemlinking") { theExportManager.ImportSCM(ds.Tables[9], "Storeitemlinking"); } if (r["Name"].ToString() == "Supplieritemlinking") { theExportManager.ImportSCM(ds.Tables[10], "Supplieritemlinking"); } if (r["Name"].ToString() == "Program") { theExportManager.BulkInsert(ds.Tables[11], "mst_program"); } if (r["Name"].ToString() == "Donor") { theExportManager.BulkInsert(ds.Tables[12], "mst_donor"); } if (r["Name"].ToString() == "Programdonorlinking") { theExportManager.BulkInsert(ds.Tables[13], "Lnk_DonorProgram"); } if (r["Name"].ToString() == "Costallocationcategory") { theExportManager.ImportSCM(ds.Tables[14], "Costallocationcategory"); } if (r["Name"].ToString() == "Storedetail") { theExportManager.BulkInsert(ds.Tables[15], "mst_store"); } if (r["Name"].ToString() == "Storesourcedestinationlinking") { theExportManager.BulkInsert(ds.Tables[16], "lnk_StoreSourceDestination"); } if (r["Name"].ToString() == "Supplier") { theExportManager.BulkInsert(ds.Tables[17], "mst_supplier"); } if (r["Name"].ToString() == "Adjustmentreason") { theExportManager.ImportSCM(ds.Tables[18], "Adjustmentreason"); } if (r["Name"].ToString() == "Returnreason") { theExportManager.ImportSCM(ds.Tables[19], "Returnreason"); } if (r["Name"].ToString() == "Labtestlocation") { theExportManager.ImportSCM(ds.Tables[20], "Labtestlocation"); } if (r["Name"].ToString() == "AddConstraint") { theExportManager.ImportSCM(ds.Tables[10], "AddConstraint"); } } IQCareWindowMsgBox.ShowWindow("ImportSuccess", this); } else { IQCareWindowMsgBox.ShowWindow("Browswrongfile", this); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { fsReadXml.Close(); } } else { IQCareWindowMsgBox.ShowWindow("BrowseFile", this); return; } }