public static STD_Room GetSTD_RoomByRoomID(int RoomID)
{
STD_Room sTD_Room = new STD_Room();
SqlSTD_RoomProvider sqlSTD_RoomProvider = new SqlSTD_RoomProvider();
sTD_Room = sqlSTD_RoomProvider.GetSTD_RoomByRoomID(RoomID);
return sTD_Room;
}
public static STD_Room GetSTD_CampusByCampusID(int CampusID)
{
STD_Room sTD_Room = new STD_Room();
SqlSTD_RoomProvider sqlSTD_RoomProvider = new SqlSTD_RoomProvider();
sTD_Room = sqlSTD_RoomProvider.GetSTD_RoomByCampusID(CampusID);
return sTD_Room;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
STD_Room sTD_Room = new STD_Room ();
sTD_Room.RoomID= int.Parse(Request.QueryString["ID"].ToString());
sTD_Room.CampusID= int.Parse(ddlCampusID.SelectedValue);
sTD_Room.RoomName= txtRoomName.Text;
sTD_Room.Description= txtDescription.Text;
sTD_Room.AddedBy= Profile.card_id;
sTD_Room.AddedDate= DateTime.Now;
sTD_Room.UpdatedBy= Profile.card_id;
sTD_Room.UpdateDate = DateTime.Now;
bool resutl =STD_RoomManager.UpdateSTD_Room(sTD_Room);
}catch(Exception ex){}Response.Redirect("AdminDisplaySTD_Room.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
STD_Room sTD_Room = new STD_Room ();
// sTD_Room.RoomID= int.Parse(ddlRoomID.SelectedValue);
sTD_Room.CampusID= int.Parse(ddlCampusID.SelectedValue);
sTD_Room.RoomName= txtRoomName.Text;
sTD_Room.Description= txtDescription.Text;
sTD_Room.AddedBy= Profile.card_id;
sTD_Room.AddedDate= DateTime.Now;
sTD_Room.UpdatedBy= Profile.card_id;
sTD_Room.UpdateDate = DateTime.Now;
int resutl =STD_RoomManager.InsertSTD_Room(sTD_Room);
}catch(Exception ex){}Response.Redirect("AdminDisplaySTD_Room.aspx");
}
public static int InsertSTD_Room(STD_Room sTD_Room)
{
SqlSTD_RoomProvider sqlSTD_RoomProvider = new SqlSTD_RoomProvider();
return sqlSTD_RoomProvider.InsertSTD_Room(sTD_Room);
}
public static bool UpdateSTD_Room(STD_Room sTD_Room)
{
SqlSTD_RoomProvider sqlSTD_RoomProvider = new SqlSTD_RoomProvider();
return sqlSTD_RoomProvider.UpdateSTD_Room(sTD_Room);
}
private void showSTD_RoomData()
{
STD_Room sTD_Room = new STD_Room ();
sTD_Room = STD_RoomManager.GetSTD_RoomByRoomID(Int32.Parse(Request.QueryString["ID"]));
ddlCampusID.SelectedValue =sTD_Room.CampusID.ToString();
txtRoomName.Text =sTD_Room.RoomName.ToString();
txtDescription.Text =sTD_Room.Description.ToString();
}
public bool UpdateSTD_Room(STD_Room sTD_Room)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateSTD_Room", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RoomID", SqlDbType.Int).Value = sTD_Room.RoomID;
cmd.Parameters.Add("@CampusID", SqlDbType.Int).Value = sTD_Room.CampusID;
cmd.Parameters.Add("@RoomName", SqlDbType.NVarChar).Value = sTD_Room.RoomName;
cmd.Parameters.Add("@Description", SqlDbType.NText).Value = sTD_Room.Description;
//cmd.Parameters.Add("@Description", SqlDbType.NText).Value = sTD_Room.Description;
//cmd.Parameters.Add("@Description", SqlDbType.NText).Value = sTD_Room.Description;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_Room.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = sTD_Room.UpdateDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public STD_Room GetSTD_RoomFromReader(IDataReader reader)
{
try
{
STD_Room sTD_Room = new STD_Room
(
DataAccessObject.IsNULL<int>(reader["RoomID"]),
DataAccessObject.IsNULL<int>(reader["CampusID"]),
DataAccessObject.IsNULL<string>(reader["RoomName"]),
DataAccessObject.IsNULL<string>(reader["Description"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"])
);
return sTD_Room;
}
catch(Exception ex)
{
return null;
}
}
