private void txtroomno_LostFocus(object sender, RoutedEventArgs e)
{
try
{
if (txtroomno.Text == null)
{
txtroomno.Text = "";
}
else if (txtroomno.Text.Length == 3)
{
blockroom br = new blockroom();
br.ROOM_NO = txtroomno.Text;
int A = br.Roomretrive();
if (A == 0)
{
txtroomtype.Text = br.ROOM_TYPE;
btnblock.IsEnabled = true; btnrelease.IsEnabled = true;
}
else if (A == 1)
{
DataTable d = br.RELEASE();
if (d != null)
{
txtroomno.Text = d.Rows[0]["ROOM_NO"].ToString();
txtroomtype.Text = d.Rows[0]["ROOM_CATEGORY"].ToString();
dpfromdate.Text = d.Rows[0]["FROM_DATE"].ToString();
dptodate.Text = d.Rows[0]["TO_DATE"].ToString();
int MA = Convert.ToInt16(d.Rows[0]["MAINTANCE"]);
if (MA == 0)
{
rbmaintance.IsChecked = false;
}
else if (MA == 1)
{
rbmaintance.IsChecked = true;
}
int MANA = Convert.ToInt16(d.Rows[0]["MANAGEMENT"]);
if (MANA == 0)
{
rbmanagement.IsChecked = false;
}
else if (MANA == 1)
{
rbmanagement.IsChecked = true;
}
int MA1 = Convert.ToInt16(d.Rows[0]["DIRTY"]);
if (MA1 == 0)
{
rbmaintance1.IsChecked = false;
}
else if (MA1 == 1)
{
rbmaintance1.IsChecked = true;
}
int MANA1 = Convert.ToInt16(d.Rows[0]["CLEAN"]);
if (MANA1 == 0)
{
rbmanagement1.IsChecked = false;
}
else if (MANA1 == 1)
{
rbmanagement1.IsChecked = true;
}
txtreason.Text = d.Rows[0]["REASON"].ToString();
//bind feteched data to textboxes .
btnblock.IsEnabled = true; btnrelease.IsEnabled = true;
}
else
{
//MessageBox.Show("The Room No is inavlid , please check again");
pop1.IsOpen = true;
btnblock.IsEnabled = false; btnrelease.IsEnabled = false;
}
// MessageBox.Show("The Room No Which you have entered is may be it is not vacant or incorrect");
pop1.IsOpen = true;
}
}
}
catch (Exception)
{
MessageBox.Show("Please Enter Valid Room No");
txtroomno.Foreground = Brushes.Red;
}
}
public void UPDATEINTO_DB()
{
if (error != 0)
{
pop1.IsOpen = true;
}
else
{
if (rbmaintance.IsChecked == true)
{
maintenance = "1";
}
else
{
maintenance = "0";
}
if (rbmanagement.IsChecked == true)
{
management = "1";
}
else
{
management = "0";
}
if (rbmaintance1.IsChecked == true)
{
maintenance1 = "1";
}
else
{
maintenance1 = "0";
}
if (rbmanagement1.IsChecked == true)
{
management1 = "1";
}
else
{
management1 = "0";
}
blockroom br = new blockroom();
br.ROOM_NO = txtroomno.Text;
br.ROOM_TYPE = txtroomtype.Text;
br.FROM_DATE = dpfromdate.Text;
br.TO_DATE = dptodate.Text;
br.MAINTANCE = maintenance.ToString();
br.MANAGEMENT = management.ToString();
br.MAINTANCE1 = maintenance1.ToString();
br.MANAGEMENT1 = management1.ToString();
br.REASON = txtreason.Text;
//11/15/2017
//br.USER_NAME = login.u;
br.INSERT_BY = login.u;
br.INSERT_DATE = DateTime.Today;
//
br.Insert();
clear();
disable();
btnblock.IsEnabled = true;
btnrelease.IsEnabled = true;
//btnsave.IsEnabled = false;
this.NavigationService.Refresh();
}
}
