public SuccessModel <object> GetCustomerById(int customerId)
{
try
{
object id = customerId;
var parameterList = new List <Tuple <string, object> >
{
Tuple.Create("@CustomerId", id)
};
DataSet executedSP = MasterHelperService.SqlConnectionSPHelper("GetCustomerById", parameterList);
return(new SuccessModel <object>()
{
Data = executedSP.Tables[0],
ErrorMessage = null
});
}
catch (Exception ex)
{
return(new SuccessModel <object>()
{
Data = null,
ErrorMessage = ex.Message
});
}
}
public SuccessModel <CategoryInfoManageModel> GetCategoryDetailsForDP()
{
try
{
object id = 3;
var parameterList = new List <Tuple <string, object> >
{
Tuple.Create("@EntityId", id)
};
DataSet executedSP = MasterHelperService.SqlConnectionSPHelper("GetCategoryList", null);
DataSet executedSPCT = MasterHelperService.SqlConnectionSPHelper("GetReferenceDataValueByEntity", parameterList);
return(new SuccessModel <CategoryInfoManageModel>()
{
Data = new CategoryInfoManageModel()
{
CategoryList = executedSP.Tables[0],
CategoryTypeList = executedSPCT.Tables[0],
},
ErrorMessage = null
});
}
catch (Exception ex)
{
return(new SuccessModel <CategoryInfoManageModel>()
{
Data = null, ErrorMessage = ex.Message
});
}
}
public SuccessModel <object> RemoveCartItem(int cartId)
{
try
{
string message = string.Empty;
object _cartId = cartId;
var parameterList = new List <Tuple <string, object> >
{
Tuple.Create("@CartId", _cartId)
};
DataSet executedSP = MasterHelperService.SqlConnectionSPHelper("RemoveShoppingItem", parameterList);
return(new SuccessModel <object>()
{
Data = "Save Successfully",
ErrorMessage = null
});
}
catch (Exception ex)
{
return(new SuccessModel <object>()
{
Data = "Something went wrong",
ErrorMessage = "Failed"
});
// throw ex;
}
}
public SuccessModel <object> UpdateCartItem(ShoppingCartModel model)
{
try
{
string message = string.Empty;
var parameterList = new List <Tuple <string, object> >
{
Tuple.Create("@CartId", model.CustomerId),
Tuple.Create("@Quantity", model.Quantity == null ? default(int) : model.Quantity),
};
DataSet executedSP = MasterHelperService.SqlConnectionSPHelper("UpdateShoppingItem", parameterList);
return(new SuccessModel <object>()
{
Data = "Save Successfully",
ErrorMessage = null
});
}
catch (Exception ex)
{
return(new SuccessModel <object>()
{
Data = "Something went wrong",
ErrorMessage = "Failed"
});
// throw ex;
}
}
public DataValidationModel <object> CustometInsertOrUpdate(CustomerIUModel customer)
{
try
{
string message = string.Empty;
var parameterList = new List <Tuple <string, object> >
{
Tuple.Create("@CustomerId", customer.CustomerId == null ? default(int) : customer.CustomerId),
Tuple.Create("@ContactEmail", customer.ContactEmail),
Tuple.Create("@LoginPassword", MasterHelperService.EncodePasswordToBase64(customer.LoginPassword)),
Tuple.Create("@FirstName", customer.FirstName),
Tuple.Create("@LastName", customer.LastName),
Tuple.Create("@Address1", customer.Address1),
Tuple.Create("@Address2", customer.Address2),
Tuple.Create("@ContactMobile", customer.ContactMobile),
};
DataSet executedSP = MasterHelperService.SqlConnectionSPHelper("SaveCustomer", parameterList);
var isExist = false; var isNewCreated = false; var id = default(int);
for (int i = 0; i < executedSP.Tables[0].Rows.Count; i++)
{
isExist = Convert.ToBoolean(executedSP.Tables[0].Rows[i]["IsExist"]);
isNewCreated = Convert.ToBoolean(executedSP.Tables[0].Rows[i]["IsNewCreated"]);
id = Convert.ToInt32(executedSP.Tables[0].Rows[i]["Id"]);
}
return(new DataValidationModel <object>()
{
Data = GetCustomerById(id),
IsExist = isExist,
ErrorMessage = null
});
}
catch (Exception ex)
{
//return new DataValidationModel<string>()
//{
// Data = "Something went wrong",
// ErrorMessage = "Failed"
//};
throw ex;
}
}
public SuccessModel <LoginResponseModel> ValidateCustomer(LoginMaster loginUser)
{
try
{
var data = MasterHelperService.ValidatingUserForAll(loginUser, "CUSTOMER");
if (data.Item1)
{
var custData = GetCustomerById(data.Item2);
return(new SuccessModel <LoginResponseModel>()
{
Data = new LoginResponseModel()
{
Data = custData.Data, IsExist = data.Item1
}
});
}
else
{
return(new SuccessModel <LoginResponseModel>()
{
Data = new LoginResponseModel()
{
IsExist = data.Item1, Data = null
}
});
}
}
catch (Exception ex)
{
return(new SuccessModel <LoginResponseModel>()
{
Data = null, ErrorMessage = ex.Message
});
}
}
