public override List <ExamProperty> GetAllExamList()
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
_dataSet = new DataSet();
var examObjectList = new List <ExamProperty>();
try
{
_dataSet = _objDataWrapper.ExecuteDataSet("Aj_Proc_GetExamList");
examObjectList = BindExamListObject(_dataSet.Tables[0]);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing UpdateCountry in Exam.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(examObjectList);
}
public override List <BO.UniversityCategoryProperty> GetAllUniversityCategoryList()
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
_dataSet = new DataSet();
var objUniversityCategoryList = new List <BO.UniversityCategoryProperty>();
try
{
_dataSet = _objDataWrapper.ExecuteDataSet("Aj_Proc_GetUniversityCategoryList");
objUniversityCategoryList = BindUniversityCategoryObject(_dataSet.Tables[0]);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetAllUniversityCategoryList in University.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objUniversityCategoryList);
}
public List <ClsDBTablesAttributes> GetAllColumnsOfTable(string _strTableName, string AutoIncrementedColumnName)
{
DbWrapper objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
DataSet ds = new DataSet();
List <ClsDBTablesAttributes> _objListClsDBTables = new List <ClsDBTablesAttributes>();
objDataWrapper.AddParameter("@TableName", _strTableName);
objDataWrapper.AddParameter("@AutoIncrementedColumnName", AutoIncrementedColumnName);
ds = objDataWrapper.ExecuteDataSet("Aj_Proc_GetColumnsOfTable");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ClsDBTablesAttributes _objClsDBTablesAttributes = new ClsDBTablesAttributes();
_objClsDBTablesAttributes.PropColumnName = ds.Tables[0].Rows[i]["column_name"].ToString();
_objClsDBTablesAttributes.PropDataType = ds.Tables[0].Rows[i]["data_type"].ToString();
_objClsDBTablesAttributes.PropColumnDTCharLength = ds.Tables[0].Rows[i]["charLength"].ToString();
_objListClsDBTables.Add(_objClsDBTablesAttributes);
}
return(_objListClsDBTables);
}
public override string UpdatePackage(int packageId, int courseId, string packageName, string factorId, bool isChargable, bool isVisible, int amount)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
string errMsg = "";
try
{
_objDataWrapper.AddParameter("@AjPackageId", packageId);
_objDataWrapper.AddParameter("@PackageName", packageName);
_objDataWrapper.AddParameter("@FactorId", factorId);
_objDataWrapper.AddParameter("@IsVisible", isVisible);
_objDataWrapper.AddParameter("@IsPackageChargeable", isChargable);
_objDataWrapper.AddParameter("@PackageAmount", amount);
_objDataWrapper.AddParameter("@CourseId", courseId);
var ObjErrMsg =
(SqlParameter)(_objDataWrapper.AddParameter("@errMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_UpdatePackageDetails");
if (ObjErrMsg != null && ObjErrMsg.Value != null)
{
errMsg = Convert.ToString(ObjErrMsg.Value);
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing UpdatePackage in FormFackageFactor.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(errMsg);
}
public override List <LoanRange> GetLoanRange()
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
_dataSet = new DataSet();
var objBankList = new List <LoanRange>();
try
{
_dataSet = _objDataWrapper.ExecuteDataSet("Aj_Proc_GetLoanRange");
objBankList = BindLoanRange(_dataSet.Tables[0]);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetLoanRange in Bank.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objBankList);
}
public override List <PackageMaster> GetAllPackage()
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
_dataSet = new DataSet();
var objPackageFactorList = new List <PackageMaster>();
try
{
_dataSet = _objDataWrapper.ExecuteDataSet("Aj_PackageList");
objPackageFactorList = BindPackageDetails(_dataSet.Tables[0]);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetAllPackage in FormFackageFactor.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objPackageFactorList);
}
public override List <CoursePaymentMasterProperty> GetCoursePaymentMasterList()
{
var CoursePaymentMasterList = new List <CoursePaymentMasterProperty>();
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
_dataSet = new DataSet();
try
{
_dataSet = _objDataWrapper.ExecuteDataSet("Aj_Proc_GetCoursePaymentMasterList");
CoursePaymentMasterList = BindCoursePaymentMasterObject(_dataSet.Tables[0]);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetAllCoursePaymentList in Course.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(CoursePaymentMasterList);
}
public override int UpdateCoursePaymentMasterDetails(int PaymentCourseId, int CourseId, string OnlinePaymentAmount, string OfflinePaymentAmount, out string errMsg, int createdBy)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errMsg = string.Empty;
try
{
_objDataWrapper.AddParameter("@PaymentCourseId", PaymentCourseId);
_objDataWrapper.AddParameter("@CourseId", CourseId);
_objDataWrapper.AddParameter("@OnlinePaymentAmount", OnlinePaymentAmount);
_objDataWrapper.AddParameter("@OfflinePaymentAmount", OfflinePaymentAmount);
_objDataWrapper.AddParameter("@createdBy", createdBy);
var objErrmsg =
(SqlParameter)
(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.NVarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateCoursePaymentMaster");
if (objErrmsg != null && objErrmsg.Value != null)
{
errMsg = Convert.ToString(objErrmsg.Value);
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing UpdateCoursePayment in Course.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
public string GetQuizz(int id)
{
var quizz = new Quizz();
using (var dbWrapper = new DbWrapper("studybuddyquizzes"))
{
using (var command = new SQLiteCommand("SELECT QuizzName, Description FROM Quizzes WHERE QuizzID = @id")
)
{
command.Parameters.AddWithValue("@id", id);
var reader = dbWrapper.ExecuteReader(command);
while (reader.Read())
{
quizz.name = reader.GetString(0);
quizz.description = reader.GetString(1);
}
}
}
using (var dbWrapper = new DbWrapper("studybuddyquizzes"))
{
using (var command = new SQLiteCommand("SELECT QuestionID, Question FROM Questions WHERE QuizzID = @id"))
{
var questionId = 0;
var questions = new List <Quizz.Questions>();
command.Parameters.AddWithValue("@id", id);
var reader = dbWrapper.ExecuteReader(command);
while (reader.Read())
{
var singleQuestion = new Quizz.Questions();
var correctAnswersList = new List <int>();
questionId = reader.GetInt32(0);
singleQuestion.question = reader.GetString(1);
var options = new List <Quizz.Options> ();
using (var internalWrapper = new DbWrapper("studybuddyquizzes"))
{
using (
var innerCommand =
new SQLiteCommand(
"SELECT AnswerID, Answer, Is_Correct FROM Answers WHERE QuestionID = @QId"))
{
innerCommand.Parameters.AddWithValue("@QId", questionId);
var innerReader = internalWrapper.ExecuteReader(innerCommand);
while (innerReader.Read())
{
var option = new Quizz.Options();
option.id = innerReader.GetInt32(0);
option.answer = innerReader.GetString(1);
if (innerReader.GetInt32(2) == 1)
{
correctAnswersList.Add(option.id);
}
options.Add(option);
}
}
}
singleQuestion.options = options.ToArray();
singleQuestion.rightAnswerIds = correctAnswersList.ToArray();
questions.Add(singleQuestion);
}
quizz.questions = questions.ToArray();
}
}
return(JsonConvert.SerializeObject(quizz));
}
public void CreateNewQuizz(Quizz quizzData)
{
using (var dbWrapper = new DbWrapper("studybuddyquizzes"))
{
var quizzId = 0;
if (!dbWrapper.DoesDbExist())
{
InstantiateQuizzDatabase();
}
using (
var command =
new SQLiteCommand(
"INSERT INTO Quizzes (QuizzName, Description) values (@QuizzName, @Description)")
)
{
command.Parameters.AddWithValue("@QuizzName", quizzData.name);
command.Parameters.AddWithValue("@Description", quizzData.description);
dbWrapper.ExecuteNonQuery(command);
command.CommandText =
"SELECT QuizzID FROM Quizzes WHERE QuizzName = @QuizzName";
quizzId = int.Parse(dbWrapper.ExecuteScalar(command).ToString());
}
foreach (var question in quizzData.questions)
{
var questionId = -1;
using (
var command =
new SQLiteCommand(
"INSERT INTO Questions (Question, QuizzID) values (@Question, @QuizzID)")
)
{
command.Parameters.AddWithValue("@QuizzID", quizzId);
command.Parameters.AddWithValue("@Question", question.question);
dbWrapper.ExecuteNonQuery(command);
command.CommandText =
"SELECT QuestionID FROM Questions WHERE Question = @Question AND QuizzID = @QuizzID";
questionId = int.Parse(dbWrapper.ExecuteScalar(command).ToString());
}
foreach (var option in question.options)
{
using (
var command =
new SQLiteCommand(
"INSERT INTO Answers (QuestionID, Answer, Is_Correct) values (@QuestionID, @Answer, @Is_Correct)")
)
{
command.Parameters.AddWithValue("@QuestionID", questionId);
command.Parameters.AddWithValue("@Answer", option.answer);
if (question.rightAnswerIds.Contains(option.id))
{
command.Parameters.AddWithValue("@Is_Correct", 1);
}
else
{
command.Parameters.AddWithValue("@Is_Correct", 0);
}
dbWrapper.ExecuteNonQuery(command);
}
}
}
}
}
public override bool DoLogin(string emailId, string password, out int userTypeId, out int userId, out string userName, out string landingPage, out string mobileNo, out bool canCreateUser, out string errmsg, out bool userStatus)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
var objCrypto = new ClsCrypto(ClsSecurity.GetPasswordPhrase(Common.PassPhraseOne, Common.PassPhraseTwo));
errmsg = "";
userTypeId = 0;
userName = "";
landingPage = "";
mobileNo = "";
userId = 0;
userStatus = false;
canCreateUser = false;
string pwd = "";
try
{
_objDataWrapper.AddParameter("@UserEmailId", emailId);
var objUserStatus =
(SqlParameter)(_objDataWrapper.AddParameter("@UserStatus", "", SqlDbType.Bit, ParameterDirection.Output));
var ObjErrMsg =
(SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
var ObjPassword =
(SqlParameter)(_objDataWrapper.AddParameter("@UserPassword", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
var ObjUserName =
(SqlParameter)(_objDataWrapper.AddParameter("@UserName", "", SqlDbType.VarChar, ParameterDirection.Output, 64));
var ObjUseId =
(SqlParameter)(_objDataWrapper.AddParameter("@UserId", "", SqlDbType.Int, ParameterDirection.Output));
var ObjUseTypeId =
(SqlParameter)(_objDataWrapper.AddParameter("@UserTypeId", "", SqlDbType.Int, ParameterDirection.Output));
var ObjCanCreateUser =
(SqlParameter)(_objDataWrapper.AddParameter("@CanCreateUser", "", SqlDbType.Bit, ParameterDirection.Output));
var ObjUserMobile =
(SqlParameter)(_objDataWrapper.AddParameter("@UserMobileNo", "", SqlDbType.VarChar, ParameterDirection.Output, 32));
var ObjUserLandingPage =
(SqlParameter)(_objDataWrapper.AddParameter("@LandingPage", "", SqlDbType.VarChar, ParameterDirection.Output, 256));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_DoLogin");
if (ObjErrMsg != null && ObjErrMsg.Value != null)
{
errmsg = Convert.ToString(ObjErrMsg.Value);
}
if (ObjPassword != null && ObjPassword.Value != null)
{
pwd = Convert.ToString(ObjPassword.Value);
}
if (ObjUserName != null && ObjUserName.Value != null)
{
userName = Convert.ToString(ObjUserName.Value);
}
if (ObjUseId != null && ObjUseId.Value != null)
{
userId = Convert.ToInt32(ObjUseId.Value);
}
if (ObjUseTypeId != null && ObjUseTypeId.Value != null)
{
userTypeId = Convert.ToInt32(ObjUseTypeId.Value);
}
if (ObjCanCreateUser != null && ObjCanCreateUser.Value != null)
{
canCreateUser = Convert.ToBoolean(ObjCanCreateUser.Value);
}
if (ObjUserMobile != null && ObjUserMobile.Value != null)
{
mobileNo = Convert.ToString(ObjUserMobile.Value);
}
if (ObjUserLandingPage != null && ObjUserLandingPage.Value != null)
{
landingPage = Convert.ToString(ObjUserLandingPage.Value);
}
if (objUserStatus != null && objUserStatus.Value != null)
{
userStatus = Convert.ToBoolean(objUserStatus.Value);
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing DoLogin in UserManager.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
if (userId > 0)
{
pwd = objCrypto.Decrypt(pwd);
if (pwd.Equals(password))
{
return(true);
}
else
{
errmsg = "Re-check your password.";
return(false);
}
}
else
{
return(false);
}
}
public async void Initialize()
{
IsOperationInProgress = true;
DbWrapper = new DbWrapper();
UserManager = new UserManager(DbWrapper);
if (VacationMasters.MainPage.search_criterion == 1)
{
List = new ObservableCollection <Package>(DbWrapper.GetPackagesByName(VacationMasters.MainPage.pk_name));
}
if (VacationMasters.MainPage.search_criterion == 2)
{
List = new ObservableCollection <Package>(DbWrapper.GetPackagesByPrice(VacationMasters.MainPage.pk_min_price, VacationMasters.MainPage.pk_max_price));
}
if (VacationMasters.MainPage.search_criterion == 3)
{
List = new ObservableCollection <Package>(DbWrapper.GetPackagesByDate(VacationMasters.MainPage.pk_begin_date, VacationMasters.MainPage.pk_end_date));
}
if (VacationMasters.MainPage.search_criterion == 4)
{
List = new ObservableCollection <Package>(DbWrapper.getPackagesByType(VacationMasters.MainPage.pk_type));
}
if (VacationMasters.MainPage.search_criterion == 5)
{
List = new ObservableCollection <Package>(DbWrapper.getPackagesByPriceDate(VacationMasters.MainPage.pk_min_price,
VacationMasters.MainPage.pk_max_price,
VacationMasters.MainPage.pk_begin_date,
VacationMasters.MainPage.pk_end_date));
}
if (VacationMasters.MainPage.search_criterion == 6)
{
List = new ObservableCollection <Package>(DbWrapper.getPackagesByPriceType(VacationMasters.MainPage.pk_min_price,
VacationMasters.MainPage.pk_max_price,
VacationMasters.MainPage.pk_type));
}
if (VacationMasters.MainPage.search_criterion == 7)
{
List = new ObservableCollection <Package>(DbWrapper.getPackagesByDateType(VacationMasters.MainPage.pk_begin_date,
VacationMasters.MainPage.pk_end_date,
VacationMasters.MainPage.pk_type));
}
if (VacationMasters.MainPage.search_criterion == 8)
{
List = new ObservableCollection <Package>(DbWrapper.getPackagesByNamePrice(VacationMasters.MainPage.pk_name,
VacationMasters.MainPage.pk_min_price,
VacationMasters.MainPage.pk_max_price));
}
if (VacationMasters.MainPage.search_criterion == 9)
{
List = new ObservableCollection <Package>(DbWrapper.getPackagesByNameDate(VacationMasters.MainPage.pk_name,
VacationMasters.MainPage.pk_begin_date,
VacationMasters.MainPage.pk_end_date));
}
if (VacationMasters.MainPage.search_criterion == 10)
{
List = new ObservableCollection <Package>(DbWrapper.getPackagesByNameType(VacationMasters.MainPage.pk_name, VacationMasters.MainPage.pk_type));
}
if (VacationMasters.MainPage.search_criterion == 11)
{
List = new ObservableCollection <Package>(DbWrapper.getPackagesByNamePriceDate(VacationMasters.MainPage.pk_name,
VacationMasters.MainPage.pk_min_price,
VacationMasters.MainPage.pk_max_price,
VacationMasters.MainPage.pk_begin_date,
VacationMasters.MainPage.pk_end_date));
}
if (VacationMasters.MainPage.search_criterion == 12)
{
List = new ObservableCollection <Package>(DbWrapper.getPackagesByNamePriceType(VacationMasters.MainPage.pk_name,
VacationMasters.MainPage.pk_min_price,
VacationMasters.MainPage.pk_max_price,
VacationMasters.MainPage.pk_type));
}
if (VacationMasters.MainPage.search_criterion == 13)
{
List = new ObservableCollection <Package>(DbWrapper.getPackagesByNameDateType(VacationMasters.MainPage.pk_name,
VacationMasters.MainPage.pk_begin_date,
VacationMasters.MainPage.pk_end_date,
VacationMasters.MainPage.pk_type));
}
if (VacationMasters.MainPage.search_criterion == 14)
{
List = new ObservableCollection <Package>(DbWrapper.getPackagesByPriceDateType(VacationMasters.MainPage.pk_min_price,
VacationMasters.MainPage.pk_max_price,
VacationMasters.MainPage.pk_begin_date,
VacationMasters.MainPage.pk_end_date,
VacationMasters.MainPage.pk_type));
}
if (VacationMasters.MainPage.search_criterion == 15)
{
List = new ObservableCollection <Package>(DbWrapper.getPackagesByAll(VacationMasters.MainPage.pk_name,
VacationMasters.MainPage.pk_min_price,
VacationMasters.MainPage.pk_max_price,
VacationMasters.MainPage.pk_begin_date,
VacationMasters.MainPage.pk_end_date,
VacationMasters.MainPage.pk_type));
}
IsOperationInProgress = false;
}
public FormReplacement(DbWrapper wrapper)
{
InitializeComponent();
_dbWrapper = wrapper;
}
public UserAuthorizationController(ITokenizer tokenizer)
{
Post["/login/"] = x =>
{
using (var dbWrapper = new DbWrapper("AuthenticationDbCore"))
{
if (!dbWrapper.DoesDbExist())
{
StudyBuddyDbAssistant.CreateDatabase("AuthenticationDbCore");
StudyBuddyDbAssistant.CreateAuthenticationTables("AuthenticationDbCore");
}
}
var loginData = ParseAuthData(Request.Body);
var identity = AuthenticationSingleton.AuthenticateUser(loginData["username"],
loginData["password"]);
if (identity == null)
{
var response = (Response)JsonConvert.SerializeObject(FormErrorResponse(-1));
response.ContentType = "application/json";
response.StatusCode = HttpStatusCode.NotAcceptable;
return(response);
}
else
{
var token = tokenizer.Tokenize(identity, Context);
return(new
{
Token = token
});
}
};
Post["/register/"] = x =>
{
var regData = ParseAuthData(Request.Body);
var authenticationStatus = AuthenticationSingleton.RegisterUser(regData["username"], regData["password"]);
if (authenticationStatus != 0)
{
var response = (Response)JsonConvert.SerializeObject(FormErrorResponse(authenticationStatus));
response.ContentType = "application/json";
response.StatusCode = HttpStatusCode.NotAcceptable;
return(response);
}
using (var dbWrapper = new DbWrapper("AuthenticationDbCore"))
{
if (!dbWrapper.DoesDbExist())
{
StudyBuddyDbAssistant.CreateDatabase("AuthenticationDbCore");
StudyBuddyDbAssistant.CreateAuthenticationTables("AuthenticationDbCore");
}
}
var identity = AuthenticationSingleton.AuthenticateUser(regData["username"],
regData["password"]);
if (identity == null)
{
var response = (Response)JsonConvert.SerializeObject(FormErrorResponse(-1));
response.ContentType = "application/json";
response.StatusCode = HttpStatusCode.NotAcceptable;
return(response);
}
else
{
var token = tokenizer.Tokenize(identity, Context);
return(new
{
Token = token
});
}
};
}
private void Search(object sender, RoutedEventArgs e)
{
if (!String.IsNullOrEmpty(name.Text) && String.IsNullOrEmpty(min_price.Text) && String.IsNullOrEmpty(max_price.Text) &&
begin_date.Date == DateTimeOffset.MinValue && end_date.Date == DateTimeOffset.MinValue &&
type_combo.SelectedItem == null)
{
var packages = DbWrapper.GetPackagesByName(name.Text);
foreach (Package pack in packages)
{
//set gridview components
}
}
if (String.IsNullOrEmpty(name.Text) && !String.IsNullOrEmpty(min_price.Text) && !String.IsNullOrEmpty(max_price.Text) &&
begin_date.Date == DateTimeOffset.MinValue && end_date.Date == DateTimeOffset.MinValue &&
type_combo.SelectedItem == null)
{
var packages = DbWrapper.GetPackagesByPrice(Convert.ToInt32(min_price.Text), Convert.ToInt32(max_price.Text));
foreach (Package pack in packages)
{
//set gridview components
}
}
if (String.IsNullOrEmpty(name.Text) && String.IsNullOrEmpty(min_price.Text) && String.IsNullOrEmpty(max_price.Text) &&
begin_date.Date != DateTimeOffset.MinValue && end_date.Date != DateTimeOffset.MinValue &&
type_combo.SelectedItem == null)
{
var packages = DbWrapper.GetPackagesByDate(begin_date.Date.DateTime, end_date.Date.DateTime);
foreach (Package pack in packages)
{
//set gridview components
}
}
if (String.IsNullOrEmpty(name.Text) && String.IsNullOrEmpty(min_price.Text) && String.IsNullOrEmpty(max_price.Text) &&
begin_date.Date == DateTimeOffset.MinValue && end_date.Date == DateTimeOffset.MinValue &&
type_combo.SelectedItem != null)
{
var packages = DbWrapper.getPackagesByType(type_combo.SelectedValue.ToString());
foreach (Package pack in packages)
{
//set gridview components
}
}
if (String.IsNullOrEmpty(name.Text) && !String.IsNullOrEmpty(min_price.Text) && !String.IsNullOrEmpty(max_price.Text) &&
begin_date.Date != DateTimeOffset.MinValue && end_date.Date != DateTimeOffset.MinValue &&
type_combo.SelectedItem == null)
{
var packages = DbWrapper.getPackagesByPriceDate(Convert.ToInt32(min_price.Text), Convert.ToInt32(max_price.Text),
begin_date.Date.DateTime, end_date.Date.DateTime);
foreach (Package pack in packages)
{
//set gridview components
}
}
if (String.IsNullOrEmpty(name.Text) && !String.IsNullOrEmpty(min_price.Text) && !String.IsNullOrEmpty(max_price.Text) &&
begin_date.Date == DateTimeOffset.MinValue && end_date.Date == DateTimeOffset.MinValue &&
type_combo.SelectedItem != null)
{
var packages = DbWrapper.getPackagesByPriceType(Convert.ToInt32(min_price.Text), Convert.ToInt32(max_price.Text),
type_combo.SelectedValue.ToString());
foreach (Package pack in packages)
{
//set gridview components
}
}
if (String.IsNullOrEmpty(name.Text) && String.IsNullOrEmpty(min_price.Text) && String.IsNullOrEmpty(max_price.Text) &&
begin_date.Date != DateTimeOffset.MinValue && end_date.Date != DateTimeOffset.MinValue &&
type_combo.SelectedItem != null)
{
var packages = DbWrapper.getPackagesByDateType(begin_date.Date.DateTime, end_date.Date.DateTime, type_combo.SelectedValue.ToString());
foreach (Package pack in packages)
{
//set gridview components
}
}
if (!String.IsNullOrEmpty(name.Text) && !String.IsNullOrEmpty(min_price.Text) && !String.IsNullOrEmpty(max_price.Text) &&
begin_date.Date == DateTimeOffset.MinValue && end_date.Date == DateTimeOffset.MinValue &&
type_combo.SelectedItem == null)
{
var packages = DbWrapper.getPackagesByNamePrice(name.Text, Convert.ToInt32(min_price.Text), Convert.ToInt32(min_price.Text));
foreach (Package pack in packages)
{
//set gridview components
}
}
if (!String.IsNullOrEmpty(name.Text) && String.IsNullOrEmpty(min_price.Text) && String.IsNullOrEmpty(max_price.Text) &&
begin_date.Date != DateTimeOffset.MinValue && end_date.Date != DateTimeOffset.MinValue &&
type_combo.SelectedItem == null)
{
var packages = DbWrapper.getPackagesByNameDate(name.Text, begin_date.Date.DateTime, end_date.Date.DateTime);
foreach (Package pack in packages)
{
//set gridview components
}
}
if (!String.IsNullOrEmpty(name.Text) && String.IsNullOrEmpty(min_price.Text) && String.IsNullOrEmpty(max_price.Text) &&
begin_date.Date == DateTimeOffset.MinValue && end_date.Date == DateTimeOffset.MinValue &&
type_combo.SelectedItem != null)
{
var packages = DbWrapper.getPackagesByNameType(name.Text, type_combo.SelectedValue.ToString());
foreach (Package pack in packages)
{
//set gridview components
}
}
if (!String.IsNullOrEmpty(name.Text) && !String.IsNullOrEmpty(min_price.Text) && !String.IsNullOrEmpty(max_price.Text) &&
begin_date.Date != DateTimeOffset.MinValue && end_date.Date != DateTimeOffset.MinValue &&
type_combo.SelectedItem == null)
{
var packages = DbWrapper.getPackagesByNamePriceDate(name.Text, Convert.ToInt32(min_price), Convert.ToInt32(max_price),
begin_date.Date.DateTime, end_date.Date.DateTime);
foreach (Package pack in packages)
{
//set gridview components
}
}
if (!String.IsNullOrEmpty(name.Text) && !String.IsNullOrEmpty(min_price.Text) && !String.IsNullOrEmpty(max_price.Text) &&
begin_date.Date == DateTimeOffset.MinValue && end_date.Date == DateTimeOffset.MinValue &&
type_combo.SelectedItem != null)
{
var packages = DbWrapper.getPackagesByNamePriceType(name.Text, Convert.ToInt32(min_price), Convert.ToInt32(max_price),
type_combo.SelectedValue.ToString());
foreach (Package pack in packages)
{
//set gridview components
}
}
if (!String.IsNullOrEmpty(name.Text) && String.IsNullOrEmpty(min_price.Text) && String.IsNullOrEmpty(max_price.Text) &&
begin_date.Date != DateTimeOffset.MinValue && end_date.Date != DateTimeOffset.MinValue &&
type_combo.SelectedItem != null)
{
var packages = DbWrapper.getPackagesByNameDateType(name.Text, begin_date.Date.DateTime, end_date.Date.DateTime,
type_combo.SelectedValue.ToString());
foreach (Package pack in packages)
{
//set gridview components
}
}
if (String.IsNullOrEmpty(name.Text) && !String.IsNullOrEmpty(min_price.Text) && !String.IsNullOrEmpty(max_price.Text) &&
begin_date.Date != DateTimeOffset.MinValue && end_date.Date != DateTimeOffset.MinValue &&
type_combo.SelectedItem != null)
{
var packages = DbWrapper.getPackagesByPriceDateType(Convert.ToInt32(min_price), Convert.ToInt32(max_price),
begin_date.Date.DateTime, end_date.Date.DateTime,
type_combo.SelectedValue.ToString());
foreach (Package pack in packages)
{
//set gridview components
}
}
if (!String.IsNullOrEmpty(name.Text) && !String.IsNullOrEmpty(min_price.Text) && !String.IsNullOrEmpty(max_price.Text) &&
begin_date.Date != DateTimeOffset.MinValue && end_date.Date != DateTimeOffset.MinValue &&
type_combo.SelectedItem != null)
{
var packages = DbWrapper.getPackagesByAll(name.Text, Convert.ToInt32(min_price), Convert.ToInt32(max_price),
begin_date.Date.DateTime, end_date.Date.DateTime,
type_combo.SelectedValue.ToString());
foreach (Package pack in packages)
{
//set gridview components
}
}
}
private void Initialize()
{
DbWrapper = new DbWrapper();
UserManager = new UserManager(DbWrapper);
var list = DbWrapper.getRandomPackages();
}
