private void button1_Click(object sender, EventArgs e)
{
if (txtEmail.Enabled == true)
{
Contacts.Service1 sr = new Contacts.Service1();
lblShow.Text = sr.RecoverPwdE(txtEmail.Text);
if (lblShow.Text != "invalid user or User no Registered with this email")
{
SendEmailAdmin(txtEmail.Text, lblShow.Text);
MessageBox.Show("Password has been sent by Email.");
}
}
else
{
Contacts.Service1 sr2 = new Contacts.Service1();
lblShow.Text = sr2.RecoverPwdS(txtSMS.Text);
if (txtSMS.Text.Trim().Length == 13)
{
RecPwdbySMS sm = new RecPwdbySMS();
sm.SetComPort("com4");
sm.Opens();
sm.RecoverPwdbySMS(txtSMS.Text, lblShow.Text);
sm.Closes();
MessageBox.Show("Password has been sent by SMS.");
}
}
}
private void btn_login_Click(object sender, EventArgs e)
{
bool isvalidUser = false;
bool isvalidPwd = false;
Contacts.Service1 ser = new Contacts.Service1();
string curUsris = "";
ser.IsValidUser(txt_user.Text, txt_pwd.Text, ref curUsris, out isvalidUser, out isvalidPwd);
if (isvalidUser)
{
lblMsg.Text = "valid user";
myUser u = new myUser();
u.Userid = curUsris;
DataClass.usersCurrent.Add(u);
foreach (myUser ux in DataClass.usersCurrent)
{
myUtill.loginUser = ux;
}
MyPanel pnl = new MyPanel();
pnl.ShowDialog();
}
else
{
MessageBox.Show("invalid user");
}
//Boolean isFound = false;
//foreach (myUser u in DataClass.usersArrayList)
//{
// if (u.Username == txt_user.Text && u.Userpwd == txt_pwd.Text)
// {
// isFound = true;
// MyUtill.loginUser = u;
// }
//}
//if (isFound)
//{
// lblMsg.Text = "valid user";
//FrmContacts log = new FrmContacts();
//this.Hide();
//log.Show();
//}
//else
//{
// lblMsg.Text = "invalid user";
//}
}
private void btnSend_Click(object sender, EventArgs e)
{
if (comboBox1.Items.Count == 0)
{
MessageBox.Show("Add Group Please !"); return;
}
Contacts.Service1 sr2 = new Contacts.Service1();
BindingSource b = new BindingSource();
b.DataSource = sr2.SSTC(myUtill.loginUser.Userid, comboBox1.SelectedValue.ToString());
foreach (DataGridViewRow gv in gvSMS.Rows)
{
string s = gv.Cells[3].Value.ToString();
{
RecPwdbySMS sm = new RecPwdbySMS();
sm.SetComPort("com4");
sm.Opens();
sm.RecoverPwdbySMS(s, textBox1.Text.Trim());
sm.Closes();
}
System.Threading.Thread.Sleep(10000);
}
MessageBox.Show("Your message has been sent");
}
private void button2_Click(object sender, EventArgs e)
{
Contacts.Service1 ser = new Contacts.Service1();
BindingSource b = new BindingSource();
b.DataSource = ser.SearchCbyEmail(myUtill.loginUser.Userid, cmbCon.SelectedValue.ToString(), txtEMAIL.Text);
gvCon.DataSource = b;
}
private void populate()
{
Contacts.Service1 ser = new Contacts.Service1();
BindingSource bs = new BindingSource();
bs.DataSource = ser.GetData(myUtill.loginUser.Userid);
gvGrp.DataSource = bs;
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
Contacts.Service1 ser = new Contacts.Service1();
BindingSource bs = new BindingSource();
bs.DataSource = ser.ShowContactsSMS(myUtill.loginUser.Userid, comboBox1.SelectedValue.ToString());
gvSMS.DataSource = bs;
}
private void frmain_Load(object sender, EventArgs e)
{
gvUsers.AutoGenerateColumns = false;
Contacts.Service1 s = new Contacts.Service1();
BindingSource b = new BindingSource();
b.DataSource = s.GetUser();
gvUsers.DataSource = b;
}
private void btnClr_Click(object sender, EventArgs e)
{
Contacts.Service1 ser = new Contacts.Service1();
BindingSource b = new BindingSource();
b.DataSource = ser.GetCon();
gvCon.DataSource = b;
}
private void MyContact_Load(object sender, EventArgs e)
{
Contacts.Service1 ser = new Contacts.Service1();
BindingSource bs = new BindingSource();
bs.DataSource = ser.GetData(myUtill.loginUser.Userid);
cmbCon.ValueMember = "grpId";
cmbCon.DisplayMember = "grpName";
cmbCon.DataSource = bs;
}
private void btnSMob_Click(object sender, EventArgs e)
{
Contacts.Service1 ser = new Contacts.Service1();
//ser.SearchContacts(myUtill.loginUser.Userid,cmbCon.SelectedValue.ToString(), txtName.Text);
BindingSource b = new BindingSource();
b.DataSource = ser.SearchCbyMob(myUtill.loginUser.Userid, cmbCon.SelectedValue.ToString(), txtMOB.Text);
gvCon.DataSource = b;
}
private void button2_Click(object sender, EventArgs e)
{
Contacts.Service1 sr = new Contacts.Service1();
lblShow.Text = sr.RecoverPwdE(txtEmail.Text);
if (lblShow.Text != "invalid user or User no Registered with this email")
{
SendEmailAdmin(txtEmail.Text, lblShow.Text);
}
// SendEmailAdmin(txtEmail.Text, "lblShow.Text");
}
private void optContacts_CheckedChanged(object sender, EventArgs e)
{
if (optContacts.Enabled == true)
{
Contacts.Service1 ser = new Contacts.Service1();
BindingSource bs = new BindingSource();
bs.DataSource = ser.ShowAllContacts
(myUtill.loginUser.Userid, comboBox1.SelectedValue.ToString());
gvSMS.DataSource = bs;
}
}
private void btnChange_Click(object sender, EventArgs e)
{
bool pwd = false;
bool RePwd = false;
Contacts.Service1 ser = new Contacts.Service1();
ser.ChangePwd(myUtill.loginUser.Userid, txtOldPwd.Text, txtNewPwd.Text, txtRePwd.Text, out pwd, out RePwd);
bool ret = ChangePwd(myUtill.loginUser.Userid, txtOldPwd, txtNewPwd, txtRePwd);
MessageBox.Show("Password Changed Successfully");
}
private void btn_del_Click(object sender, EventArgs e)
{
bool DelCon;
bool DelConR;
Contacts.Service1 s = new Contacts.Service1();
s.DeleteContact(txtId.Text, out DelCon, out DelConR);
BindingSource bs = new BindingSource();
bs.DataSource = s.GetCon();
gvCon.DataSource = bs;
lblmsg.Text = "Successfully Deleted";
}
private void btn_update_Click(object sender, EventArgs e)
{
bool updateCon;
bool updateConR;
Contacts.Service1 s = new Contacts.Service1();
s.UpdateContacts(txtId.Text, txtName.Text, txtDOB.Text,
txtMOB.Text, txtEMAIL.Text, txtADR.Text, out updateCon, out updateConR);
BindingSource bs = new BindingSource();
bs.DataSource = s.GetCon();
gvCon.DataSource = bs;
lblmsg.Text = "Successfully Updated ";
}
private void btnDel_Click(object sender, EventArgs e)
{
gvGrp.AutoGenerateColumns = false;
txtId.Enabled = true;
bool delGrp;
bool delGrpRes;
Contacts.Service1 ser = new Contacts.Service1();
ser.DeleteGroup(txtId.Text, out delGrp, out delGrpRes);
BindingSource bs = new BindingSource();
bs.DataSource = ser.GetData(myUtill.loginUser.Userid);
gvGrp.DataSource = bs;
lblmsg.Text = "deleted successfully";
}
private void btn_add_Click(object sender, EventArgs e)
{
if (cmbCon.Items.Count == 0)
{
MessageBox.Show("Add Group Please !"); return;
}
bool addConR;
bool AddCons;
Contacts.Service1 s = new Contacts.Service1();
s.AddContact(myUtill.loginUser.Userid, cmbCon.SelectedValue.ToString(), txtName.Text, txtDOB.Text, txtMOB.Text, txtEMAIL.Text, txtADR.Text, out addConR, out AddCons);
BindingSource b = new BindingSource();
b.DataSource = s.GetCon();
gvCon.DataSource = b;
lblmsg.Text = "Successfully Added";
}
private void btnUpdate_Click(object sender, EventArgs e)
{
gvGrp.AutoGenerateColumns = false;
txtId.Enabled = true;
bool sgrp = false;
bool rgrp = false;
Contacts.Service1 ser = new Contacts.Service1();
string grp = ser.grpCreator(myUtill.loginUser.Userid);
ser.UpdateGroup(txtId.Text, txtGrp.Text, grp, out sgrp, out rgrp);
BindingSource bs = new BindingSource();
bs.DataSource = ser.GetData(myUtill.loginUser.Userid);
gvGrp.DataSource = bs;
lblmsg.Text = "Successfully Updated ";
}
private void MyGroups_Load(object sender, EventArgs e)
{
populate();
int _r = 0;
foreach (DataGridViewRow gv in gvGrp.Rows)
{
_r++;
string s = gv.Cells[2].Value.ToString();
Contacts.Service1 se = new Contacts.Service1();
string g = se.grpCreator(s);
//gv.Cells[2].Value = g;
if (_r < gvGrp.Rows.Count - 1)
{
//gvGrp.Rows[_r].Cells[2].Value = g;
}
}
}
private void btn_reg_Click(object sender, EventArgs e)
{
Contacts.Service1 ser = new Contacts.Service1();
ser.IsUserRegister(txtUsr.Text, txtPwd.Text, txtEm.Text, txtCell.Text);
if (txtUsr.Text.Length == 0)
{
txtUsr.Focus();
return;
}
txtUsr.Text = "";
txtPwd.Text = "";
txtEm.Text = "";
txtCell.Text = "";
MessageBox.Show("User has been register");
txtUsr.Focus();
}
private void btnAdd_Click(object sender, EventArgs e)
{
gvGrp.AutoGenerateColumns = false;
bool addResult;
bool addGrp;
string _CurUserId = myUtill.loginUser.Userid;
Contacts.Service1 ser = new Contacts.Service1();
string grp = ser.grpCreator(myUtill.loginUser.Userid);
ser.AddGroup(txtGrp.Text, ref _CurUserId, grp, out addResult, out addGrp);
if (addResult == true)
{
lblmsg.Text = "Group Added";
}
else
{
lblmsg.Text = "Adding Failed !";
}
BindingSource bs = new BindingSource();
bs.DataSource = ser.GetData(myUtill.loginUser.Userid);
gvGrp.DataSource = bs;
//populate();
int _r = 0;
foreach (DataGridViewRow gv in gvGrp.Rows)
{
_r++;
string s = gv.Cells[2].Value.ToString();
Contacts.Service1 se = new Contacts.Service1();
string g = se.grpCreator(s);
gv.Cells[2].Value = g;
try { gvGrp.Rows[_r].Cells[2].Value = g; } catch (Exception ex) { }
}
}
private void button3_Click(object sender, EventArgs e)
{
if (cmbCon.Items.Count == 0)
{
MessageBox.Show("Add Group Please !"); return;
}
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
Excel.Range range;
string str;
int rCnt;
int rw = 0;
int cl = 0;
string filename = "";
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
filename = openFileDialog1.FileName;
}
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(filename, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
range = xlWorkSheet.UsedRange;
rw = range.Rows.Count;
cl = range.Columns.Count;
string _name = "";
string _mob = "";
string _address = "";
string _email = "";
string _dob = "";
for (rCnt = 1; rCnt <= rw; rCnt++)
{
//for (cCnt = 1; cCnt <= cl; )
{
_name = Convert.ToString((range.Cells[rCnt, 1] as Excel.Range).Value2);
_mob = "+" + Convert.ToString((range.Cells[rCnt, 2] as Excel.Range).Value2);
_dob = Convert.ToString((range.Cells[rCnt, 3] as Excel.Range).Value2);
_email = Convert.ToString((range.Cells[rCnt, 4] as Excel.Range).Value2);
_address = Convert.ToString((range.Cells[rCnt, 5] as Excel.Range).Value2);
str = _name + ", " + _mob + ", " + _dob;
Contacts.Service1 ser = new Contacts.Service1();
try
{
string sv = ser.ImportContacts(_name, _dob, _mob, _email, _address, myUtill.loginUser.Userid, cmbCon.SelectedValue.ToString());
} catch (Exception ex) { }
BindingSource b = new BindingSource();
b.DataSource = ser.GetCon();
gvCon.DataSource = b;
}
}
xlWorkBook.Close(true, null, null);
xlApp.Quit();
Marshal.ReleaseComObject(xlWorkSheet);
Marshal.ReleaseComObject(xlWorkBook);
Marshal.ReleaseComObject(xlApp);
}
