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;
}
}
