private void btnUpdate_Click(object sender, EventArgs e)
{
if (ValidateForm())
{
TochenTnua tochen_tnua = CreateTochenTnuaHaklada();
dblayer.UpdateTochenTnuaHakladaInbox(tochen_tnua);
dblayer.ReadTochenTnuaForShuratHakladaInboxListMain(lvwOutboxTochenTnua, TransactionGUID);
CleanForm();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (lvwOutboxTochenTnua.SelectedIndices.Count == 1)
{
if (MessageBox.Show("Delete Record ", "Delete Record", MessageBoxButtons.YesNo, MessageBoxIcon.Stop, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.Yes)
{
TochenTnua shurat_haklada = (TochenTnua)lvwOutboxTochenTnua.Items[lvwOutboxTochenTnua.SelectedIndices[0]].Tag;
dblayer.DeleteTochenTnuaOutboxHakladaInbox(shurat_haklada.RawDataNumber);
dblayer.ReadTochenTnuaForShuratHakladaInboxListMain(lvwOutboxTochenTnua, shurat_haklada.TransactionGUID);
}
}
}
private TochenTnua CreateTochenTnuaHaklada()
{
TochenTnua tochen_tnua = new TochenTnua();
if (lvwOutboxTochenTnua.SelectedIndices.Count == 1)
{
if (lvwOutboxTochenTnua.Items[lvwOutboxTochenTnua.SelectedIndices[0]].Tag != null)
{
tochen_tnua.RawDataNumber = ((TochenTnua)lvwOutboxTochenTnua.Items[lvwOutboxTochenTnua.SelectedIndices[0]].Tag).RawDataNumber;
}
}
tochen_tnua.TransactionGUID = TransactionGUID;
tochen_tnua.CodeParitAlpha = txtCodeParit.Text;
tochen_tnua.KamutKlalit = txtKamutKlalit.GetInt();
tochen_tnua.MechirYehida = txtMechirYechida.GetDouble();
tochen_tnua.SchumShura = txtSchumShura.GetDouble();
tochen_tnua.TeurParitAlpha = txtTeurParit.Text;
return(tochen_tnua);
}
private void lvwOutboxTochenTnua_SelectedIndexChanged(object sender, EventArgs e)
{
if (lvwOutboxTochenTnua.SelectedIndices.Count == 1)
{
TochenTnua tochen_tnua = (TochenTnua)lvwOutboxTochenTnua.Items[lvwOutboxTochenTnua.SelectedIndices[0]].Tag;
txtCodeParit.Text = tochen_tnua.CodeParitNumeri.ToString();
txtKamutKlalit.Text = tochen_tnua.KamutKlalit.ToString();
txtMechirYechida.Text = tochen_tnua.MechirYehida.ToString();
txtSchumShura.Text = tochen_tnua.SchumShura.ToString();
txtTeurParit.Text = tochen_tnua.TeurParitAlpha.ToString();
}
else
{
CleanForm();
}
btnUpdate.Enabled = (lvwOutboxTochenTnua.SelectedIndices.Count == 1);
btnDelete.Enabled = (lvwOutboxTochenTnua.SelectedIndices.Count == 1);
}
public void GetTochenTnua(String[] parts, ArrayList result)
{
if (parts[5].Substring(0, 2) == "TT")
{
char[] dataDelimiters = new char[] { '|' };
TochenTnua tt = new TochenTnua();
tt.TransactionGUID = parts[0].ToString();
tt.CountryIDFrom = Int32.Parse(parts[1].ToString());
tt.VatFrom = parts[2].ToString();
tt.CountryIDTo = Int32.Parse(parts[3].ToString());
tt.VatTo = parts[4].ToString();
//if (parts.Length == 18)
//{
// kt.Confirm0 = Boolean.Parse(parts[15].ToString());
// kt.Confirm1 = Boolean.Parse(parts[16].ToString());
// kt.Confirm2 = Boolean.Parse(parts[17].ToString());
//}
try
{
if ((parts[6].ToString() != null) && (parts[6].ToString() != ""))
{
//kt.TimeStampRead = ConvertToDDMMYYYY(parts[6].ToString().Substring(0, 19));
tt.TimeStampWrite = ConvertToDDMMYYYY(parts[6].ToString());
}
}
catch (Exception)
{
}
try
{
if ((parts[7].ToString() != null) && (parts[7].ToString() != ""))
{
//kt.TimeStampWrite = ConvertToDDMMYYYY(parts[7].ToString().Substring(0, 19));
tt.TimeStampRead = ConvertToDDMMYYYY(parts[7].ToString());
}
}
catch (Exception)
{
}
string[] dataParts = parts[5].ToString().Split(dataDelimiters, StringSplitOptions.None);
bool bIsValidRecord = true;
tt.Data = parts[5];
for (int i = 1; i < dataParts.Length; i++)
{
bIsValidRecord = true;
if (dataParts[i].ToString().Length >= FiledNumberPrefixLength)
{
int ValidFieldNumber = GetNumeric(dataParts[i].ToString().Substring(0, FiledNumberPrefixLength));
if (ValidFieldNumber != -1)
{
String FieldValue = dataParts[i].ToString().Substring(FiledNumberPrefixLength, dataParts[i].ToString().Length - FiledNumberPrefixLength);
switch (ValidFieldNumber)
{
case 1:
tt.MisparPnimi = Int32.Parse(FieldValue); //מספר פנימי
break;
case 22:
tt.MisparShuraBaTnua = Int32.Parse(FieldValue); //מספר שורה בתנועה
break;
case 23:
tt.CodeParitAlpha = FieldValue; //קוד פריט אלפה
break;
case 24:
tt.TeurParitAlpha = FieldValue; //תאור פריט אלפה
break;
case 25:
tt.Kamut1 = Int32.Parse(FieldValue); //כמות 1
break;
case 26:
tt.Kamut2 = Int32.Parse(FieldValue); //כמות 2
break;
case 27:
tt.Kamut3 = Int32.Parse(FieldValue); //כמות 3
break;
case 28:
tt.Kamut4 = Int32.Parse(FieldValue); //כמות 4
break;
case 29:
tt.KamutKlalit = Int32.Parse(FieldValue); //כמות כללית
break;
case 30:
tt.TeurYahida = FieldValue; //תאור יחידה
break;
case 31:
tt.MechirYehida = Double.Parse(FieldValue); //מחיר יחידה
break;
case 32:
tt.SchumLefniHanacha = Double.Parse(FieldValue); //סכום לפני הנחה
break;
case 33:
tt.AhuzHanacha = Double.Parse(FieldValue); //אחוז הנחה
break;
case 34:
tt.SchumHanacha = Double.Parse(FieldValue); //סכום הנחה
break;
case 35:
tt.SchumShura = Double.Parse(FieldValue); //סכום לאחר הנחה
break;
case 36:
tt.AhuzHaMaam = Double.Parse(FieldValue); //אחוז המע"מ
break;
case 37:
tt.CodeMatbea = Int32.Parse(FieldValue); //קוד מטבע
break;
case 38:
tt.SharMatbea = Double.Parse(FieldValue); //שער מטבע
break;
case 39:
tt.MechirYehidaBeMatbea = Double.Parse(FieldValue); //מחיר יחידה במטבע
break;
case 40:
tt.SchumShuraMatbeaLefniHanacha = Double.Parse(FieldValue); //סכום שורה מטבע לפני הנחה
break;
case 41:
tt.SchumHanachaBeMatbea = Double.Parse(FieldValue); //סכום הנחה במטבע
break;
case 42:
tt.SchumShuraMatbeaLacharHanacha = Double.Parse(FieldValue); //סכום שורה במטבע לאחר הנחה
break;
case 43:
tt.BarCodeParit = FieldValue; //בר קוד פריט
break;
default:
break;
}
}
else
{
bIsValidRecord = false;
break;
}
}
}
if (bIsValidRecord)
{
result.Add(tt);
}
}
}
private static void InboxFromHakladatTochenTnua()
{
String SQL = "SELECT * from HakladatTochenTnuaInbox WHERE Transfered = 0";
ArrayList all_records = dblayer.SQLQueryArrayList(SQL);
foreach (ArrayList record in all_records)
{
Company company = dblayer.GetCompany(record[1].ToString());
CompanyInfo company_info = dblayer.GetCompanyInfo(record[13].ToString(), record[14].ToString());
TochenTnua tochen_tnua = new TochenTnua();
tochen_tnua.TransactionGUID = record[0].ToString();
tochen_tnua.CountryIDFrom = Company_Info.CompanyCountryID;
tochen_tnua.CountryIDTo = company.CountryID;
tochen_tnua.VatTo = company.CompanyVAT;
tochen_tnua.VatFrom = Company_Info.CompanyVAT;
//TT|011|021231|0301/01/2012|0401/02/2012|0503/01/2012|0604/01/2012|07ClientName|08123456789|09bla bla|10100.20|1110.5|1216.5|13116.5|141|15CompanyFrom|16OsekMoorshehHaSholeah|17CountryIDHaSholeah
//מספר תנועה חיצוני // מספר פנימי
//01: kt.MisparPnimi //מספר פנימי -
//22: מספר שורה בתנועה
//23: קוד פריט נומרי חיצוני
//24: קוד פריט אלפה
//25: תאור פריט אלפה
//26: כמות 1
//27: כמות 2
//28: כמות 3
//28: כמות 4
//29: כמות כללית
//30: תאור יחידה
//31: מחיר יחידה
//32: סכום לפני הנחה
//33: אחוז הנחה
//34: סכום הנחה
//35: סכום לאחר הנחה
//36: אחוז המע"מ
//37: קוד מטבע
//38: שער מטבע
//39: מחיר יחידה במטבע
//40: סכום שורה מטבע לפני הנחה
//41: סכום הנחה במטבע
//42: סכום שורה במטבע לאחר הנחה
//43: בר קוד פריט
String tt = "TT|";
tt += cmd("01", record[2].ToString());
tt += cmd("22", record[3].ToString());
tt += cmd("23", record[4].ToString());
tt += cmd("24", record[5].ToString());
tt += cmd("25", record[5].ToString());
tt += cmd("26", record[6].ToString());
tt += cmd("27", record[7].ToString());
tt += cmd("28", record[8].ToString());
tt += cmd("29", record[9].ToString());
tt += cmd("30", record[10].ToString());
tt += cmd("31", record[11].ToString());
tt += cmd("32", record[12].ToString());
tt += cmd("33", record[13].ToString());
tt += cmd("34", record[14].ToString());
tt += cmd("35", record[15].ToString());
tt += cmd("36", record[16].ToString());
tt += cmd("37", record[17].ToString());
tt += cmd("38", record[18].ToString());
tt += cmd("39", record[19].ToString());
tt += cmd("40", record[20].ToString());
tt += cmd("41", record[21].ToString());
tt += cmd("42", record[22].ToString());
tt += cmd("43", record[23].ToString());
tochen_tnua.Data = tt.Substring(0, tt.Length - 1);
dblayer.Current_Company_Info = Company_Info;
dblayer.AddCreateInboxRecord(tochen_tnua, company.WriteCode, record[11].ToString());
dblayer.TransferedShuratHakladaInbox(record[0].ToString(), true);
}
}
