//---------------------------------------------------------------------
#endregion
#region --------------ChangeAddress--------------
//---------------------------------------------------------------------
//ChangeAddress
//---------------------------------------------------------------------
public bool ChangeAddress(OrderRequestAddress ShippingAddress, int userId)
{
bool savestats = false;
try
{
string sp = "[dbo].[OrderRequestAddress_ChangeUserAddress]";
//----------------------------------------------------------------
CustomDbParameterList customParameters = ShippingAddress.GetMemberParameters(
e => e.OrderRequestAddressID,
e => e.FName,
e => e.LName,
e => e.CityID,
e => e.Mobile,
e => e.Address,
e => e.ShippingNote,
e => e.ChangeUserAddressAlso);
//UserID
customParameters.Add("@UserID", userId);
//----------------------------------------------------------------
SqlDataHelper.ExecuteStoredProcedure(sp, customParameters);
//----------------------------------------------------------------
savestats = true;
}
catch (Exception ex)
{
savestats = false;
}
return(savestats);
}
//---------------------------------------------------------------------
//ConvertOrderRequestToFinalOrder
//---------------------------------------------------------------------
public bool ConvertOrderRequestToFinalOrder(OrderConfirmationFormDto request)
{
bool isValid = false;
string sp = "[dbo].[Order_ConvertOrderRequestToFinalOrder]";
//Prepare Parameters-----------------------------------------------
CustomDbParameterList customParameters = request.GetMemberParameters(
r => r.UserID,
r => r.PaymentMethodID,
r => r.ShippingMethodID,
r => r.OrderRequestID,
r => r.LangId,
r => r.UserNote,
r => r.FName,
r => r.LName,
r => r.CityID,
r => r.Mobile,
r => r.Address,
//r => r.ShippingNote,
r => r.ChangeUserAddressAlso);
//customParameters.Add("@ShippingNote", request.UserNote);
//IsValid
SqlParameter IsValidOutputParameter = customParameters.AddOutputParameter_Boolean("@IsValid");
//---------------------------------------------------------------------
SqlDataHelper.ExecuteStoredProcedure(sp, customParameters);
//----------------------------------------------------------------
//IsValid
isValid = (bool)IsValidOutputParameter.Value;
return(isValid);
}
//---------------------------------------------------------------------
#endregion
#region --------------ChangeOrderStatus--------------
//---------------------------------------------------------------------
//ChangeOrderStatus
//---------------------------------------------------------------------
public bool ChangeOrderStatus(int orderID, EnumOrderStatus orderStatusID, float totalPaied, string adminNote)
{
bool savestats = false;
try
{
//[dbo].[Order_ChangeOrderStatus]
string sp = "[dbo].[Order_ChangeOrderStatus]";
CustomDbParameterList customParameters = new CustomDbParameterList();
//----------------------------------------------------------------
customParameters.Add("@OrderID", orderID);
customParameters.Add("@OrderStatusID", orderStatusID);
customParameters.Add("@TotalPaied", totalPaied);
customParameters.Add("@AdminNote", adminNote);
//----------------------------------------------------------------
SqlDataHelper.ExecuteStoredProcedure(sp, customParameters);
//----------------------------------------------------------------
savestats = true;
}
catch (Exception ex)
{
savestats = false;
}
return(savestats);
}
//---------------------------------------------------------------------
#endregion
#region --------------UpdateProfile--------------
//---------------------------------------------------------------------
//UpdateProfile
//---------------------------------------------------------------------
public bool UpdateProfile(User user)
{
string sp = "[dbo].[Users_UpdateProfile]";
var parameters = user.GetMemberParameters(
u => u.UserID,
u => u.FirstName,
u => u.LastName,
u => u.UserEmail,
u => u.UserMobile,
u => u.CityID,
u => u.Address);
int resultCount = SqlDataHelper.ExecuteStoredProcedure(sp, parameters);
return((resultCount > 0) ? true : false);
}
//---------------------------------------------------------------------
//AddProfile
//---------------------------------------------------------------------
public bool AddProfile(User user)
{
string sp = "[dbo].[Users_AddProfile]";
var parameters = user.GetMemberParameters(
u => u.UserID,
u => u.AspNetUserId,
u => u.UserName,
u => u.FirstName,
u => u.LastName,
u => u.UserEmail,
u => u.UserMobile,
u => u.EmailConfirmed,
u => u.RoleID);
int resultCount = SqlDataHelper.ExecuteStoredProcedure(sp, parameters);
return((resultCount > 0) ? true : false);
}
