private void tServiceValue_TextChanged(object sender, EventArgs e)
{
try {
double dValue = 0;
for (int t = 0; t <= lvList.Items.Count - 1; t++)
{
dValue = Convert.ToDouble(tServiceValue.Text) * (Convert.ToDouble(lvList.Items[t].SubItems[2].Text) / 100);
lvList.Items[t].SubItems[3].Text = MyModules.FormatDouble(dValue);
}
}
catch
{
}
}
public void LoadService(int strCode)
{
try
{
SqlConnection cnSQL = new SqlConnection(MyModules.strConnect);
SqlCommand cmSQL = new SqlCommand();
cmSQL.Connection = cnSQL;
cnSQL.Open();
SqlDataReader drSQL = null;
Flush();
string dReward = "0";
cmSQL.CommandText = "SELECT Services.*, Register.Outline FROM Services INNER JOIN Register ON Services.RefNo = Register.Code WHERE Sn=" + strCode;
cmSQL.CommandType = CommandType.Text;
drSQL = cmSQL.ExecuteReader();
while (drSQL.Read())
{
tTransNo.Text = drSQL["Sn"].ToString();
dtpDate.Text = drSQL["TransDate"].ToString();
tRefNo.Text = drSQL["RefNo"].ToString();
tClientsDetails.Text = drSQL["Telephone"].ToString() + " (" + drSQL["Name"].ToString() + ")";
tServiceDetails.Text = drSQL["ServiceRendered"].ToString();
tServiceValue.Text = MyModules.FormatDouble(drSQL["ValueOfService"]);
tAmountPaid.Text = MyModules.FormatDouble(drSQL["AmountPaid"]);
dReward = MyModules.FormatDouble(drSQL["AmountChargedFromReward"]);
ClientOutline = drSQL["Outline"].ToString();
}
tRewardBalance.Text = MyModules.FormatDouble(GetClientReward(tRefNo.Text) + Convert.ToDouble(dReward));
tReward.Text = Convert.ToDouble(dReward).ToString();
drSQL.Close();
cnSQL.Close();
GetSubLevel(tRefNo.Text);
double dValue = 0;
for (int t = 0; t <= lvList.Items.Count - 1; t++)
{
dValue = Convert.ToDouble(tServiceValue.Text) * (Convert.ToDouble(lvList.Items[t].SubItems[2].Text) / 100);
lvList.Items[t].SubItems[3].Text = MyModules.FormatDouble(dValue);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void cmdClient_Click(object sender, EventArgs e)
{
using (var form = new FrmList("Clients", "List of Clients"))
{
var result = form.ShowDialog();
if (result == DialogResult.OK)
{
tRefNo.Text = form.ReturnValue.ToString();
tClientsDetails.Text = form.ReturnValue1.ToString() + " (" + form.ReturnValue2.ToString() + ")";
ClientOutline = form.ReturnValue3.ToString();
GetSubLevel(tRefNo.Text);
tRewardBalance.Text = MyModules.FormatDouble(GetClientReward(tRefNo.Text));
tServiceValue_TextChanged(sender, e);
}
}
}
private void tReward_TextChanged(object sender, EventArgs e)
{
if (tRewardBalance.Text == "")
{
tRewardBalance.Text = "0";
}
if (tReward.Text == "")
{
tReward.Text = "0";
}
if (Convert.ToDouble(tReward.Text) > Convert.ToDouble(tRewardBalance.Text))
{
MessageBox.Show("Exceeds Available Reward", MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
tReward.Text = "0";
}
tAmountPaid.Text = MyModules.FormatDouble(Convert.ToDouble(tServiceValue.Text) - Convert.ToDouble(tReward.Text));
}
public void GetRewardSummary()
{
try
{
SqlConnection cnSQL = new SqlConnection(MyModules.strConnect);
SqlCommand cmSQL = new SqlCommand();
cmSQL.Connection = cnSQL;
SqlDataReader drSQL;
cnSQL.Open();
cmSQL.CommandText = "SELECT ISNULL(SUM([Reward]),0) AS Reward,ISNULL(SUM(AmountDrawnFromReward),0) AS AmountDrawnFromReward FROM Ledger";
cmSQL.CommandType = System.Data.CommandType.Text;
drSQL = cmSQL.ExecuteReader();
if (drSQL.HasRows == false)
{
lblRewardDrawn.Text = "0.0";
lblRewardBalance.Text = "0.0";
lblTotalRewardEarned.Text = "0.0";
}
else
{
if (drSQL.Read())
{
lblRewardDrawn.Text = MyModules.FormatDouble(drSQL["AmountDrawnFromReward"]);
lblRewardBalance.Text = MyModules.FormatDouble(Convert.ToDouble(drSQL["Reward"]) - Convert.ToDouble(drSQL["AmountDrawnFromReward"]));
lblTotalRewardEarned.Text = MyModules.FormatDouble(drSQL["Reward"]);
}
}
//cmSQL.Connection.Close()
cmSQL.Dispose();
drSQL.Close();
cnSQL.Close();
//cnSQL.Dispose()
}
catch //(Exception ex)
{
// MessageBox.Show(ex.Message, MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void tReward_Leave(object sender, EventArgs e)
{
tReward.Text = MyModules.FormatDouble(tReward.Text);
}
private void tAmountPaid_Leave(object sender, EventArgs e)
{
tAmountPaid.Text = MyModules.FormatDouble(tAmountPaid.Text);
}
private void tServiceValue_Leave(object sender, EventArgs e)
{
tServiceValue.Text = MyModules.FormatDouble(tServiceValue.Text);
tReward.Text = "0";
tAmountPaid.Text = "0";
}
