public string[] UserLogIn(LoginInfo loginInfo, ref string replay) { string[] res = new string[4]; string msg_code = string.Empty; string msg = string.Empty; try { string encryptedPassword = objEncrypt.EncryptString(loginInfo.Password, ""); objSqlProcManager = new SqlProcedureManager(connectionString); string spname = "sp_User_Login"; var result = objSqlProcManager.ExecuteNonQueryParam(spname, ref replay, loginInfo.Email, encryptedPassword, loginInfo.UserType, msg_code, msg ); res[0] = result[3].Value.ToString(); res[1] = result[4].Value.ToString(); string decryptedPassword = objEncrypt.DecryptString(encryptedPassword, ""); return(res); } catch (Exception errorException) { throw errorException; } return(res); }
public string[] SaveUserAddress(UserAddress userAddress, ref string replay) { string[] res = new string[4]; string msg_code = string.Empty; string msg = string.Empty; try { objSqlProcManager = new SqlProcedureManager(connectionString); string spname = "sp_User_Address_Insert_Update"; var result = objSqlProcManager.ExecuteNonQuery(spname, ref replay, 0, userAddress.UserId, userAddress.AddressTitle, userAddress.StreetAddress, userAddress.City, userAddress.PostCode, userAddress.Country, userAddress.Latitude, userAddress.Longitude, "Y" ); if (result > 0) { res[0] = "Y"; res[1] = "Address saved successfully."; } else { res[0] = "N"; res[1] = "Failed to save address."; } return(res); } catch (Exception errorException) { throw errorException; } return(res); }
// SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["OnlineBookingConnection"].ConnectionString); #region Security public string[] UserSignUp(UserInfo userInfo, ref string replay) { string[] res = new string[4]; string msg_code = string.Empty; string msg = string.Empty; try { string encryptedPassword = objEncrypt.EncryptString(userInfo.Password, ""); DateTime myDate = Convert.ToDateTime(userInfo.BirthDate); objSqlProcManager = new SqlProcedureManager(connectionString); string spname = "sp_User_Sign_Up_Update"; var result = objSqlProcManager.ExecuteNonQueryParam(spname, ref replay, 0, userInfo.UserId, userInfo.FirstName, userInfo.LastName, userInfo.NickName, myDate.ToString("yyyy-MM-dd"), userInfo.Gender, userInfo.Email, encryptedPassword, userInfo.Phone, userInfo.UserType, userInfo.UserStatus, msg_code, msg ); res[0] = result[12].Value.ToString(); res[1] = result[13].Value.ToString(); // string decryptedPassword = objEncrypt.DecryptString(encryptedPassword, ""); return(res); } catch (Exception errorException) { throw errorException; } return(res); }
public DataTable GetAllNotices(ref string replay) { string msg_code = string.Empty; string msg = string.Empty; DataTable dTable = new DataTable(); try { objSqlProcManager = new SqlProcedureManager(connectionString); dTable = objSqlProcManager.ExecuteDataTable("sp_Get_All_Notices", ref replay ); } catch (Exception errorException) { throw errorException; } return(dTable); }
public DataTable GetOrderListByUser(string UserId, ref string replay) { string msg_code = string.Empty; string msg = string.Empty; DataTable dTable = new DataTable(); try { objSqlProcManager = new SqlProcedureManager(connectionString); dTable = objSqlProcManager.ExecuteDataTable("sp_Get_Orders_By_UserId", ref replay, UserId); } catch (Exception errorException) { throw errorException; } return(dTable); }
public DataTable GetTagList(string dayName, ref string replay) { string msg_code = string.Empty; string msg = string.Empty; DataTable dTable = new DataTable(); try { objSqlProcManager = new SqlProcedureManager(connectionString); dTable = objSqlProcManager.ExecuteDataTable("sp_Get_TagList", ref replay, dayName); } catch (Exception errorException) { throw errorException; } return(dTable); }
public DataTable GetUserAddress(string userid, ref string replay) { string msg_code = string.Empty; string msg = string.Empty; DataTable dTable = new DataTable(); try { objSqlProcManager = new SqlProcedureManager(connectionString); dTable = objSqlProcManager.ExecuteDataTable("sp_Get_User_Addreess", ref replay, userid); } catch (Exception errorException) { throw errorException; } return(dTable); }
public string[] PlaceCustomerOrder(PlaceCustomerOrder objOrder, ref string replay) { string[] res = new string[4]; string msg_code = string.Empty; string msg = string.Empty; try { objSqlProcManager = new SqlProcedureManager(connectionString); string spname = "sp_Create_Order"; var result = objSqlProcManager.ExecuteNonQuery(spname, ref replay, objOrder.MenuId, objOrder.CustomerId, objOrder.DeleveryDate, objOrder.DeleveryDayName, objOrder.Quantity, objOrder.AddressId, objOrder.DeleveryAddress, objOrder.ReceiverName, objOrder.UserRemarks ); if (result > 0) { res[0] = "Y"; res[1] = "Order placed successfully."; } else { res[0] = "N"; res[1] = "Failed to placed order."; } return(res); } catch (Exception errorException) { throw errorException; } return(res); }
public DataTable GetOrderByCustomer(string UserId, string CustomerId, ref string replay) { string msg_code = string.Empty; string msg = string.Empty; DataTable dTable = new DataTable(); try { objSqlProcManager = new SqlProcedureManager(connectionString); dTable = objSqlProcManager.ExecuteDataTable("admin_Get_All_Orders_By_DeleveryDate", ref replay, UserId, CustomerId); } catch (Exception errorException) { throw errorException; } return(dTable); }
public DataTable GetMenuDetails(string dayName, string tagName, ref string replay) { string msg_code = string.Empty; string msg = string.Empty; DataTable dTable = new DataTable(); try { objSqlProcManager = new SqlProcedureManager(connectionString); dTable = objSqlProcManager.ExecuteDataTable("sp_Get_MenuItems_By_Day_Tag", ref replay, dayName, tagName ); } catch (Exception errorException) { throw errorException; } return(dTable); }
public DataTable GetUserInfo(string email, ref string replay) { string msg_code = string.Empty; string msg = string.Empty; DataTable dTable = new DataTable(); try { objSqlProcManager = new SqlProcedureManager(connectionString); dTable = objSqlProcManager.ExecuteDataTable("sp_Get_User_Info", ref replay, email, msg_code, msg); } catch (Exception errorException) { throw errorException; } return(dTable); }
public string[] SaveMessage(UserToVendorMessage newMessage, ref string replay) { string[] res = new string[4]; string msg_code = string.Empty; string msg = string.Empty; try { objSqlProcManager = new SqlProcedureManager(connectionString); string spname = "sp_Save_a_Message"; var result = objSqlProcManager.ExecuteNonQuery(spname, ref replay, newMessage.SenderId, newMessage.ReceiverId, newMessage.MessageDetails, "", "Y" ); if (result > 0) { res[0] = "Y"; res[1] = "Message sent."; } else { res[0] = "N"; res[1] = "Failed to send message."; } // string decryptedPassword = objEncrypt.DecryptString(encryptedPassword, ""); return(res); } catch (Exception errorException) { throw errorException; } return(res); }
public DataTable GetMyMessages(ChatParameters objChatParameters, ref string replay) { string msg_code = string.Empty; string msg = string.Empty; DataTable dTable = new DataTable(); try { objSqlProcManager = new SqlProcedureManager(connectionString); dTable = objSqlProcManager.ExecuteDataTable("sp_Get_My_Messages", ref replay, objChatParameters.SenderId, objChatParameters.ReceiverId ); } catch (Exception errorException) { throw errorException; } return(dTable); }
public string[] CancleOrderByUser(CancleOrderEntity objOrder, ref string replay) { string[] res = new string[4]; string msg_code = string.Empty; string msg = string.Empty; try { objSqlProcManager = new SqlProcedureManager(connectionString); string spname = "sp_Cancel_Order_ByUser"; var result = objSqlProcManager.ExecuteNonQuery(spname, ref replay, objOrder.OrderId, objOrder.CustomerId ); if (result > 0) { res[0] = "Y"; res[1] = "Order cancled successfully."; } else { res[0] = "N"; res[1] = "Failed to cancle order."; } return(res); } catch (Exception errorException) { throw errorException; } return(res); }