private void cmd_Delete_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show(" Are You Sure ? ", "Warning !", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
if (dialogResult == DialogResult.Yes)
{
try
{
Database.DBPrepaidCable.DBPrepaidCards del = new Database.DBPrepaidCable.DBPrepaidCards();
del.Delete(this.dataGridView_PrepaidCards.SelectedCells[0].Value.ToString());
load_dataGridView_PrepaidCards();
}
catch (Exception ex)
{
ex.ToString();
}
buttonEnable(false);
cmd_Delete.Enabled = false;
cmd_Add.Enabled = true;
input_Clear();
}
}
private void cmd_Save_Click(object sender, EventArgs e)
{
if (input_validity() == true)
{
Database.DBPrepaidCable.DBPrepaidCards update = new Database.DBPrepaidCable.DBPrepaidCards();
update.Update(dataGridView_PrepaidCards.SelectedCells[0].Value.ToString(), CableType, Convert.ToInt32(AmountType), Pin, "Available", DateRegister, DateExpire);
load_dataGridView_PrepaidCards();
buttonEnable(false);
cmd_Edit.Enabled = true;
}
}
private void cmd_Add_Click(object sender, EventArgs e)
{
if (input_validity() == true)
{
buttonEnable(false);
try
{
Database.DBPrepaidCable.DBPrepaidCards add = new Database.DBPrepaidCable.DBPrepaidCards();
add.Add(CableType, Convert.ToInt32(AmountType), Pin, "Available", DateRegister, DateExpire);
load_dataGridView_PrepaidCards();
}catch (Exception ex) {
MessageBox.Show(ex.ToString());
}
cmd_Add.Enabled = cmd_Cancel.Enabled = true;
input_Clear();
}
}
public bool PrepaidCableParsing(string mess, string sender)
{
string message = mess.ToUpper();
string[] words = message.Split(" ".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
Array arr = words;
Database.DBRetailers ret = Database.DBRetailers.GetDataByWallet(sender);
if (ret != null)
{
Database.DBPrepaidCable.DBPrepaidCable preCable = Database.DBPrepaidCable.DBPrepaidCable.GetDataByCode(words[0].ToUpper());
if (preCable != null)
{
if (arr.Length == 4)
{
try
{
if ((float)(ret.Balance) >= (float)(Convert.ToDouble(words[2]) - (Convert.ToDouble(words[2]) * Convert.ToDouble(.02))))
{
Database.DBPrepaidCable.DBPrepaidCards datalist = Database.DBPrepaidCable.DBPrepaidCards.GetDataByAmount(Convert.ToInt32(words[2]), preCable.Code);
if (datalist != null)
{
float amountcoded = (float)(Convert.ToDouble(words[2]));
float discount = amountcoded * (float)(0.02);
Database.DBTransactions.DBPrepaidCableTransactions transac = new Database.DBTransactions.DBPrepaidCableTransactions();
transac.Add(sender, words[0], words[1], amountcoded, discount, datalist.Pin, words[3], DateTime.Now, "Sending");
if (PhoneNumberParsing(words[3]) != "")
{
//SEND TO CUSTOMER
if (words[0] == "CIGNAL" || words[0] == "DREAM")
{
AddtoOutBox(DateTime.Now, words[3], words[0] + " " + datalist.Pin + " " + words[1] + "\n" + preCable.Gateway, "Pending");
}
//sky or Gsat
if (words[0] == "SKY" || words[0] == "GSAT")
{
AddtoOutBox(DateTime.Now, words[3], words[0] + " " + words[1] + " " + datalist.Pin + "\n" + preCable.Gateway, "Pending");
}
return(true);
}
AddtoOutBox(DateTime.Now, sender, "Invalid Customer Number.", "Pending");
return(false);
}
AddtoOutBox(DateTime.Now, sender, "Amount : " + words[2] + " Code : " + words[0] + " None Available", "Pending");
return(false);
}
//youWallet is none enough
AddtoOutBox(DateTime.Now, sender, "Your balance is " + ret.Balance + " None enough", "Pending");
return(false);
}
catch (Exception ex)
{
ex.ToString();
//No Code Amount Detected
AddtoOutBox(DateTime.Now, sender, "Invalid Code ! must be a Number Amount : " + words[2], "Pending");
return(false);
}
}
AddtoOutBox(DateTime.Now, sender, "Incomplete Command, please check your message format.", "Pending");
return(false);
}
//**sendPending/***Invalid first Primary Code
AddtoOutBox(DateTime.Now, sender, "Invalid Primary Code, please check your message format.", "Pending");
return(false);
}
//Invalid Sender Unregistered Wallet
//No reply...
return(false);
}
public static void PrepaidCableConfirmationCustomer()
{
try{
string mess, mess1;
mess = mess1 = "";
Database.DBTransactions.DBPrepaidCableTransactions trs = Database.DBTransactions.DBPrepaidCableTransactions.GetDataSendingStatus("Sending");
Database.DBMessages.DBOutbox add = new Database.DBMessages.DBOutbox();
if (trs != null)
{
Database.DBPrepaidCable.DBPrepaidCable preCable = Database.DBPrepaidCable.DBPrepaidCable.GetDataByCode(trs.Code);
Database.DBMessages.DBOutboxLog outbl1 = Database.DBMessages.DBOutboxLog.GetDataMessage(trs.Code + " " + trs.Box_number + " " + trs.Pin);
Database.DBMessages.DBOutboxLog outbl2 = Database.DBMessages.DBOutboxLog.GetDataMessage(trs.Code + " " + trs.Pin + " " + trs.Box_number);
Database.DBMessages.DBOutbox outb1 = Database.DBMessages.DBOutbox.GetDataMessage(trs.Code + " " + trs.Pin + " " + trs.Box_number, "Unsuccessful");
Database.DBMessages.DBOutbox outb2 = Database.DBMessages.DBOutbox.GetDataMessage(trs.Code + " " + trs.Box_number + " " + trs.Pin, "Unsuccessful");
if (outbl1 != null || outbl2 != null)
{
Database.DBPrepaidCable.DBPrepaidCable cabletype = Database.DBPrepaidCable.DBPrepaidCable.GetDataByCode(trs.Code);
Database.DBPrepaidCable.DBPrepaidCards cards = Database.DBPrepaidCable.DBPrepaidCards.GetDataByAmount(Convert.ToInt32(trs.Amount), cabletype.Code);
Database.DBPrepaidCable.DBPrepaidCardslog cardslog = new Database.DBPrepaidCable.DBPrepaidCardslog();
Database.DBPrepaidCable.DBPrepaidCards cards1 = new Database.DBPrepaidCable.DBPrepaidCards();
cardslog.Add(cabletype.Code, cards.Amount, cards.Pin, DateTime.Now, "Used");
cards1.Delete(Convert.ToString(cards.Id));
Database.DBRetailers wallet = Database.DBRetailers.GetDataByWallet(trs.Wallet_id);
Database.DBRetailers upd = new Database.DBRetailers();
float balance = wallet.Balance + trs.Discount - trs.Amount;
upd.UpdateBalance(wallet.Wallet_Id, balance);
var chars = trs.Pin.ToCharArray();
for (int x = chars.Length - 4; x >= 0; x--)
{
mess1 = chars[x] + mess1;
}
if (trs.Code == "CIGNAL" || trs.Code == "DREAM")
{
mess = trs.Code + " " + mess1 + "*** " + trs.Box_number;
}
if (trs.Code == "SKY" || trs.Code == "GSAT")
{
mess = trs.Code + " " + trs.Box_number + " " + mess1 + "***";
}
add.Add(DateTime.Now, trs.Wallet_id, "A1+ : Successfully Transact ref#:" + trs.Id.ToString("D6") + " to " + trs.Customer_number + ". Current bal " + balance + ". \n" + mess + ".", "Pending");
Database.DBTransactions.DBPrepaidCableTransactions update = new Database.DBTransactions.DBPrepaidCableTransactions();
update.Update(trs.Id, "status", "Sent");
}
else if (outb1 != null || outb2 != null)
{
Database.DBTransactions.DBPrepaidCableTransactions update = new Database.DBTransactions.DBPrepaidCableTransactions();
update.Update(trs.Id, "status", "Failed");
add.Add(DateTime.Now, trs.Wallet_id, " Transaction Failed !", "Pending");
}
}
}
catch (Exception ex)
{
ex.ToString();
MessageBox.Show("Error Processing !");
}
}
