public List <AppPermission> getAllDefaultPermissions() { try { SqlCommand command = new SqlCommand("SELECT s.Mode,s.ALIAS,s.VALUE, 0 [ID],-1 [APPUSERID],s.ID [APPSETTINGID],4 [PERMISSION] FROM AppSettings s"); DataTable permissionData = DBServer.ExecuteDataTable(command); if (permissionData.Rows.Count == 0) { return(null); } return(permissionData.ConvertList <AppPermission>()); } catch (Exception ex) { throw ex; } }
public Products getById(int id) { try { SqlCommand command = new SqlCommand(String.Format("SELECT * FROM {0} WHERE ID=@ID AND ISDELETED=0", tableName)); command.Parameters.AddWithValue("@ID", id); DataTable productData = DBServer.ExecuteDataTable(command); if (productData.Rows.Count == 0) { return(null); } return(productData.Rows[0].Convert <Products>()); } catch (Exception ex) { throw ex; } }
public string getName(int id) { try { SqlCommand command = new SqlCommand(String.Format("SELECT * FROM {0} WHERE ID=@ID", tableName)); command.Parameters.AddWithValue("@ID", id); DataTable productData = DBServer.ExecuteDataTable(command); if (productData.Rows.Count == 0) { return(""); } return(productData.Rows[0]["NAME"].ToString()); } catch (Exception ex) { throw ex; } }
public AppUserInfo getUserSettingsById(int id) { try { SqlCommand command = new SqlCommand("SELECT * FROM USERSETTINGS WHERE ID=@ID"); command.Parameters.AddWithValue("@ID", id); DataTable userData = DBServer.ExecuteDataTable(command); if (userData.Rows.Count == 0) { return(null); } return(userData.Rows[0].Convert <AppUserInfo>()); } catch (Exception ex) { throw ex; } }
public AppNotification getById(int id) { try { SqlCommand command = new SqlCommand(String.Format("SELECT * FROM {0} WHERE ID=@ID", tableName)); command.Parameters.AddWithValue("@ID", id); DataTable notificationData = DBServer.ExecuteDataTable(command); if (notificationData.Rows.Count == 0) { return(null); } return(notificationData.Rows[0].Convert <AppNotification>()); } catch (Exception ex) { throw ex; } }
public AppUserInfo getUserInfoByUserId(int id) { try { SqlCommand command = new SqlCommand(String.Format("SELECT A.*,B.DisplayName,B.USERNAME AS EMAIL FROM APPUSERINFO A LEFT JOIN {0} B ON A.USID=B.ID WHERE A.USID=@ID", tableName)); command.Parameters.AddWithValue("@ID", id); DataTable userData = DBServer.ExecuteDataTable(command); if (userData.Rows.Count == 0) { return(null); } return(userData.Rows[0].Convert <AppUserInfo>()); } catch (Exception ex) { throw ex; } }
public AppUserAddOnConfig getConfigById(int id) { try { SqlCommand command = new SqlCommand(String.Format("SELECT * FROM {0} WHERE ID=@ID", configTableName)); command.Parameters.AddWithValue("@ID", id); DataTable userData = DBServer.ExecuteDataTable(command); if (userData.Rows.Count == 0) { return(null); } return(userData.Rows[0].Convert <AppUserAddOnConfig>()); } catch (Exception ex) { throw ex; } }
public AppUser getByUserName(string username) { try { SqlCommand command = new SqlCommand(String.Format("SELECT * FROM {0} WHERE USERNAME=@USERNAME AND ISDELETED=0", tableName)); command.Parameters.AddWithValue("@USERNAME", username); DataTable userData = DBServer.ExecuteDataTable(command); if (userData.Rows.Count == 0) { return(null); } return(userData.Rows[0].Convert <AppUser>()); } catch (Exception ex) { throw ex; } }
public ProductCategory[] getByCategoryId(int id) { try { SqlCommand command = new SqlCommand(String.Format("SELECT * FROM {0} WHERE CATEGORYID=@ID AND ISDELETED=0", tableName)); command.Parameters.AddWithValue("@ID", id); DataTable categoryData = DBServer.ExecuteDataTable(command); if (categoryData.Rows.Count == 0) { return(null); } return(categoryData.ConvertToArray <ProductCategory>()); } catch (Exception ex) { throw ex; } }
public AppUser SaveProfileImage(UserProfileImage Image) { try { SqlCommand command = new SqlCommand(String.Format("UPDATE {0} SET PROFILEIMG=@Image WHERE ID =@ID; SELECT * FROM APPUSER WHERE ID=@ID", tableName)); command.Parameters.AddWithValue("@ID", Image.ID); command.Parameters.AddWithValue("@Image", Image.PROFILEIMG); DataTable userData = DBServer.ExecuteDataTable(command); if (userData.Rows.Count == 0) { return(null); } return(userData.Rows[0].Convert <AppUser>()); } catch (Exception ex) { throw ex; } }
public List <AppPermission> getByUserId(int id, bool active = false) { try { SqlCommand command = new SqlCommand(String.Format(@"SELECT s.Mode,s.ALIAS,s.VALUE, ISNULL(p.ID,0) ID, ISNULL(p.APPUSERID,@ID) APPUSERID, ISNULL(p.APPSETTINGID,s.ID) APPSETTINGID, ISNULL(p.PERMISSION,0) PERMISSION FROM AppSettings s left join {0} p on s.id=p.appsettingid and p.APPUSERID=@ID WHERE s.TYPE='M' {1}", tableName, (active ? " p.PERMISSION=1 " : ""))); command.Parameters.AddWithValue("@ID", id); DataTable permissionData = DBServer.ExecuteDataTable(command); if (permissionData.Rows.Count == 0) { return(null); } return(permissionData.ConvertList <AppPermission>()); } catch (Exception ex) { throw ex; } }