public List <SubuserEntity> GetSubusers(DBSite site, int userId, string subuser_ids = "")
{
List <SubuserEntity> subuser_list = new List <SubuserEntity>();
SubuserEntity subuser = null;
string qry = "SELECT "
+ "SubuserId"
+ ", SubuserName"
+ ", SubuserCreationDate"
+ ", SubuserPassword"
+ ", EmailId"
+ ", Designation"
+ ", Address"
+ ", City"
+ ", Mobile"
+ ", Active"
+ ", UserId"
+ " FROM tblSubuser "
+ " WHERE userId=" + userId;
if (subuser_ids != "")
{
qry += " AND SubuserId IN ( " + subuser_ids + " )";
}
DataTable dt = site.ExecuteSelect(qry);
foreach (DataRow row in dt.Rows)
{
subuser = new SubuserEntity();
subuser.SubuserId = util.CheckNullInt(row["SubuserId"]);
subuser.SubuserName = util.CheckNull(row["SubuserName"]);
DateTime date = Convert.ToDateTime(row["SubuserCreationDate"]);
subuser.CreationDate = date.ToShortDateString();
subuser.Password = util.CheckNull(row["SubuserPassword"]);
subuser.EmailId = util.CheckNull(row["EmailId"]);
subuser.Designation = util.CheckNull(row["Designation"]);
subuser.Address = util.CheckNull(row["Address"]);
subuser.City = util.CheckNull(row["City"]);
subuser.Mobile = util.CheckNull(row["Mobile"]);
subuser.UserState = util.CheckNullInt(row["Active"]) == 1 ? "Yes" : "No";
subuser.Permissions = GetPermissions(site, subuser.SubuserId + "");
subuser.TeacherClasses = GetTeacherClasses(site, subuser.SubuserId + "");
subuser.TeacherSubjects = GetTeacherSubjects(site, subuser.SubuserId + "");
subuser_list.Add(subuser);
}
return(subuser_list);
}
public void EditSubuserInfo_stock(DBSite site, SubuserEntity subuser, string subuser_id)
{
string qry = " UPDATE tblSubuser SET "
+ "SubuserName = '******'"
+ ", SubuserCreationDate = '" + subuser.CreationDate + "'"
+ ", SubuserPassword = '******'"
+ ", EmailId = '" + subuser.EmailId + "'"
+ ", Designation = '" + subuser.Designation + "'"
+ ", Address = '" + subuser.Address + "'"
+ ", City = '" + subuser.City + "'"
+ ", Mobile = '" + subuser.Mobile + "'"
+ ", Active = " + subuser.UserState;
qry += " WHERE SubuserId=" + subuser_id;
site.Execute(qry); // ---- update subuser information ---------------
qry = " DELETE FROM tblUserPermissions"
+ " WHERE UserId=" + Util_BLL.User.UserId
+ " AND SubuserId=" + subuser_id;
site.Execute(qry); //------ Delete all permissions to selected Subuser ------
//----- update permissions to Subuser --------------------
foreach (Permission permission in subuser.Permissions)
{
qry = " INSERT INTO tblUserPermissions"
+ "("
+ "UserId"
+ ", SubuserId"
+ ", PermissionId"
+ ")"
+ " VALUES("
+ Util_BLL.User.UserId //------ user id of Current User --------
+ ", " + subuser_id
+ ", " + permission.PermissionId
+ ")";
site.Execute(qry);
}
}
//-------------- savew subuser information -----------------
public void SaveSubuserInfo(DBSite site, SubuserEntity subuser)
{
int user_state = subuser.UserState == "1" ? 1 : 0;
string subuser_info_qry = " INSERT INTO tblSubuser ("
+ "SubuserName"
+ ", SubuserCreationDate"
+ ", SubuserPassword"
+ ", EmailId"
+ ", Designation"
+ ", Address"
+ ", City"
+ ", Mobile"
+ ", Active"
+ ", UserId"
+ ")";
subuser_info_qry += " VALUES ("
+ "'" + subuser.SubuserName + "'"
+ ", '" + subuser.CreationDate + "'"
+ ", '" + subuser.Password + "'"
+ ", '" + subuser.EmailId + "'"
+ ", '" + subuser.Designation + "'"
+ ", '" + subuser.Address + "'"
+ ", '" + subuser.City + "'"
+ ", '" + subuser.Mobile + "'"
+ ", " + user_state
+ ", " + Util_BLL.User.UserId //---- User ID in Currently Logged In ---------------
+ " )";
site.Execute(subuser_info_qry); //------------ Enter subuser information ------------------
subuser_info_qry = " SELECT SubuserId FROM tblSubuser"
+ " WHERE EmailId='" + subuser.EmailId + "'"
+ " AND UserId=" + Util_BLL.User.UserId;
string subuser_id = util.CheckNull(site.ExecuteSelect(subuser_info_qry).Rows[0]["SubuserId"]); //-- subuserId query --------------
foreach (Permission permission in subuser.Permissions)
{
subuser_info_qry = " INSERT INTO tblUserPermissions"
+ "("
+ "UserId"
+ ", SubuserId"
+ ", PermissionId"
+ ")"
+ " VALUES("
+ Util_BLL.User.UserId //------ user id of Current User --------
+ ", " + subuser_id
+ ", " + permission.PermissionId
+ ")";
site.Execute(subuser_info_qry);
}
foreach (ClassMasterBLL.ClassMasterEntity clas in subuser.TeacherClasses)
{
subuser_info_qry = " INSERT INTO tblTeacherClasses"
+ "("
+ "UserId"
+ ", SubuserId"
+ ", ClassId"
+ ")"
+ " VALUES("
+ Util_BLL.User.UserId //------ user id of Current User --------
+ ", " + subuser_id
+ ", " + clas.ClassMasterId
+ ")";
site.Execute(subuser_info_qry);
}
foreach (SubjectMasterBLL.SubjectMasterEntity sub in subuser.TeacherSubjects)
{
subuser_info_qry = " INSERT INTO tblTeacherSubjects"
+ "("
+ "UserId"
+ ", SubuserId"
+ ", SubjectId"
+ ")"
+ " VALUES("
+ Util_BLL.User.UserId
+ ", " + subuser_id
+ ", " + sub.SubjectMasterId
+ ")";
site.Execute(subuser_info_qry);
}
}
