/*--------------------------Notification Saving ---------------------*/ public void SaveNotification(NotificationBLL objNBLL) { query = "insert into Notification(Message) values('" + objNBLL.Message + "')"; objDBManager.ExecuteNonQuery(query); }
/*Supervisor Info*/ public void SaveUsers(DashboardBLL objDBLL) { query = "insert into Users (FirstName,LastName,Email,Password, UserName,UserType,Gender) values ( '" + objDBLL.FirstName + "','" + objDBLL.LastName + "','" + objDBLL.Email + "','" + objDBLL.Password + "','" + objDBLL.UserName + "','" + objDBLL.UserType + "','" + objDBLL.Gender + "')insert into Supervisors(ContactNo,Department,Info,UserID) values('" + objDBLL.ContactNo + "','" + objDBLL.Department + "','" + objDBLL.Info + "',SCOPE_IDENTITY())"; objDBManager.ExecuteNonQuery(query); }
public void SaveUser(UserBLL objUserBLL) { query = "insert into Users (FirstName,LastName,Email,Password, UserName,UserType,Gender) values ( '" + objUserBLL.FirstName + "','" + objUserBLL.LastName + "','" + objUserBLL.Email + "','" + objUserBLL.Password + "','" + objUserBLL.UserName + "','" + objUserBLL.UserType + "','" + objUserBLL.Gender + "')"; objDBManager.ExecuteNonQuery(query); }