private void AddButton_Click(object sender, EventArgs e)
{
if (NameTextBox.Text != "" && MobileNoTextBox.Text != "" && AddressTextBox.Text != "")
{
if (MobileNoTextBox.Text.All(char.IsDigit) && MobileNoTextBox.Text.Length == 11 && (MobileNoTextBox.Text.StartsWith("017") || MobileNoTextBox.Text.StartsWith("016") ||
MobileNoTextBox.Text.StartsWith("015") || MobileNoTextBox.Text.StartsWith("019") || MobileNoTextBox.Text.StartsWith("018")))
{
var s = from ob in DB.Modifieds
where ob.Mobile_No == MobileNoTextBox.Text
select ob;
if (s != null)
{
OwnerTenant a = new OwnerTenant();
Tenant t = new Tenant();
Modified m = new Modified();
t.Name = NameTextBox.Text;
t.Mobile_No = MobileNoTextBox.Text;
t.Keyword = "T";
DB.Tenants.InsertOnSubmit(t);
DB.SubmitChanges();
m.Mobile_No = MobileNoTextBox.Text;
m.Keyword = "T";
DB.Modifieds.InsertOnSubmit(m);
DB.SubmitChanges();
a.Name = NameTextBox.Text;
a.Name = NameTextBox.Text;
a.Mobile_No = MobileNoTextBox.Text;
a.Address = AddressTextBox.Text;
DB.OwnerTenants.InsertOnSubmit(a);
DB.SubmitChanges();
MessageBox.Show("Added Successfully!");
}
else
{
MessageBox.Show("Your mobile number has already been recorded in database, try with another mobile no");
}
}
else
{
MessageBox.Show("Please input every field correctly");
}
}
else
{
MessageBox.Show("Please input every field");
}
}
private void SearchButton_Click(object sender, EventArgs e)
{
String id = SearchByMobileNoTextBox.Text;
OwnerTenant s = DB.OwnerTenants.SingleOrDefault(x => x.Mobile_No == id);
if (s != null)
{
NameTextBox.Text = s.Name;
MobileNoTextBox.Text = s.Mobile_No;
AddressTextBox.Text = s.Address;
}
else
{
MessageBox.Show("Not found");
}
}
private void UpdateButton_Click(object sender, EventArgs e)
{
if (NameTextBox.Text != "" && MobileNoTextBox.Text != "" && AddressTextBox.Text != "")
{
if (MobileNoTextBox.Text.All(char.IsDigit) && MobileNoTextBox.Text.Length == 11 && (MobileNoTextBox.Text.StartsWith("017") || MobileNoTextBox.Text.StartsWith("016") ||
MobileNoTextBox.Text.StartsWith("015") || MobileNoTextBox.Text.StartsWith("019") || MobileNoTextBox.Text.StartsWith("018")))
{
String id = SearchByMobileNoTextBox.Text;
OwnerTenant s = DB.OwnerTenants.SingleOrDefault(x => x.Mobile_No == id);
if (s != null)
{
s.Name = NameTextBox.Text;
s.Mobile_No = MobileNoTextBox.Text;
s.Address = AddressTextBox.Text;
DB.SubmitChanges();
}
String sid = SearchByMobileNoTextBox.Text;
Tenant ts = DB.Tenants.SingleOrDefault(x => x.Mobile_No == sid);
if (ts != null)
{
ts.Name = NameTextBox.Text;
ts.Mobile_No = MobileNoTextBox.Text;
ts.Address = AddressTextBox.Text;
DB.SubmitChanges();
MessageBox.Show("Update Successful!");
}
else
{
MessageBox.Show("Not found");
}
}
else
{
MessageBox.Show("Please input every field correctly");
}
}
else
{
MessageBox.Show("Please input every field");
}
}
private void DeleteButton_Click(object sender, EventArgs e)
{
String id = SearchTextBox.Text;
OwnerTenant s = DB.OwnerTenants.SingleOrDefault(x => x.Mobile_No == id);
if (s != null)
{
DB.OwnerTenants.DeleteOnSubmit(s);
DB.SubmitChanges();
HouseInformationForm sodf = new HouseInformationForm();
sodf.Show();
Close();
Dispose();
}
else
{
MessageBox.Show("Data not found");
}
}
partial void DeleteOwnerTenant(OwnerTenant instance);
partial void UpdateOwnerTenant(OwnerTenant instance);
partial void InsertOwnerTenant(OwnerTenant instance);