public Contact()
{
InitializeComponent();
db1 = new Water_Board_Management.Database("inprogress", "refno");
db2 = new Water_Board_Management.Database("account", "accountNo");
b1 = false;
original = new String[3];
}
public Contact()
{
InitializeComponent();
db1 = new Water_Board_Management.Database("inprogress", "refno");
db2 = new Water_Board_Management.Database("account", "accountNo");
b1 = false;
original = new String[3];
}
public Billing()
{
InitializeComponent();
dbBUlk = new Water_Board_Management.Database("meter", "month");
userDB = new Water_Board_Management.Database("account", "accountNo");
accountNumber = 1001667;
setUser(1);
label50.Text = System.DateTime.Today.ToLongDateString();
db = new Water_Board_Management.Database("a" + accountNumber, "month");
}
public Billing()
{
InitializeComponent();
dbBUlk = new Water_Board_Management.Database("meter", "month");
userDB = new Water_Board_Management.Database("account", "accountNo");
accountNumber = 1001667;
setUser(1);
label50.Text = System.DateTime.Today.ToLongDateString();
db = new Water_Board_Management.Database("a" + accountNumber, "month");
}
public Contact(int acc)
{
InitializeComponent();
db1 = new Water_Board_Management.Database("inprogress", "refno");
db2 = new Water_Board_Management.Database("account", "accountNo");
b1 = false;
original = new String[3];
radioButton1.Enabled = false;
accntN.Text = acc.ToString();
accntN.ReadOnly = true;
}
public Billing(int auth, int account)
{
InitializeComponent();
userDB = new Water_Board_Management.Database("account", "accountNo");
dbBUlk = new Water_Board_Management.Database("meter", "month");
authLevel = auth;
accountNumber = account;
db = new Water_Board_Management.Database("a" + accountNumber, "month");
setUser(authLevel);
label50.Text = System.DateTime.Today.ToLongDateString();
}
public Billing(int auth, int account)
{
InitializeComponent();
userDB = new Water_Board_Management.Database("account", "accountNo");
dbBUlk = new Water_Board_Management.Database("meter", "month");
authLevel = auth;
accountNumber = account;
db = new Water_Board_Management.Database("a" + accountNumber, "month");
setUser(authLevel);
label50.Text = System.DateTime.Today.ToLongDateString();
}
public Contact(int acc)
{
InitializeComponent();
db1 = new Water_Board_Management.Database("inprogress", "refno");
db2 = new Water_Board_Management.Database("account", "accountNo");
b1 = false;
original = new String[3];
radioButton1.Enabled = false;
accntN.Text = acc.ToString();
accntN.ReadOnly = true;
}
public Maintenance()
{
InitializeComponent();
db1 = new Water_Board_Management.Database("complaint", "referenceNo");
db2 = new Water_Board_Management.Database("appeal", "referenceNo");
compRefs = db1.getColumn("referenceNo");
applRefs = db2.getColumn("referenceNo");
conv = new Water_Board_Management_HelpDesk.Converter();
isComplaint = false;
updated = true;
loadDetails();
}
public Maintenance()
{
InitializeComponent();
db1=new Water_Board_Management.Database("complaint","referenceNo");
db2 = new Water_Board_Management.Database("appeal", "referenceNo");
compRefs = db1.getColumn("referenceNo");
applRefs = db2.getColumn("referenceNo");
conv = new Water_Board_Management_HelpDesk.Converter();
isComplaint = false;
updated = true;
loadDetails();
}
public HelpDesk()
{
InitializeComponent();
accountNo = 1258489;
isCustomer = true;
//isCustomer = false;
cdb = new Converter();
db = new Water_Board_Management.Database("complaint", "referenceNo");
db2 = new Water_Board_Management.Database("appeal", "referenceNo");
db3 = new Water_Board_Management.Database("account", "accountNo");
db4 = new Water_Board_Management.Database("account", "refno");
db5 = new Water_Board_Management.Database("inprogress", "refno");
}
public HelpDesk()
{
InitializeComponent();
accountNo = 1258489;
isCustomer = true;
//isCustomer = false;
cdb = new Converter();
db = new Water_Board_Management.Database("complaint", "referenceNo");
db2 = new Water_Board_Management.Database("appeal", "referenceNo");
db3 = new Water_Board_Management.Database("account", "accountNo");
db4 = new Water_Board_Management.Database("account", "refno");
db5=new Water_Board_Management.Database("inprogress","refno");
}
public HelpDesk(int id, int acctNo)
{
InitializeComponent();
accountNo = acctNo;
if (id == 1)
isCustomer = true;
else
isCustomer = false;
cdb = new Converter();
db = new Water_Board_Management.Database("complaint", "referenceNo");
db2 = new Water_Board_Management.Database("appeal", "referenceNo");
db3 = new Water_Board_Management.Database("account", "accountNo");
db4 = new Water_Board_Management.Database("account", "refno");
db5 = new Water_Board_Management.Database("inprogress", "refNo");
}
//Retrieves the Complaint object with the given reference number from the database
public Complaint retComplaint(Water_Board_Management.Database d, String rn)
{
if (!(d.hasEntry(rn)))
{
return(null);
}
String[] det = d.getRow(rn);
Complaint temp = new Complaint(Int32.Parse(det[0]), Int32.Parse(det[1]), det[2], det[3], det[4], det[6]);
if (det[5].Equals("True"))
{
temp.complete();
temp.setComplete(det[7]);
}
temp.setProgress(det[8]);
temp.setPriority(Int32.Parse(det[9]));
return(temp);
}
private void comboBox7_TextChanged(object sender, EventArgs e)
{
string str;
db = new Water_Board_Management.Database("a" + accountNumber, "month");
str = comboBox1.Text + "/" + comboBox7.Text;
if (db.hasEntry(str) == true)
{
label11.Text = db.get("units", str);
label12.Text = "Rs. " + db.get("amount", str);
}
else if (comboBox7.Text == "")
{
}
else
{
label11.Text = "N/A";
label12.Text = "N/A";
}
}
public HelpDesk(int id, int acctNo)
{
InitializeComponent();
accountNo = acctNo;
if (id == 1)
{
isCustomer = true;
}
else
{
isCustomer = false;
}
cdb = new Converter();
db = new Water_Board_Management.Database("complaint", "referenceNo");
db2 = new Water_Board_Management.Database("appeal", "referenceNo");
db3 = new Water_Board_Management.Database("account", "accountNo");
db4 = new Water_Board_Management.Database("account", "refno");
db5 = new Water_Board_Management.Database("inprogress", "refNo");
}
private void loadDetails(Water_Board_Management.Database d, String key)
{
if (d.hasEntry(key))
{
original[0] = d.get("mail", key);
String con = d.get("contact", key);
while (con.Length != 10)
{
con = "0" + con;
}
original[1] = con;
original[2] = d.get("email", key);
button2.Enabled = button3.Enabled = true;
}
else
{
original[0] = "No such record found. Please check whether the reference/account number is correct";
original[1] = "";
original[2] = "";
button2.Enabled = button3.Enabled = false;
}
}
//Retrieves the Appeal object with the given reference number from the database
public Appeal retAppeal(Water_Board_Management.Database d, String rn)
{
if (!(d.hasEntry(rn)))
{
return(null);
}
String[] det = d.getRow(rn);
Appeal temp = new Appeal(Int32.Parse(det[0]), Int32.Parse(det[1]), det[2], det[3], det[6]);
if (det[5].Equals("True"))
{
temp.complete();
temp.setComplete(det[7]);
}
if (det[9].Equals("True"))
{
temp.validate();
}
temp.setAdditional(det[4]);
temp.setProgress(det[8]);
return(temp);
}
private void comboBox5_TextChanged(object sender, EventArgs e)
{
button21_Click(sender, e);
string str;
dbC = new Water_Board_Management.Database("a" + textBox7.Text, "month");
str = comboBox5.Text + "/" + comboBox6.Text;
if (dbC.hasEntry(str) == true)
{
label41.Text = dbC.get("units", str);
label42.Text = "Rs. " + dbC.get("amount", str);
label43.Text = dbC.get("remarks", str);
}
else if (comboBox6.Text == "")
{
}
else
{
label41.Text = "N/A";
label42.Text = "N/A";
label43.Text = "N/A";
}
}
//Generates a reference number for new complaint or new appeal (n=0 for complaint, 1 for appeal)
private int genRefNo(int n)
{
int r;
Random rn = new Random();
r = rn.Next(0, 100000);
Water_Board_Management.Database tempD = db;
if (n == 0)
{
tempD = db;
}
else if (n == 1)
{
tempD = db2;
}
while (tempD.hasEntry(r.ToString()))
{
r = rn.Next(0, 100000);
}
return(r);
}
//Stores an Appeal object in the database
public void storeAppeal(Water_Board_Management.Database d, Appeal apl)
{
Water_Board_Management.AppealRow ar = new Water_Board_Management.AppealRow(apl.getReference(), apl.getAccount(), apl.getType(), apl.getSub(), apl.getAdd(), apl.isCompleted(), apl.getSubmit(), apl.getComplete(), apl.getProgress(), apl.isValidated());
d.insert(ar);
}
private void button19_Click(object sender, EventArgs e)
{
button20_Click(sender, e);
if (comboBox3.Text == "")
{
errorProvider1.SetError(comboBox3, "Select A Month");
}
else
{
errorProvider1.Dispose();
}
if (comboBox4.Text == "")
{
errorProvider1.SetError(comboBox4, "Select A Year");
}
else
{
errorProvider1.Dispose();
}
if (textBox3.Text == "")
{
errorProvider1.SetError(textBox3, "Enter a valide number");
}
else if (Convert.ToInt32(textBox3.Text) < 0)
{
errorProvider1.SetError(textBox3, "Enter a valide number");
}
else
{
errorProvider1.Dispose();
double result = calculate(textBox3.Text, label28.Text);
label26.Text = "Rs. " + Convert.ToString(result);
int units = Convert.ToInt32(textBox3.Text);
double amount = result;
bill = new bill(comboBox3.Text, comboBox4.Text, units, amount, textBox5.Text);
dbEntry = new Water_Board_Management.Database("a" + textBox2.Text, "month");
if (dbEntry.hasEntry(bill.getMonth()) == true)
{
if (MessageBox.Show("Do you want to update the data?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
dbEntry.updateMany(new String[] { "units", "amount", "remarks" }, bill.getMonth(), new String[] { Convert.ToString(bill.getUnits()), Convert.ToString(bill.getAmount()), bill.getRemarks() });
MessageBox.Show("Successfully Updated Data");
textBox3.Text = "";
label26.Text = "";
textBox5.Text = "";
}
}
else
{
dbEntry.insert(new Water_Board_Management.BillingRow(bill.getMonth(), bill.getUnits(), bill.getAmount(), bill.getRemarks()));
MessageBox.Show("Successfully Entered Data");
textBox3.Text = "";
label26.Text = "";
textBox5.Text = "";
}
if (dbBUlk.hasEntry(bill.getMonth()) == true)
{
int usage;
usage = Convert.ToInt32(dbBUlk.get("usag", bill.getMonth()));
usage += bill.getUnits();
dbBUlk.update("usag", bill.getMonth(), Convert.ToString(usage));
}
else
{
dbBUlk.insert(new Water_Board_Management.MeterRow(bill.getMonth(), 0, bill.getUnits()));
}
}
}
//Stores a Complaint object in the database
public void storeComplaint(Water_Board_Management.Database d, Complaint cmp)
{
Water_Board_Management.ComplaintRow cr = new Water_Board_Management.ComplaintRow(cmp.getReference(), cmp.getAccount(), cmp.getType(), cmp.getSub(), cmp.getAdd(), cmp.isCompleted(), cmp.getSubmit(), cmp.getComplete(), cmp.getProgress(), cmp.getPriority());
d.insert(cr);
}
private void comboBox7_TextChanged(object sender, EventArgs e)
{
string str;
db = new Water_Board_Management.Database("a" + accountNumber, "month");
str = comboBox1.Text + "/" + comboBox7.Text;
if (db.hasEntry(str) == true)
{
label11.Text = db.get("units", str);
label12.Text = "Rs. " + db.get("amount", str);
}
else if (comboBox7.Text == "")
{
}
else
{
label11.Text = "N/A";
label12.Text = "N/A";
}
}
private void comboBox5_TextChanged(object sender, EventArgs e)
{
button21_Click(sender, e);
string str;
dbC = new Water_Board_Management.Database("a" + textBox7.Text, "month");
str = comboBox5.Text + "/" + comboBox6.Text;
if (dbC.hasEntry(str) == true)
{
label41.Text = dbC.get("units", str);
label42.Text = "Rs. " + dbC.get("amount", str);
label43.Text = dbC.get("remarks", str);
}
else if (comboBox6.Text == "")
{
}
else
{
label41.Text = "N/A";
label42.Text = "N/A";
label43.Text = "N/A";
}
}
private void button19_Click(object sender, EventArgs e)
{
button20_Click(sender, e);
if (comboBox3.Text == "")
{
errorProvider1.SetError(comboBox3, "Select A Month");
}
else
{
errorProvider1.Dispose();
}
if (comboBox4.Text == "")
{
errorProvider1.SetError(comboBox4, "Select A Year");
}
else
{
errorProvider1.Dispose();
}
if (textBox3.Text == "")
{
errorProvider1.SetError(textBox3, "Enter a valide number");
}
else if (Convert.ToInt32(textBox3.Text) < 0)
{
errorProvider1.SetError(textBox3, "Enter a valide number");
}
else
{
errorProvider1.Dispose();
double result = calculate(textBox3.Text, label28.Text);
label26.Text = "Rs. " + Convert.ToString(result);
int units = Convert.ToInt32(textBox3.Text);
double amount = result;
bill = new bill(comboBox3.Text, comboBox4.Text, units, amount, textBox5.Text);
dbEntry = new Water_Board_Management.Database("a" + textBox2.Text, "month");
if (dbEntry.hasEntry(bill.getMonth()) == true)
{
if (MessageBox.Show("Do you want to update the data?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
dbEntry.updateMany(new String[] { "units", "amount", "remarks" }, bill.getMonth(), new String[] { Convert.ToString(bill.getUnits()), Convert.ToString(bill.getAmount()), bill.getRemarks() });
MessageBox.Show("Successfully Updated Data");
textBox3.Text = "";
label26.Text = "";
textBox5.Text = "";
}
}
else
{
dbEntry.insert(new Water_Board_Management.BillingRow(bill.getMonth(), bill.getUnits(), bill.getAmount(), bill.getRemarks()));
MessageBox.Show("Successfully Entered Data");
textBox3.Text = "";
label26.Text = "";
textBox5.Text = "";
}
if (dbBUlk.hasEntry(bill.getMonth()) == true)
{
int usage;
usage = Convert.ToInt32(dbBUlk.get("usag", bill.getMonth()));
usage += bill.getUnits();
dbBUlk.update("usag", bill.getMonth(), Convert.ToString(usage));
}
else
{
dbBUlk.insert(new Water_Board_Management.MeterRow(bill.getMonth(), 0, bill.getUnits()));
}
}
}
