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();
}
