Esempio n. 1
0
 /*--------------------------Notification Saving ---------------------*/
 public void SaveNotification(NotificationBLL objNBLL)
 {
     query = "insert into Notification(Message) values('" + objNBLL.Message + "')";
     objDBManager.ExecuteNonQuery(query);
 }
Esempio n. 2
0
        /*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);
        }
Esempio n. 3
0
 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);
 }