public static UserLoginDataModel MapToUserLoginRecord(BsonDocument obj) { var userLogin = new UserLoginDataModel(); userLogin.UserName = obj["UserName"].AsString; userLogin.RecordDate = obj["RecordDate"].ToUniversalTime(); if (obj.Contains("ApplicationId")) { userLogin.ApplicationId = obj["ApplicationId"].AsInt32; } if (obj.Contains("Application")) { userLogin.Application = obj["Application"].AsString; } if (obj.Contains("UserLoginStatusId")) { if (obj["UserLoginStatusId"].IsInt32) { userLogin.UserLoginStatusId = obj["UserLoginStatusId"].AsInt32; } } if (obj.Contains("UserLoginStatus")) { userLogin.UserLoginStatus = obj["UserLoginStatus"].AsString; } return(userLogin); }
private static string Save(UserLoginDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.UserLoginInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); break; case "Update": sql += "dbo.UserLoginUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); break; default: break; } sql = sql + ", " + ToSQLParameter(data, UserLoginDataModel.DataColumns.UserLoginId) + ", " + ToSQLParameter(data, UserLoginDataModel.DataColumns.UserName) + ", " + ToSQLParameter(data, UserLoginDataModel.DataColumns.UserLoginStatusId); return(sql); }
public static List <UserLoginDataModel> GetList(UserLoginDataModel data, RequestProfile requestProfile) { var userData = Database.GetCollection <BsonDocument>("UserLogin"); var resultList = new List <UserLoginDataModel>(); if (string.IsNullOrEmpty(data.UserName)) { resultList = GetList(); } else if (!string.IsNullOrEmpty(data.UserName)) { var builder = Builders <BsonDocument> .Filter; var filter = builder.Eq(UserLoginHistoryDataModel.DataColumns.UserName, data.UserName); var resultUserHistoryData = userData.Find(filter).ToListAsync(); var userHistoryData = resultUserHistoryData.Result; if (userHistoryData != null) { foreach (var obj in userHistoryData) // Loop thru all Bson documents returned from the query. { resultList.Add(MapToUserLoginRecord(obj)); } } } return(resultList); }
public static List <UserLoginDataModel> GetEntityDetails(UserLoginDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = ReturnAuditInfoOnDetails) { const string sql = @"dbo.UserLoginSearch "; var parameters = new { AuditId = requestProfile.AuditId , ApplicationId = requestProfile.ApplicationId , UserLoginId = dataQuery.UserLoginId , UserLoginStatusId = dataQuery.UserLoginStatusId , UserName = dataQuery.UserName , RecordDate = dataQuery.RecordDate , RecordDate2 = dataQuery.RecordDate2 , ReturnAuditInfo = returnAuditInfo }; List <UserLoginDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <UserLoginDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
public static DataTable Search(UserLoginDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 0); var table = list.ToDataTable(); return(table); }
public static bool DoesExist(UserLoginDataModel data, RequestProfile requestProfile) { var doesExistRequest = new UserLoginDataModel(); doesExistRequest.UserName = data.UserName; var list = GetEntityDetails(doesExistRequest, requestProfile, 0); return(list.Count > 0); }
protected void btnSearch_Click(object sender, EventArgs e) { var data = new Framework.Components.LogAndTrace.UserLoginDataModel(); data.UserName = txtUserName.Text; var userdata = UserLoginMongoDbDataManager.GetList(data, SessionVariables.RequestProfile); gridUserLogin.DataSource = userdata; gridUserLogin.DataBind(); }
public static void Create(UserLoginDataModel data, RequestProfile requestProfile) { var userLogin = Database.GetCollection <BsonDocument>("UserLogin"); var dataCollection = new BsonDocument { { UserLoginDataModel.DataColumns.Application, data.Application }, { UserLoginDataModel.DataColumns.UserName, data.UserName }, { UserLoginDataModel.DataColumns.UserLoginStatus, data.UserLoginStatus }, { UserLoginDataModel.DataColumns.RecordDate, DateTime.Now } }; userLogin.InsertOneAsync(dataCollection); }
public static void Delete(UserLoginDataModel data, RequestProfile requestProfile) { const string sql = @"dbo.UserLoginDelete "; var parameters = new { AuditId = requestProfile.AuditId , UserLoginId = data.UserLoginId }; using (var dataAccess = new DataAccessBase(DataStoreKey)) { dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure); } }
//public static List<UserLoginDataModel> GetEntityDetails(UserLoginDataModel data, RequestProfile requestProfile) //{ // var sql = "EXEC dbo.UserLoginSearch " + // " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + // ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) + // ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ReturnAuditInfo, BaseDataManager.ReturnAuditInfoOnDetails) + // ", " + ToSQLParameter(data, UserLoginDataModel.DataColumns.UserLoginId) + // ", " + ToSQLParameter(data, UserLoginDataModel.DataColumns.UserLoginStatusId) + // ", " + ToSQLParameter(data, UserLoginDataModel.DataColumns.UserName) + // ", " + ToSQLParameter(data, UserLoginDataModel.DataColumns.RecordDate) + // ", " + ToSQLParameter(data, UserLoginDataModel.DataColumns.RecordDate2); // var result = new List<UserLoginDataModel>(); // using (var reader = new DBDataReader("Get Details", sql, DataStoreKey)) // { // var dbReader = reader.DBReader; // while (dbReader.Read()) // { // var dataItem = new UserLoginDataModel(); // dataItem.UserLoginId = (int)dbReader[UserLoginDataModel.DataColumns.UserLoginId]; // dataItem.UserLoginStatusId = (int)dbReader[UserLoginDataModel.DataColumns.UserLoginStatusId]; // dataItem.UserName = dbReader[UserLoginDataModel.DataColumns.UserName].ToString(); // dataItem.UserLoginStatus = dbReader[UserLoginDataModel.DataColumns.UserLoginStatus].ToString(); // dataItem.RecordDate = (int)dbReader[UserLoginDataModel.DataColumns.RecordDate]; // SetBaseInfo(dataItem, dbReader); // result.Add(dataItem); // } // } // return result; //} #endregion #region Create public static void Create(UserLoginDataModel data, RequestProfile requestProfile) { if (data.UserLoginStatusId == null && !string.IsNullOrEmpty(data.UserLoginStatus)) { var dataStatus = new UserLoginStatusDataModel(); dataStatus.Name = data.UserLoginStatus; var dt = UserLoginStatusDataManager.Search(dataStatus, requestProfile); if (dt.Rows.Count > 0) { data.UserLoginStatusId = Convert.ToInt32(dt.Rows[0][UserLoginDataModel.DataColumns.UserLoginStatusId]); } } var sql = Save(data, requestProfile, "Create"); DBDML.RunSQL("UserLogin.Insert", sql, DataStoreKey); Framework.Components.LogAndTrace.UserLoginMongoDbDataManager.Create(data, requestProfile); }
public static string ToSQLParameter(UserLoginDataModel data, string dataColumnUserName) { var returnValue = "NULL"; switch (dataColumnUserName) { case UserLoginDataModel.DataColumns.UserLoginId: if (data.UserLoginId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, UserLoginDataModel.DataColumns.UserLoginId, data.UserLoginId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UserLoginDataModel.DataColumns.UserLoginId); } break; case UserLoginDataModel.DataColumns.UserName: if (!string.IsNullOrEmpty(data.UserName)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, UserLoginDataModel.DataColumns.UserName, data.UserName.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UserLoginDataModel.DataColumns.UserName); } break; case UserLoginDataModel.DataColumns.UserLoginStatus: if (!string.IsNullOrEmpty(data.UserLoginStatus)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, UserLoginDataModel.DataColumns.UserLoginStatus, data.UserLoginStatus.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UserLoginDataModel.DataColumns.UserLoginStatus); } break; case UserLoginDataModel.DataColumns.RecordDate: if (data.RecordDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, UserLoginDataModel.DataColumns.RecordDate, data.RecordDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UserLoginDataModel.DataColumns.RecordDate); } break; case UserLoginDataModel.DataColumns.UserLoginStatusId: if (data.UserLoginStatusId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, UserLoginDataModel.DataColumns.UserLoginStatusId, data.UserLoginStatusId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UserLoginDataModel.DataColumns.UserLoginStatusId); } break; case UserLoginDataModel.DataColumns.FromSearchDate: if (data.FromSearchDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, UserLoginDataModel.DataColumns.FromSearchDate, data.FromSearchDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UserLoginDataModel.DataColumns.FromSearchDate); } break; case UserLoginDataModel.DataColumns.ToSearchDate: if (data.ToSearchDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, UserLoginDataModel.DataColumns.ToSearchDate, data.ToSearchDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UserLoginDataModel.DataColumns.ToSearchDate); } break; case UserLoginDataModel.DataColumns.RecordDate2: if (data.RecordDate2 != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, UserLoginDataModel.DataColumns.RecordDate2, data.RecordDate2); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UserLoginDataModel.DataColumns.RecordDate2); } break; } return(returnValue); }
public static void Update(UserLoginDataModel data, RequestProfile requestProfile) { var sql = Save(data, requestProfile, "Update"); DBDML.RunSQL("UserLogin.Update", sql, DataStoreKey); }
public static UserLoginDataModel GetDetails(UserLoginDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 1); return(list.FirstOrDefault()); }