public static List <IUser> GetUserList(bool isActiveOnly, SearchCriteria searchCriteria) { List <IUser> lstUser = new List <IUser>(); using (SqlDataHelper helper = new SqlDataHelper(ConnectionString)) { helper.CommandText = "[webadmin].[uspGetUser]"; helper.CommandType = CommandType.StoredProcedure; helper.Parameters.Add("@IsActiveOnly", isActiveOnly); helper.Parameters.Add("@SchUserName", searchCriteria.UserName); helper.Parameters.Add("@SchFirstName", searchCriteria.FirstName); helper.Parameters.Add("@SortExpression", searchCriteria.SortExpression); helper.Parameters.Add("@SortDirection", searchCriteria.SortDirection); helper.Open(); helper.ExecuteReader(CommandBehavior.CloseConnection); while (helper.DataReader.Read()) { IUser user = new UserEntity(helper.DataReader); lstUser.Add(user); } helper.Close(); } return(lstUser); }
public static IUser GetUser(int userId, bool isActiveOnly, SearchCriteria searchCriteria) { IUser user = null; using (SqlDataHelper helper = new SqlDataHelper(ConnectionString)) { helper.CommandText = "[webadmin].[uspGetUser]"; helper.CommandType = CommandType.StoredProcedure; helper.Parameters.Add("@UserId", userId); helper.Parameters.Add("@IsActiveOnly", isActiveOnly); helper.Parameters.Add("@SortExpression", searchCriteria.SortExpression); helper.Parameters.Add("@SortDirection", searchCriteria.SortDirection); helper.Open(); helper.ExecuteReader(CommandBehavior.CloseConnection); while (helper.DataReader.Read()) { user = new UserEntity(helper.DataReader); } helper.Close(); } return(user); }
public static List <IRole> GetRole(bool isActiveOnly, SearchCriteria searchCriteria) { List <IRole> lstRole = new List <IRole>(); using (SqlDataHelper helper = new SqlDataHelper(ConnectionString)) { helper.CommandText = "[webadmin].[uspGetRole]"; helper.CommandType = CommandType.StoredProcedure; helper.Parameters.Add("@IsActiveOnly", isActiveOnly); helper.Parameters.Add("@SchRole", searchCriteria.RoleName); helper.Parameters.Add("@SortExpression", searchCriteria.SortExpression); helper.Parameters.Add("@SortDirection", searchCriteria.SortDirection); helper.Open(); helper.ExecuteReader(CommandBehavior.CloseConnection); while (helper.DataReader.Read()) { IRole role = new RoleEntity(helper.DataReader); lstRole.Add(role); } helper.Close(); } return(lstRole); }
public static List <ReportEntity> GetCashierWiseSale(ReportCriteria criteria) { List <ReportEntity> lstData = new List <ReportEntity>(); using (SqlDataHelper helper = new SqlDataHelper(ConnectionString)) { helper.CommandText = "[dbo].[sp_rpt_CASHIERWISESALE]"; helper.CommandType = CommandType.StoredProcedure; helper.Parameters.Add("@Mode", criteria.CashierId); helper.Parameters.Add("@StartDate", criteria.FromDate); helper.Parameters.Add("@EndDate", criteria.ToDate); helper.Open(); helper.ExecuteReader(CommandBehavior.CloseConnection); while (helper.DataReader.Read()) { ReportEntity report = new ReportEntity(); report.LoadCashierWiseSale(helper.DataReader); lstData.Add(report); } helper.Close(); } return(lstData); }
public static List <ReportEntity> GetStockLedger(ReportCriteria criteria) { List <ReportEntity> lstData = new List <ReportEntity>(); using (SqlDataHelper helper = new SqlDataHelper(ConnectionString)) { helper.CommandText = "[rpt].[sp_rpt_STOCKREGISTER]"; helper.CommandType = CommandType.StoredProcedure; helper.Parameters.Add("@StartDate", criteria.FromDate); helper.Parameters.Add("@EndDate", criteria.ToDate); //helper.Parameters.Add("@Mode", criteria.FromDate); //helper.Parameters.Add("@OBDate", criteria.FromDate); //helper.Parameters.Add("@ItemCode", criteria.FromDate); helper.Open(); helper.ExecuteReader(CommandBehavior.CloseConnection); while (helper.DataReader.Read()) { ReportEntity report = new ReportEntity(helper.DataReader); report.LoadStockLedger(helper.DataReader); lstData.Add(report); } helper.Close(); } return(lstData); }
public static List <ReportEntity> GetBillWiseSaleRefund(ReportCriteria criteria) { List <ReportEntity> lstData = new List <ReportEntity>(); using (SqlDataHelper helper = new SqlDataHelper(ConnectionString)) { helper.CommandText = "[dbo].[sp_rpt_SALEREFUNDREGISTER]"; helper.CommandType = CommandType.StoredProcedure; helper.Parameters.Add("@TranType", criteria.TransactionType); helper.Parameters.Add("@StartDate", criteria.FromDate); helper.Parameters.Add("@EndDate", criteria.ToDate); helper.Open(); helper.ExecuteReader(CommandBehavior.CloseConnection); while (helper.DataReader.Read()) { ReportEntity report = new ReportEntity(); report.LoadBillWiseSaleRefund(helper.DataReader); lstData.Add(report); } helper.Close(); } return(lstData); }
public static List <IItemGroup> GetItemGroup(char mode, int lvl, Int64 userId) { List <IItemGroup> lstGroup = new List <IItemGroup>(); using (SqlDataHelper helper = new SqlDataHelper(ConnectionString)) { helper.CommandText = "[dbo].[sp_Manage_ITEMGROUP]"; helper.CommandType = CommandType.StoredProcedure; helper.Parameters.Add("@Mode", mode); helper.Parameters.Add("@UserID", userId); helper.Parameters.Add("@Lvl", lvl); helper.Parameters.Add("@Result", SqlDbType.Int, ParameterDirection.Output); helper.Open(); helper.ExecuteReader(CommandBehavior.CloseConnection); while (helper.DataReader.Read()) { IItemGroup group = new ItemGroupEntity(helper.DataReader); lstGroup.Add(group); } helper.Close(); } return(lstGroup); }
public static IRoleMenu GetMenuAccessByUser(int userId, int menuId) { IRoleMenu roleMenu = null; using (SqlDataHelper helper = new SqlDataHelper(ConnectionString)) { helper.CommandText = "[webadmin].[uspGetMenuAccessByUser]"; helper.CommandType = CommandType.StoredProcedure; helper.Parameters.Add("@UserId", userId); helper.Parameters.Add("@MenuId", menuId); helper.Open(); helper.ExecuteReader(CommandBehavior.CloseConnection); while (helper.DataReader.Read()) { roleMenu = new RoleMenuEntity(helper.DataReader); } helper.Close(); } return(roleMenu); }
public static void ValidateUser(IUser user) { using (SqlDataHelper helper = new SqlDataHelper(ConnectionString)) { helper.CommandText = "[webadmin].[uspValidateUser]"; helper.CommandType = CommandType.StoredProcedure; helper.Parameters.Add("@UserName", user.Name); helper.Parameters.Add("@Password", user.Password); helper.Open(); helper.ExecuteReader(CommandBehavior.CloseConnection); while (helper.DataReader.Read()) { user.Id = Convert.ToInt32(helper.DataReader["UserId"]); user.FirstName = Convert.ToString(helper.DataReader["FirstName"]); user.LastName = Convert.ToString(helper.DataReader["LastName"]); user.UserRole.Id = Convert.ToInt32(helper.DataReader["RoleId"]); user.EmailId = Convert.ToString(helper.DataReader["emailID"]); } helper.Close(); } }
public static List <IRoleMenu> GetMenuByRole(int roleId, int mainId) { List <IRoleMenu> lstMenu = new List <IRoleMenu>(); using (SqlDataHelper helper = new SqlDataHelper(ConnectionString)) { helper.CommandText = "[webadmin].[uspGetMenuByRole]"; helper.CommandType = CommandType.StoredProcedure; helper.Parameters.Add("@RoleId", roleId); helper.Parameters.Add("@MainId", mainId); helper.Open(); helper.ExecuteReader(CommandBehavior.CloseConnection); while (helper.DataReader.Read()) { IRoleMenu menu = new RoleMenuEntity(helper.DataReader); lstMenu.Add(menu); } helper.Close(); } return(lstMenu); }
public static List <ReportEntity> GetCashierLog(ReportCriteria criteria) { List <ReportEntity> lstData = new List <ReportEntity>(); using (SqlDataHelper helper = new SqlDataHelper(ConnectionString)) { helper.CommandText = "[rpt].[]"; helper.CommandType = CommandType.StoredProcedure; helper.Parameters.Add("@", 1); helper.Open(); helper.ExecuteReader(CommandBehavior.CloseConnection); while (helper.DataReader.Read()) { ReportEntity report = new ReportEntity(helper.DataReader); report.LoadCashierLog(helper.DataReader); lstData.Add(report); } helper.Close(); } return(lstData); }