private void btnAdd_Click(object sender, EventArgs e) { if (ValidateForm()) { txtActionDetails.Text = txtActionDetails.Text.Replace("\r\n", " ").Trim(); lvwOutbox.SelectedIndices.Clear(); dblayer.AddHakladaRecord(CreateShuratHaklada()); //this.hakladaTableAdapter.Fill(this.localInfoProtocolDataSet.Haklada); dblayer.ReadShuratHakladaList(lvwOutbox, Company_Info.CompanyCountryID.ToString(), Company_Info.CompanyVAT, ActionsListDictionary); CleanForm(); companyIDComboBox.Focus(); } }
public void ImportHaklada(String filename, CompanyInfo _companyinfo, DBLayer _dblayer) { Company_Info = _companyinfo; dblayer = _dblayer; String line = ""; StreamReader sr = new StreamReader(filename, CheckEncoder()); //Encoding.GetEncoding("iso-8859-8") //Hebrew From Magic while (!sr.EndOfStream) { line = sr.ReadLine(); dblayer.Current_Company_Info = _companyinfo; dblayer.AddHakladaRecord(CreateShuratHaklada(line)); } sr.Close(); }
public void ImportHaklada(String filename, CompanyInfo _companyinfo, DBLayer _dblayer, string delimiter) { Company_Info = _companyinfo; dblayer = _dblayer; String line = ""; //MessageBox.Show("filename: " + filename); //CheckEncoder(); //MessageBox.Show("_importEncoding: " + _importEncoding); //MessageBox.Show("CheckEncoder: " + CheckEncoder().ToString()); StreamReader sr = new StreamReader(filename, CheckEncoder()); //Encoding.GetEncoding("iso-8859-8") //Hebrew From Magic //MessageBox.Show("filename ", filename); while (!sr.EndOfStream) { line = sr.ReadLine(); dblayer.Current_Company_Info = _companyinfo; dblayer.AddHakladaRecord(CreateShuratHakladaDelimter(line, delimiter)); } sr.Close(); }
public void ImportHakladaMokupINI(String filename, CompanyInfo _companyinfo, DBLayer _dblayer, string delimiter) { Company_Info = _companyinfo; dblayer = _dblayer; String line = ""; StreamReader sr = new StreamReader(filename, CurrentImportEncoding); //Encoding.GetEncoding("iso-8859-8") //Hebrew From Magic while (!sr.EndOfStream) { line = sr.ReadLine(); dblayer.Current_Company_Info = _companyinfo; //dblayer.AddCompany(CreateCompanyDelimter(line, delimiter)); ShuratHaklada shurat_haklada = CreateShuratHakladaMokupINI(line, delimiter); if (shurat_haklada.Attachment == "") { if (Company_Info.FilesSearch != null) { try { string[] files = Directory.GetFiles(Company_Info.FilesSearch, "*" + shurat_haklada.MisparMismach + "*.*"); if (files.Length == 1) { shurat_haklada.Attachment = files[0].ToString(); } } catch (Exception) { } } } String TransactionGUID = dblayer.AddHakladaRecord(shurat_haklada); } sr.Close(); }
//private void MoveAttachment(String TransactionGUID, String Attachmnent) //{ // string ServerPath = Application.StartupPath + @"\TransientStorage"; // if (!Directory.Exists(ServerPath)) // { // Directory.CreateDirectory(ServerPath); // } // if (Company_Info.CompanyCountryID != 0) // { // if (!Directory.Exists(ServerPath + "/" + Company_Info.CompanyCountryID)) // { // Directory.CreateDirectory(ServerPath + "/" + Company_Info.CompanyCountryID); // } // } // if (Company_Info.CompanyVAT != null) // { // if (!Directory.Exists(ServerPath + "/" + Company_Info.CompanyCountryID + "/" + Company_Info.CompanyVAT)) // { // Directory.CreateDirectory(ServerPath + "/" + Company_Info.CompanyCountryID + "/" + Company_Info.CompanyVAT); // } // } // String fileName = TransactionGUID + Path.GetExtension(Attachmnent); // File.Move(Attachmnent, ServerPath + "/" + Company_Info.CompanyCountryID + "/" + Company_Info.CompanyVAT + "/" + fileName); //} public void ImportHakladaMokup(String filename, CompanyInfo _companyinfo, DBLayer _dblayer, char delimiter) { Company_Info = _companyinfo; dblayer = _dblayer; FiledHolder filedHolder = new FiledHolder(); filedHolder.InitINI(); filedHolder.Company_Info = Company_Info; filedHolder.Add("CountryID"); filedHolder.Add("CompanyVAT"); filedHolder.Add("CompanyName"); filedHolder.Add("ActionCode"); filedHolder.Add("MisparMismach"); filedHolder.Add("TarichMismach"); filedHolder.Add("TarichAcher"); filedHolder.Add("ActionDetails"); filedHolder.Add("Maam"); filedHolder.Add("SchumPaturMaam"); filedHolder.Add("SchumMaam"); filedHolder.Add("SchumKolelMaam"); filedHolder.Add("Attachment"); filedHolder.LoadData(); StreamReader sr = new StreamReader(filename, CheckEncoder()); //Encoding.GetEncoding("iso-8859-8") //Hebrew From Magic String line = ""; ArrayList flds = filedHolder.GetFileds(); //filedHolder.GetFiled("ActionCode") dblayer.Current_Company_Info = _companyinfo; //bool bSkipRow = false; while (!sr.EndOfStream) { line = sr.ReadLine(); filedHolder.CurrentDataLine = line; ShuratHaklada shurat_haklada = new ShuratHaklada(); String CompanyVAT = filedHolder.GetFiledValue(filedHolder.GetFiledPosition("CompanyVAT"), delimiter); String CompanyName = filedHolder.GetFiledValue(filedHolder.GetFiledOrder("CompanyName"), delimiter); Company company = CompanyIdentification.Identify(dblayer, Company_Info, null, CompanyVAT, CompanyName, null); if (company != null) { shurat_haklada.CompanyID = company.CompanyID; shurat_haklada.ActionCode = Convert.ToInt32(filedHolder.GetFiledValue("ActionCode")); shurat_haklada.MisparMismach = Convert.ToInt32(filedHolder.GetFiledValue("MisparMismach")); shurat_haklada.TarichMismach = Convert.ToDateTime(filedHolder.GetFiledValue("TarichMismach")); shurat_haklada.TarichAcher = Convert.ToDateTime(filedHolder.GetFiledValue("TarichAcher")); shurat_haklada.ActionDetails = filedHolder.GetFiledValue("ActionDetails"); shurat_haklada.AhuzHaMaam = Convert.ToDouble(filedHolder.GetFiledValue("Maam")); shurat_haklada.SchumPaturMaam = Convert.ToDouble(filedHolder.GetFiledValue("SchumPaturMaam")); shurat_haklada.SchumMaam = Convert.ToDouble(filedHolder.GetFiledValue("SchumMaam")); shurat_haklada.SchumKolelMaam = Convert.ToDouble(filedHolder.GetFiledValue("SchumKolelMaam")); shurat_haklada.Attachment = filedHolder.GetFiledValue("Attachment"); shurat_haklada.CompamyInfoCountryID = Company_Info.CompanyCountryID; shurat_haklada.CompamyInfoVAT = Company_Info.CompanyVAT; dblayer.AddHakladaRecord(shurat_haklada); } } sr.Close(); }