public MainWindow()
{
InitializeComponent();
m_hostVM = new HostVM();
m_hostVM.Canvas = myCanvas;
m_hostVM.Host = this;
//myCanvas.Host = this;
this.DataContext = m_hostVM;
}
public int InsertOrUpdateHost(HostVM _obj)
{
int result = 0;
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("isp_host", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@hostId", _obj.hostId);
cmd.Parameters.AddWithValue("@hostName", _obj.hostName);
cmd.Parameters.AddWithValue("@hostAddress", _obj.hostAddress);
cmd.Parameters.AddWithValue("@hostPhone", _obj.hostPhone);
cmd.Parameters.AddWithValue("@isActive", _obj.isActive);
cmd.Parameters.AddWithValue("@createdBy", _obj.createdBy);
result = 1;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
return(result);
}
public HostVM GetHostById(int hostId)
{
HostVM _obj = new HostVM();
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("gsp_getHostById", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@hostId", hostId);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
_obj.hostId = Convert.ToInt16(rdr["hostId"]);
_obj.hostName = rdr["hostName"].ToString();
_obj.hostPhone = rdr["hostPhone"].ToString();
_obj.hostAddress = rdr["hostAddress"].ToString();
_obj.isActive = Convert.ToBoolean(rdr["isActive"]);
}
con.Close();
}
return(_obj);
}
