public DataTable GetTravellerProfile(Int64 travellerID, IDbConnection con) { DataSet dsResult = new DataSet(); try { IDbDataParameter[] paramData; paramData = DALHelperParameterCache.GetSpParameterSet(con, "GetTravellerProfile"); foreach (IDbDataParameter Item in paramData) { switch (Item.ParameterName) { case "TravellerId": Item.Value = travellerID; break; } } DALHelper.FillDataset(con, CommandType.StoredProcedure, "GetTravellerProfile", dsResult, new string[] { "TravellerProfile" }, paramData); return(dsResult.Tables.Contains("TravellerProfile") ? dsResult.Tables["TravellerProfile"] : null); } catch (Exception ex) { ErrorLogDL.InsertErrorLog(ex.Message, "GetTravellerProfile"); throw ex; } }
public object GetUsers(long userId) { try { con = DALHelper.GetConnection(); IDbDataParameter[] paramData; paramData = DALHelperParameterCache.GetSpParameterSet(con, "GetAllUsers"); foreach (IDbDataParameter Item in paramData) { switch (Item.ParameterName) { case "UserId": Item.Value = userId; break; } } DALHelper.FillDataset(con, CommandType.StoredProcedure, "GetAllUsers", dsResult, new string[] { "User" }, paramData); objResult = dsResult.Tables.Contains("User") ? dsResult.Tables["User"] : null; } catch (Exception ex) { throw ex; } finally { DALHelper.CloseDB(con); } return(objResult); }
private DataTable SelectSecurityProfile(User _user, IDbConnection con) { DataSet dsResult = new DataSet(); try { IDbDataParameter[] paramData; paramData = DALHelperParameterCache.GetSpParameterSet(con, "GetLogin"); foreach (IDbDataParameter Item in paramData) { switch (Item.ParameterName) { case "Email": Item.Value = _user.email; break; case "UserName": Item.Value = _user.username; break; case "Password": Item.Value = _user.password; break; case "Lat": Item.Value = ""; break; case "Long": Item.Value = ""; break; case "DeviceToken": Item.Value = _user.deviceToken; break; } } DALHelper.FillDataset(con, CommandType.StoredProcedure, "GetLogin", dsResult, new string[] { "User" }, paramData); return(dsResult.Tables.Contains("User") ? dsResult.Tables["User"] : null); } catch (FileNotFoundException) { return(dsResult.Tables.Contains("SecurityProfile") ? dsResult.Tables["SecurityProfile"] : null); //throw new RisException("¥CmnFilenotfound¥"); //throw new Exception("File not found"); } catch (UnauthorizedAccessException) { return(dsResult.Tables.Contains("SecurityProfile") ? dsResult.Tables["SecurityProfile"] : null); //throw new RisException("¥CmnFilenotfound¥"); //throw new Exception("File not found"); } catch (Exception ex) { ErrorLogDL.InsertErrorLog(ex.Message, "SelectSecurityProfile"); throw ex; } }
public Int16 ResetPassword(User _user, IDbTransaction transaction) { try { IDbDataParameter[] paramData; Int16 Result = 0; paramData = DALHelperParameterCache.GetSpParameterSet(transaction, "ResetPassword"); foreach (IDbDataParameter Item in paramData) { switch (Item.ParameterName) { case "UserId": Item.Value = _user.userId; break; case "Password": Item.Value = _user.password; break; } } Result = Convert.ToInt16(DALHelper.ExecuteNonQuery(transaction, CommandType.StoredProcedure, "ResetPassword", paramData)); return(Result); } catch (Exception ex) { ErrorLogDL.InsertErrorLog(ex.Message, "ResetPassword"); throw ex; } }
public Int64 InsertHelpUs(Int64 userId, string title, string message, IDbTransaction transaction) { try { IDbDataParameter[] paramData; Int16 Result = 0; paramData = DALHelperParameterCache.GetSpParameterSet(transaction, "InsertHelpUs"); foreach (IDbDataParameter Item in paramData) { switch (Item.ParameterName) { case "UserId": Item.Value = userId; break; case "Title": Item.Value = title; break; case "Message": Item.Value = message; break; } } Result = Convert.ToInt16(DALHelper.ExecuteNonQuery(transaction, CommandType.StoredProcedure, "InsertHelpUs", paramData)); return(Result); } catch (Exception ex) { ErrorLogDL.InsertErrorLog(ex.Message, "InsertHelpUs"); throw ex; } }
public Int64 ValidateEmail(string email, IDbConnection con) { try { IDbDataParameter[] paramData; Int64 Result = 0; DataSet dsResult = new DataSet(); paramData = DALHelperParameterCache.GetSpParameterSet(con, "ValidateEmail"); foreach (IDbDataParameter Item in paramData) { switch (Item.ParameterName) { case "Email": Item.Value = email; break; } } DALHelper.FillDataset(con, CommandType.StoredProcedure, "ValidateEmail", dsResult, new string[] { "Users" }, paramData); return(dsResult.Tables.Contains("Users") && dsResult.Tables["Users"].Rows.Count > 0 ? Convert.ToInt64(dsResult.Tables["Users"].Rows[0]["UserId"].ToString()) : 0); } catch (Exception ex) { // ErrorLogDL.InsertErrorLog(ex.Message, "RegisterTravellerUser"); throw ex; } }
public Int16 AddGallery(DataRow dr, IDbTransaction transaction, Int32 hostelId) { try { IDbDataParameter[] paramData; Int16 Result = 0; paramData = DALHelperParameterCache.GetSpParameterSet(transaction, "InsertGallery"); foreach (IDbDataParameter Item in paramData) { switch (Item.ParameterName) { case "HostelId": Item.Value = hostelId; break; case "ImageUrl": Item.Value = dr["ImageUrl"]; break; } } Result = Convert.ToInt16(DALHelper.ExecuteNonQuery(transaction, CommandType.StoredProcedure, "InsertGallery", paramData)); return(Result); } catch (Exception ex) { ErrorLogDL.InsertErrorLog(ex.Message, "AddGallery"); throw ex; } }
public DataTable GetAllTravellerCheckInDetails(Int64 hostelId, IDbConnection con, string mode) { DataSet dsResult = new DataSet(); try { IDbDataParameter[] paramData; paramData = DALHelperParameterCache.GetSpParameterSet(con, "GetTravellerCheckinDetails"); foreach (IDbDataParameter Item in paramData) { switch (Item.ParameterName) { case "HostelId": Item.Value = hostelId; break; case "Mode": Item.Value = mode; break; } } DALHelper.FillDataset(con, CommandType.StoredProcedure, "GetTravellerCheckinDetails", dsResult, new string[] { "Traveller" }, paramData); return(dsResult.Tables.Contains("Traveller") ? dsResult.Tables["Traveller"] : null); } catch (Exception ex) { ErrorLogDL.InsertErrorLog(ex.Message, "GetTravellerCheckInHistory"); throw ex; } }
public Int16 AddTravellerCheckInDetails(TravellerCheckIn _traveller, IDbTransaction transaction) { try { IDbDataParameter[] paramData; Int16 Result = 0; paramData = DALHelperParameterCache.GetSpParameterSet(transaction, "InsertTravellerCheckInCheckOutDetails"); foreach (IDbDataParameter Item in paramData) { switch (Item.ParameterName) { case "HostelId": Item.Value = _traveller.hostelId; break; case "QRCode": Item.Value = _traveller.travellerQRCode; break; case "Status": Item.Value = _traveller.Action; break; case "checkInDate": Item.Value = _traveller.checkInDate; break; case "checkOutDate": Item.Value = _traveller.checkOutDate; break; case "TrackingId": Item.Value = _traveller.trackingId; break; case "IsPointsSpent": Item.Value = _traveller.isPontsSpent; break; case "NoOfPointsSpent": Item.Value = _traveller.NoOfPointsSpent; break; } } Result = Convert.ToInt16(DALHelper.ExecuteNonQuery(transaction, CommandType.StoredProcedure, "InsertTravellerCheckInCheckOutDetails", paramData)); return(Result); } catch (Exception ex) { ErrorLogDL.InsertErrorLog(ex.Message, "AddTravellerCheckInDetails"); throw ex; } }
public Int16 RegisterTravellerUser(Traveller _traveller, IDbTransaction transaction) { try { IDbDataParameter[] paramData; Int16 Result = 0; paramData = DALHelperParameterCache.GetSpParameterSet(transaction, "InsertTravellerProfile"); foreach (IDbDataParameter Item in paramData) { switch (Item.ParameterName) { case "UserId": Item.Value = _traveller.UserId; break; case "Password": Item.Value = _traveller.password; break; case "EmailId": Item.Value = _traveller.emailId; break; case "Address": Item.Value = ""; break; case "UserType": Item.Value = "Traveller"; break; case "FirstName": Item.Value = _traveller.firstName; break; case "LastName": Item.Value = _traveller.lastName; break; } } Result = Convert.ToInt16(DALHelper.ExecuteNonQuery(transaction, CommandType.StoredProcedure, "InsertTravellerProfile", paramData)); return(Result); } catch (Exception ex) { ErrorLogDL.InsertErrorLog(ex.Message, "RegisterTravellerUser"); throw ex; } }
public Int64 RegisterUser(User _user, IDbTransaction transaction) { try { IDbDataParameter[] paramData; Int64 Result = 0; DataSet dsResult = new DataSet(); paramData = DALHelperParameterCache.GetSpParameterSet(transaction, "RegisterUsers"); foreach (IDbDataParameter Item in paramData) { switch (Item.ParameterName) { case "UserName": Item.Value = _user.username; break; case "Password": Item.Value = _user.password; break; case "EmailId": Item.Value = _user.email; break; case "Address": Item.Value = ""; break; case "UserType": Item.Value = _user.userType; break; } } DALHelper.FillDataset(transaction, CommandType.StoredProcedure, "RegisterUsers", dsResult, new string[] { "Users" }, paramData); return(dsResult.Tables.Contains("Users") && dsResult.Tables["Users"].Rows.Count > 0 ? Convert.ToInt64(dsResult.Tables["Users"].Rows[0]["UserId"].ToString()) : 0); } catch (Exception ex) { // ErrorLogDL.InsertErrorLog(ex.Message, "RegisterTravellerUser"); throw ex; } }
public static void InsertErrorLog(string errorMessge, string pageName) { IDbTransaction transaction = null; try { transaction = DALHelper.GetTransaction(); IDbDataParameter[] paramData; Int16 Result = 0; paramData = DALHelperParameterCache.GetSpParameterSet(transaction, "InsertErrorLog"); foreach (IDbDataParameter Item in paramData) { switch (Item.ParameterName) { case "ErrorMessage": Item.Value = errorMessge; break; case "PageName": Item.Value = pageName; break; case "Host": Item.Value = HttpContext.Current.Request.UserHostAddress; break; } } Result = Convert.ToInt16(DALHelper.ExecuteNonQuery(transaction, CommandType.StoredProcedure, "InsertErrorLog", paramData)); } catch (Exception ex) { throw ex; } finally { DALHelper.CloseDB(transaction, true); } }
public object GetLogin(Users user) { try { con = DALHelper.GetConnection(); IDbDataParameter[] paramData; DataSet dsResult = new DataSet(); paramData = DALHelperParameterCache.GetSpParameterSet(con, "GetLogin"); foreach (IDbDataParameter Item in paramData) { switch (Item.ParameterName) { case "UserName": Item.Value = user.userName; break; case "Password": Item.Value = user.password; break; case "contactNo": Item.Value = user.contactNo; break; } } DALHelper.FillDataset(con, CommandType.StoredProcedure, "GetLogin", dsResult, new string[] { "Users" }, paramData); return(dsResult.Tables.Contains("Users") ? dsResult.Tables["Users"] : null); } catch (Exception ex) { // ErrorLogDL.InsertErrorLog(ex.Message, "RegisterTravellerUser"); throw ex; } }
public object CreateUser(Users users) { Int64 Result = 0; try { transaction = DALHelper.GetTransaction(); paramData = DALHelperParameterCache.GetSpParameterSet(transaction, "InsertUsers"); foreach (IDbDataParameter Item in paramData) { switch (Item.ParameterName) { case "UserId": Item.Value = users.userId; break; case "UserName": Item.Value = users.userName; break; case "Password": Item.Value = users.password; break; case "Email": Item.Value = users.email; break; case "ContactNo": Item.Value = users.contactNo; break; case "IsAdmin": Item.Value = users.isAdmin; break; case "DataVisibility": Item.Value = users.dataVisibility; break; case "IsActive": Item.Value = users.isActive; break; } } Result = Convert.ToInt16(DALHelper.ExecuteNonQuery(transaction, CommandType.StoredProcedure, "InsertUsers", paramData)); if (Result > 0) { objResult = "User Created Successfully"; } else { objResult = "Not Saved"; } } catch (Exception ex) { IsSuccess = false; if (ex.Message.Contains("UNIQUE KEY")) { objResult = "User Already Exists"; } else { IsSuccess = false; // ErrorLogDL.InsertErrorLog(ex.Message, "LoginBL : RegisterUser"); throw; } } finally { DALHelper.CloseDB(transaction, IsSuccess); } return(objResult); }
private Int16 RegisterHostelUser(Hostel _hostel, IDbTransaction transaction) { try { IDbDataParameter[] paramData; Int16 Result = 0; paramData = DALHelperParameterCache.GetSpParameterSet(transaction, "sp_CreateUser"); foreach (IDbDataParameter Item in paramData) { switch (Item.ParameterName) { case "UserName": Item.Value = _hostel.username; break; case "Password": Item.Value = _hostel.password; break; case "EmailId": Item.Value = _hostel.emailId; break; case "Address": Item.Value = _hostel.address; break; case "UserType": Item.Value = "Hostel"; break; case "PersonalWebSiteLink": Item.Value = _hostel.websiteLink; break; case "ProfilePic": Item.Value = _hostel.profilePic; break; case "HostelDormRoomWithBunks": Item.Value = _hostel.hostelDormRoomwithBunks; break; case "HostelDormRoomWithoutBunks": Item.Value = _hostel.hostelDormRoomwithoutBunks; break; case "FemaleBedRooms": Item.Value = _hostel.femaleDormRooms; break; case "SingleBedRooms": Item.Value = _hostel.singleBedRooms; break; case "DoubleBedRooms": Item.Value = _hostel.doubleBedRooms; break; case "HostelName": Item.Value = _hostel.hostelName; break; case "CityName": Item.Value = _hostel.cityName; break; } } Result = Convert.ToInt16(DALHelper.ExecuteNonQuery(transaction, CommandType.StoredProcedure, "sp_CreateUser", paramData)); return(Result); } catch (Exception ex) { ErrorLogDL.InsertErrorLog(ex.Message, "RegisterHostelUser"); throw ex; } }