// GET api/DriverController
/// <summary>
/// To pass the Id of the person if the firstName and LastName exists
/// </summary>
/// <param name="firstName">First Name of the Passenger</param>
/// <param name="lastName">Last Name of the Passenger</param>
/// <returns>
/// <param name="status">Status of the API request</param>
/// <param name="message">Response message if the Id exists or not</param>
/// </returns>
public Response Get(string firstName, string lastName)
{
AppDao dbobj = new AppDao();
Response responseobj = new Response();
DataSet dsResult = new DataSet();
try
{
string query = "SELECT Id FROM Person WHERE first_name = '" + firstName + "' AND last_name = '" + lastName + "'";
Identifier resultObj = new Identifier();
resultObj = dbobj.GetDriverId(query);
if (resultObj != null)
{
responseobj.status = "Sucess";
responseobj.message = resultObj.Id;
}
else
{
responseobj.status = "Failed";
responseobj.message = "No user with the FirstName ='" + firstName + "' and LastName = '" + lastName + "' exists";
}
}
catch (Exception ex)
{
responseobj.status = "Failed";
responseobj.message = "Driver adding Failed with error -> " + ex.Message;
}
return(responseobj);
}
// POST api/RideController
/// <summary>
/// To update the travel history table and other tables as the ride has been completed
/// </summary>
/// <param name="passanger_id"></param>
/// <param name="vehicle_id"></param>
/// <param name="start_location_lat"></param>
/// <param name="start_location_Lon"></param>
/// <param name="end_location_lat"></param>
/// <param name="end_location_Lon"></param>
/// <param name="final_fare"></param>
/// <param name="estimated_fare"></param>
/// <returns>
/// <param name="status">Status of the API request</param>
/// <param name="message">Response message</param>
/// </returns>
public Response Post([FromBody] RideCompleted value)
{
AppDao dbobj = new AppDao();
Response responseobj = new Response();
try
{
//Update the data as the cab ride is completed
string query = "INSERT INTO Travel_History VALUES(" + value.passanger_id + "," + value.vehicle_id + "," + value.start_location_lat + "," + value.start_location_Lon + "," + value.end_location_lat + "," + value.end_location_Lon + "," + value.estimated_fare + "," + value.final_fare + ")";
dbobj.Execute(query);
//delete record from vehicle location as the cab is nt avaiable for sharing
query = "DELETE FROM Vehicle_Location WHERE vehicle_id = " + value.vehicle_id + "";
dbobj.Execute(query);
//update the Vehicle table to make the cab status as avaiable
query = "UPDATE Vehicle SET ride_in_progress = 0,ideal_location_lat =" + value.end_location_lat + ", ideal_location_lon=" + value.end_location_Lon + " WHERE is_active = 1 AND person_id = " + value.passanger_id + " AND id = " + value.vehicle_id + "";
dbobj.Execute(query);
responseobj.status = "Sucess";
responseobj.message = "Ride Completed SuccussFully";
}
catch (Exception ex)
{
responseobj.status = "Failed";
responseobj.message = "Completing a cab Failed with error -> " + ex.Message;
}
return(responseobj);
}
protected void b_Click(object sender, EventArgs e)
{
AppUser appUserObj = new AppUser();
appUserObj.username = usernameTb.Text;
appUserObj.pwd = passwordTb.Text;
String pwdConfirm = ConfirmPwdTb.Text;
Boolean isError = false;
if (!appUserObj.pwd.Equals(pwdConfirm))
{
confirmPwdError.Text = "Confirm Password did not match.";
isError = true;
}
if (isError)
{
return;
}
AppDao daoObj = new AppDao();
daoObj.updatedPassword(appUserObj);
Session["FIRST_LOGIN"] = false;
Response.Redirect("PageRedirection.aspx");
}
public void sendEmail(AppEmailData emailDataObj)
{
try
{
AppDao appDaoObj = new AppDao();
AppEmailConfiguration emailConfigObj = appDaoObj.getEmailConfiguration();
SmtpClient SmtpServer = new SmtpClient(emailConfigObj.smtpHost);
var mail = new System.Net.Mail.MailMessage();
mail.From = new MailAddress(emailConfigObj.fromAddress);
mail.To.Add(emailDataObj.toAddress);
if (emailDataObj.ccAddress != null && !emailDataObj.ccAddress.Equals(""))
{
mail.CC.Add(emailDataObj.ccAddress);
}
mail.Subject = emailDataObj.subject;
mail.IsBodyHtml = true;
string htmlBody;
htmlBody = emailDataObj.bodyHtml;
mail.Body = htmlBody;
SmtpServer.UseDefaultCredentials = false;
SmtpServer.Credentials = new System.Net.NetworkCredential(emailConfigObj.fromAddress, emailConfigObj.fromPassword);
SmtpServer.EnableSsl = true;
SmtpServer.Send(mail);
}
catch (Exception ex)
{
LogUtils.myLog.Info("Email while sending error : ", ex);
}
}
// GET api/RideController
/// <summary>
/// To fetch the travel history for the passenger and driver
/// </summary>
/// <param name="Id"></param>
/// <param name="type">Cab Type</param>
/// <returns>
/// <param name="status">Status of the API request</param>
/// <param name="message">Response message</param>
/// </returns>
public Response Get(int Id, string type)
{
AppDao dbobj = new AppDao();
Response responseobj = new Response();
Response_Travel_History resultobj = new Response_Travel_History();
try
{
string query;
//Fetch the travel history for the specfied person_id
if (string.Compare(type, "Passenger") == 0)
{
//Passenger is given the vehicle id
query = "SELECT COUNT(Vehicle_id) as number_of_rides, start_location_lat,start_location_lon,end_location_lat,end_location_lon FROM Travel_History WHERE Vehicle_id = " + Id + "";
resultobj = dbobj.GetTravelDetails(query);
}
else if (string.Compare(type, "Driver") == 0)
{
//Driver has given the passenger id
query = "SELECT COUNT(Passenger_id) as number_of_rides, start_location_lat,start_location_lon,end_location_lat,end_location_lon FROM Travel_History WHERE Passenger_id = " + Id + "";
resultobj = dbobj.GetTravelDetails(query);
}
responseobj.status = "Sucess";
responseobj.message = JsonConvert.SerializeObject(resultobj);
}
catch (Exception ex)
{
responseobj.status = "Failed";
responseobj.message = "Travel history Failed with error -> " + ex.Message;
}
return(responseobj);
}
protected void fillSODropDown(String cloId)
{
DropDownList4.Items.Clear();
AppDao appDaoObj = new AppDao();
List<AppSO> SOList = appDaoObj.getSOList(cloId);
if (SOList != null)
{
foreach (AppSO SO in SOList)
{
ListItem att2 = new ListItem();
String soStatemnet = SO.statement.ToString();
if (soStatemnet.Length > 135)
{
soStatemnet = soStatemnet.Substring(0, 135) + "...";
}
att2.Value = SO.id.ToString();
att2.Text = soStatemnet;
DropDownList4.Items.Add(att2);
}
DropDownList4.SelectedIndex = 0;
}
}
private void loadUsersList()
{
AppDao queDaoObj = new AppDao();
List <AppUser> quesList = queDaoObj.getListOfUsers();
usersList.DataSource = quesList;
usersList.DataBind();
}
private void LoadRule()
{
var list = new AppDao().List <AppDvo>(null);
foreach (var item in list)
{
_List.Add(item);
}
}
public ActionResult Index(string key)
{
//TODO check login
AppDao appDao = new AppDao();
List <App> apps = appDao.GetApps(key);
ViewData["Apps"] = apps;
ViewBag.Title = "Gripsストア";
return(View());
}
public JsonResult RegisterApp(string staffCode, string appId, string appName, string appDescription, string appIcon)
{
AppDao appDao = new AppDao();
App app = new App
{
appId = appId,
name = appName,
description = appDescription,
icon = appIcon
};
return(Json(appDao.Create(staffCode, app)));
}
public ActionResult Edit(string id)
{
AppDao appDao = new AppDao();
App app = appDao.GetApp(id);
ViewData["App"] = app;
if (app != null)
{
ViewBag.Title = app.name + " － 編集";
}
ViewBag.PageId = id;
return(View(app));
}
// POST api/DriverController
/// <summary>
/// To register the driver
/// </summary>
/// <param name="userInfo">
/// <param name="first_name"></param>
/// <param name="last_name"></param>
/// <param name="primary_phone_number"></param>
/// </param>
/// <param name="registration_number"></param>
/// <param name="vin"></param>
/// <param name="passenger_capacity"></param>
/// <param name="ride_in_progress"></param>
/// <param name="ideal_location_lat"></param>
/// <param name="ideal_location_lon"></param>
/// <returns>
/// <param name="status">Status of the API request</param>
/// <param name="message">Response message</param>
/// </returns>
public Response Post([FromBody] Driver obj)
{
AppDao dbobj = new AppDao();
Person newUser = new Person();
Vehicle newVehicle = new Vehicle();
Response responseobj = new Response();
try
{
int driverId;
responseobj = Get(obj.userInfo.first_name, obj.userInfo.last_name);
if (responseobj.status == "Sucess" && !responseobj.message.Contains("No user with"))
{
responseobj.status = "Failed";
responseobj.message = "Driver already Exists";
}
else
{
newUser.first_name = obj.userInfo.first_name;
newUser.last_name = obj.userInfo.last_name;
newUser.primary_phone_number = obj.userInfo.primary_phone_number;
dbobj.Create(newUser);
responseobj = Get(newUser.first_name, newUser.last_name);
driverId = Convert.ToInt32(responseobj.message);
newVehicle.ideal_location_lat = obj.ideal_location_lat;
newVehicle.ideal_location_lon = obj.ideal_location_lon;
newVehicle.passenger_capacity = obj.passenger_capacity;
newVehicle.vin = obj.vin;
newVehicle.registration_number = obj.registration_number;
newVehicle.ride_in_progress = false;
newVehicle.person_id = driverId;
dbobj.Create(newVehicle);
responseobj.status = "Sucess";
responseobj.message = "Driver added Successfully";
}
}
catch (Exception ex)
{
responseobj.status = "Failed";
responseobj.message = "Driver adding Failed with error -> " + ex.Message;
}
return(responseobj);
}
// POST api/BookCabController
/// <summary>
/// To Book a cab for the Passenger
/// </summary>
/// <param name="passangerId"></param>
/// <param name="current_Lat"></param>
/// <param name="current_Lon"></param>
/// <param name="cab_Type"></param>
/// <param name="destination_lat"></param>
/// <param name="destination_Lon"></param>
/// <returns>
/// <param name="status">Status of the API request</param>
/// <param name="message">Response message</param>
/// </returns>
public Response Post([FromBody] BookCab value)
{
AppDao dbobj = new AppDao();
Response responseobj = new Response();
Identifier resultObj = new Identifier();
SelectedDriver selectedCabObj = new SelectedDriver();
Person selectedDriver = new Person();
BookCabResponse returnObj = new BookCabResponse();
try
{
//To Fetch the vehicle_Type id for the cab type
string query = "SELECT Id FROM Vehicle_Type WHERE type = '" + value.cab_Type + "'";
resultObj = dbobj.GetVehicleTypeId(query);
//To Fetch the cab details if available
query = "SELECT person_id as id, id AS vehicle_id , registration_number,ideal_location_lat AS driver_lat,ideal_location_lon AS driver_lon,passenger_capacity FROM Vehicle WHERE is_active = 1 AND person_id != " + value.passangerId + " AND ride_in_progress = 0 ORDER BY ((" + value.current_Lat + " - ideal_location_lat) * (" + value.current_Lat + " - ideal_location_lat) + (" + value.current_Lon + " - ideal_location_lon) * (" + value.current_Lon + " - ideal_location_lon)) LIMIT 1; ";
selectedCabObj = dbobj.GetCab(query);
//Insert the vehicle details in the vehicle location table as the cab has been booked
query = "INSERT INTO Vehicle_Location Values(" + selectedCabObj.driver_lat + "," + selectedCabObj.driver_lon + "," + value.current_Lat + "," + value.current_Lon + "," + (selectedCabObj.passenger_capacity - 1) + "," + selectedCabObj.vehicle_id + "," + resultObj.Id + ")";
dbobj.Execute(query);
//Update Ride in Progress status
query = "UPDATE Vehicle SET ride_in_progress = 1 WHERE is_active = 1 AND person_id = " + selectedCabObj.Id + " AND id = " + selectedCabObj.vehicle_id + "";
dbobj.Execute(query);
//Get the driver Name and phone number for the passenger
query = "SELECT first_name,last_name,primary_phone_number FROM Person WHERE Id = " + selectedCabObj.Id + "";
selectedDriver = dbobj.GetDriverDetails(query);
//Get the estimated Fare
double estimatedFare = dbobj.EstimatedFare(value.current_Lat, value.current_Lon, value.destination_lat, value.destination_Lon, value.cab_Type);
returnObj.first_name = selectedDriver.first_name;
returnObj.last_name = selectedDriver.last_name;
returnObj.driver_phone_number = selectedDriver.primary_phone_number;
returnObj.estimated_fare = estimatedFare;
responseobj.status = "Success";
responseobj.message = JsonConvert.SerializeObject(returnObj);
}
catch (Exception ex)
{
responseobj.status = "Failed";
responseobj.message = "Booking a cab Failed with error -> " + ex.Message;
}
return(responseobj);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
AppDao appDaoObj = new AppDao();
List <AppProgram> progList = appDaoObj.getProgramList();
foreach (AppProgram prog in progList)
{
ListItem att2 = new ListItem();
att2.Value = prog.programId.ToString();
att2.Text = prog.programName;
DropDownList1.Items.Add(att2);
}
fillCourseDropDown(DropDownList1.SelectedValue);
}
}
private void SaveButton_Click(object sender, RoutedEventArgs e)
{
try
{
var appDao = new AppDao();
appDao.DeleteApp();
Helper.App.Id = this.AppId.Text;
Helper.App.BaseUrl = this.BaseUrl.Text;
Helper.App.UseWebView = this.UseWebView.SelectedIndex == 0;
appDao.InsertApp(Helper.App);
Helper.ReInit();
Helper.ShowMessageDialog("Message", "Save ok.");
}
catch (Exception ex)
{
Helper.LogException(ex);
}
}
protected void fillCourseDropDown(String programId)
{
DropDownList2.Items.Clear();
AppDao appDaoObj = new AppDao();
List <AppCourse> courseList = appDaoObj.getCourseList(programId);
if (courseList != null)
{
foreach (AppCourse course in courseList)
{
ListItem att2 = new ListItem();
att2.Value = course.courseId.ToString();
att2.Text = course.courseName.ToString();
DropDownList2.Items.Add(att2);
}
}
}
protected void fillCLODropDown(String courseId)
{
DropDownList3.Items.Clear();
AppDao appDaoObj = new AppDao();
List <AppCLO> CLOList = appDaoObj.getCLOList(courseId);
if (CLOList != null)
{
foreach (AppCLO CLO in CLOList)
{
ListItem att2 = new ListItem();
att2.Value = CLO.cloId.ToString();
att2.Text = CLO.cloStatement.ToString();
DropDownList3.Items.Add(att2);
}
}
}
protected void fillCourseTopicDropDownByCloId(String cloId)
{
DropDownList5.Items.Clear();
AppDao appDaoObj = new AppDao();
List<AppCourseTopic> CLOList = appDaoObj.getCourseTopicListByCloId(cloId);
if (CLOList != null)
{
foreach (AppCourseTopic CLO in CLOList)
{
ListItem att2 = new ListItem();
att2.Value = CLO.id.ToString();
att2.Text = CLO.topic.ToString();
DropDownList5.Items.Add(att2);
}
DropDownList5.SelectedIndex = 0;
}
}
public ActionResult Delete(string id)
{
try
{
var deleteId = id.Split(',');
for (var i = 0; i < deleteId.Length; i++)
{
ApplyitemDao.Delete("APPLYDETAIL_ID", deleteId[i]);
AppDao.Delete("APPLYDETAIL_ID", deleteId[i]);
}
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
LogHelper.ErrorLog("删除出错", ex);
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult AllUndo(string id)
{
try
{
var deleteId = id.Split(',');
for (var i = 0; i < deleteId.Length; i++)
{
ApplyitemDao.Delete("APPLYDETAIL_ID", deleteId[i]);
AppDao.Delete("APPLYDETAIL_ID", deleteId[i]);
}
return(Json(new { isok = true }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
LogHelper.ErrorLog("删除出错", ex);
return(Json(new { isok = false }, JsonRequestBehavior.AllowGet));
}
}
static Helper()
{
var appDao = new AppDao();
App = appDao.GetApp();
if (App == null)
{
App = new Application
{
Id = Guid.NewGuid().ToString()
};
appDao.InsertApp(App);
}
_httpClient.DefaultRequestHeaders.Add("appid", App.Id);
NiologManager.DefaultWriters = new ILogWriter[]
{
new ConsoleLogWriter(),
new FileLogWriter(Path.Combine(ApplicationData.Current.LocalFolder.Path, "logs"), 10)
};
}
// PUT api/BookCabController
/// <summary>
/// To Update the realTime location of the cab for sharing cab service.
/// </summary>
/// <param name="vehicle_id"></param>
/// <param name="location_lat"></param>
/// <param name="location_Lon"></param>
/// <returns>
/// <param name="status">Status of the API request</param>
/// <param name="message">Response message</param>
/// </returns>
public Response Put([FromBody] RealTimeLocationUpdate value)
{
AppDao dbobj = new AppDao();
Response responseobj = new Response();
try
{
string query = "UPDATE Vehicle_Location SET realTime_current_location_lat = " + value.location_lat + ",realTime_current_location_lon = " + value.location_Lon + " WHERE Vehicle_id = " + value.vehicle_id + "";
dbobj.Execute(query);
responseobj.status = "Sucess";
responseobj.message = "Cab Location Updated SuccussFully";
}
catch (Exception ex)
{
responseobj.status = "Failed";
responseobj.message = "Updating the real time location of cab Failed with error -> " + ex.Message;
}
return(responseobj);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
AppDao cmnDaoObj = new AppDao();
List <ListItem> moduleTypeList = cmnDaoObj.getCodeListByCodeTypeId(1900);
removeSuperAdmin(moduleTypeList, 1903);
moduleTypeDdl.Items.AddRange(moduleTypeList.ToArray());
List <ListItem> userTypeList = cmnDaoObj.getCodeListByCodeTypeId(2000);
removeSuperAdmin(userTypeList, 2003);
userTypeDdl.Items.AddRange(userTypeList.ToArray());
AppDao appDaoObj = new AppDao();
List <AppCourse> appCourseList = appDaoObj.getCourseList();
courseDdl.DataSource = appCourseList;
courseDdl.DataTextField = "courseName";
courseDdl.DataValueField = "courseId";
courseDdl.DataBind();
}
}
// POST api/PassengerController
/// <summary>
/// To Register a new Passenger
/// </summary>
/// <param name="first_name">First Name of the Passenger</param>
/// <param name="last_name">Last Name of the Passenger</param>
/// <param name="primary_phone_number">Phone Number of the Passenger</param>
/// <returns>
/// <param name="status">Status of the API request</param>
/// <param name="message">Response message</param>
/// </returns>
public Response Post([FromBody] Person value)
{
AppDao dbobj = new AppDao();
Person newUser = new Person();
Response responseobj = new Response();
DriverController userInfo = new DriverController();
try
{
responseobj = userInfo.Get(value.first_name, value.last_name);
if (responseobj.status == "Sucess" && !responseobj.message.Contains("No user with"))
{
responseobj.status = "Failed";
responseobj.message = "Passanger already Exists";
}
else
{
newUser.first_name = value.first_name;
newUser.last_name = value.last_name;
newUser.primary_phone_number = value.primary_phone_number;
dbobj.Create(newUser);
responseobj.status = "Sucess";
responseobj.message = "User added Successfully";
}
}
catch (Exception ex)
{
responseobj.status = "Failed";
responseobj.message = "User adding Failed with error -> " + ex.Message;
}
return(responseobj);
}
public ActionResult Edit(ApplyDetailModel2 model)
{
try
{
var applyDal = new CHK_STAFF_APPLYDETAIL_DAL();
var item = applyDal.Get(model.APPLYDETAIL_ID);
ApplyitemDao.Delete("APPLYDETAIL_ID", model.APPLYDETAIL_ID);
var BeginTime = Convert.ToDateTime(model.BeginTime);
var EndTime = Convert.ToDateTime(model.EndTime);
item.APPLY_STATE = (byte)6;
item.APPLY_USR_ID = UserState.UserID;
item.AUD_USR_ID = UserState.UserID;
item.BEGIN_TIME = BeginTime.AddHours(model.BeginTimeHours);
item.END_TIME = EndTime.AddHours(model.EndTimeHours);
item.HOLLI_TYP = (byte)model.HOLLI_TYP;
item.APPLY_REASON = model.APPLY_REASON;
var id = AppDao.UpdateObject(item);
var detail = new CHK_STAFF_APPLYITEM()
{
HOLLI_TYP = item.HOLLI_TYP,
APPLY_DATE = item.BEGIN_TIME,
APPLYDETAIL_ID = item.APPLYDETAIL_ID,
CHK_STAFF_ID = item.CHK_STAFF_ID,
A_P_TYP = 1
};
var d = getDiffDays(BeginTime, EndTime);
for (var i = 0; i < d; i++)
{
detail.APPLY_DATE = BeginTime.Date;
detail.A_P_TYP = 1;
ApplyitemDao.AddObject(detail);
detail.A_P_TYP = 2;
ApplyitemDao.AddObject(detail);
BeginTime = BeginTime.AddDays(1);
}
if (model.BeginTimeHours == 8 && model.EndTimeHours >= 12)
{
detail.A_P_TYP = 1;
detail.APPLY_DATE = BeginTime.Date;
ApplyitemDao.AddObject(detail);
}
if (model.BeginTimeHours == 8 && model.EndTimeHours == 17)
{
detail.A_P_TYP = 2;
detail.APPLY_DATE = BeginTime.Date;
ApplyitemDao.AddObject(detail);
}
if (model.BeginTimeHours == 12)
{
detail.A_P_TYP = 2;
detail.APPLY_DATE = BeginTime.Date;
ApplyitemDao.AddObject(detail);
}
Alter("撤消成功！", util.Enum.AlterTypeEnum.Success, false, true);
return(Redirect("/Home/Blank"));
}
catch (Exception ex)
{
LogHelper.ErrorLog("撤消出错。", ex);
ModelState.AddModelError("", "撤消出错。");
return(View(model));
}
}
protected void GenerateQuestions(object sender, EventArgs e)
{
LogUtils.myLog.Info(numberQuestions.Text);
String courseId = Session["CourseID"].ToString();
LogUtils.myLog.Info("Session[\"CourseID\"] : " + Session["CourseID"]);
LogUtils.myLog.Info("Before courseId : " + courseId);
if (courseId == null || courseId == "")
{
courseId = "4";
}
LogUtils.myLog.Info("After courseId : " + courseId);
LogUtils.myLog.Info("Button Generate Questions clicked." + DateTime.Now.ToString());
AppDao appDaoObj = new AppDao();
List <AppCourseTopic> topicList = appDaoObj.getCourseTopicList(courseId);
List <AppCLO> CLOList = appDaoObj.getCLOList(courseId);
QueDao queDaoObj = new QueDao();
String courseIdLocal = Session["CourseID"].ToString();
List <QueAttribute> attrList = queDaoObj.getAttrbuteList(courseIdLocal);
foreach (QueAttribute attr in attrList)
{
attr.optionsList = queDaoObj.getAttributeOptionListByAttrID(attr.attributeID.ToString());
}
foreach (AppCLO clo in CLOList)
{
List <AppSO> SOList = appDaoObj.getSOList(clo.cloId.ToString());
clo.soList = SOList;
}
foreach (AppCourseTopic courseTopic in topicList)
{
LogUtils.myLog.Info("Course Topic : " + courseTopic.topic);
foreach (AppCLO clo in CLOList)
{
LogUtils.myLog.Info("CLO : " + clo.cloStatement);
foreach (AppSO so in clo.soList)
{
LogUtils.myLog.Info("SO : " + so.statement);
QueQuestion queDetails = new QueQuestion();
queDetails.cloId = clo.cloId;
queDetails.soId = so.id;
queDetails.courseTopicId = courseTopic.id;
queDetails.courseId = Int32.Parse(courseId);
queDetails.attrOptionIds = new List <int>();
try
{
SqlConnection myConnection = new SqlConnection(MyConstants.DBConnectionString);
//LogUtils.myLog.Info(MyConstants.DBConnectionString);
myConnection.Open();
display(attrList, attrList.Count, queDetails, myConnection);
myConnection.Close();
}
catch (Exception ex)
{
LogUtils.myLog.Debug(e.ToString(), ex);
}
LogUtils.myLog.Info("After inserting questions. Total Questions : " + totalQuesCount);
}
}
}
/*List<QueAttribute> attrList = new List<QueAttribute>();
* QueAttribute attr1 = new QueAttribute();
* attr1.attributeID = 1;
* attr1.attributeStatement = "Time";
* attr1.optionsList = new List<QueAttributeOption>();
* QueAttributeOption o1 = new QueAttributeOption();
* o1.attributeId = 1;
* o1.optionStatement = "5 mins";
* o1.attributeOptionId = 1;
* attr1.optionsList.Add(o1);
*
* QueAttributeOption o2 = new QueAttributeOption();
* o2.attributeId = 1;
* o2.optionStatement = "10 mins";
* o2.attributeOptionId = 2;
* attr1.optionsList.Add(o2);
*
* QueAttributeOption o5 = new QueAttributeOption();
* o5.attributeId = 1;
* o5.optionStatement = "15 mins";
* o5.attributeOptionId = 5;
* attr1.optionsList.Add(o5);
*
* QueAttribute attr2 = new QueAttribute();
* attr2.attributeID = 1;
* attr2.attributeStatement = "Type";
* attr2.optionsList = new List<QueAttributeOption>();
* QueAttributeOption o3 = new QueAttributeOption();
* o3.attributeId = 2;
* o3.optionStatement = "MCQ";
* o3.attributeOptionId = 1;
* attr2.optionsList.Add(o3);
*
* QueAttributeOption o4 = new QueAttributeOption();
* o4.attributeId = 2;
* o4.optionStatement = "FB";
* o4.attributeOptionId = 2;
* attr2.optionsList.Add(o4);
*
* attrList.Add(attr1);
* attrList.Add(attr2);
* display(attrList, attrList.Count);
*/
}
public JsonResult Delete(string staffCode, string appId)
{
AppDao appDao = new AppDao();
return(Json(appDao.Delete(staffCode, appId)));
}
protected void Page_Load(object sender, EventArgs e)
{
NameValueCollection nvc = Request.Form;
insertIntoSession("uniId", nvc);
insertIntoSession("departId", nvc);
insertIntoSession("uniName", nvc);
insertIntoSession("departName", nvc);
insertIntoSession("courseName", nvc);
insertIntoSession("userId", nvc);
insertIntoSession("userTypeId", nvc);
insertIntoSession("expTypeId", nvc);
insertIntoSession("username", nvc);
insertIntoSession("password", nvc);
if (Session["username"] != null && Session["password"] != null)
{
AppDao appDaoObj = new AppDao();
AppUser appUser = appDaoObj.validateUser(Session["username"].ToString(), Session["password"].ToString());
Session["courseId"] = appUser.courseId;
Session["courseName"] = appUser.course;
if (appUser.username != null)
{
Session["loginStatus"] = true;
if (appUser.instructorTypeId.Equals(2001))
{
Session["userTypeId"] = "1";
}
else if (appUser.instructorTypeId.Equals(2002))
{
Session["userTypeId"] = "2";
}
else
{
Session["userTypeId"] = "3";
}
if (appUser.expertSystemTypeId.Equals(1901))
{
Session["expTypeId"] = "1";
}
else if (appUser.expertSystemTypeId.Equals(1902))
{
Session["expTypeId"] = "2";
}
else
{
Session["expTypeId"] = "3";
}
if (Session["userTypeId"] != null && Session["userTypeId"].ToString() == "1") //Admin
{
if (Session["expTypeId"].ToString() == "1") //QUESTION BANK
{
//FormsAuthentication.RedirectFromLoginPage(username.Text, true);
List <NameValueCollection> menuItems = new List <NameValueCollection>();
NameValueCollection nvc1 = new NameValueCollection();
nvc1["href"] = "QueQuestionAddEditView.aspx";
nvc1["title"] = "Add/Edit Question";
menuItems.Add(nvc1);
nvc1 = new NameValueCollection();
nvc1["href"] = "QueQuestionList.aspx";
nvc1["title"] = "View All Questions";
menuItems.Add(nvc1);
nvc1 = new NameValueCollection();
nvc1["href"] = "QueQuestionAddUpload.aspx";
nvc1["title"] = "Bulk Add Questions";
menuItems.Add(nvc1);
nvc1 = new NameValueCollection();
nvc1["href"] = "QueAttributeList.aspx";
nvc1["title"] = "Question Attributes";
menuItems.Add(nvc1);
Session["menuItems"] = menuItems;
Response.Redirect("/KMSPages/QueQuestionAddEditView");
//FormsAuthenticationTicket tkt;
//string cookiestr;
//HttpCookie ck;
//tkt = new FormsAuthenticationTicket(1, username.Text, DateTime.Now,
// DateTime.Now.AddMinutes(30), true, "your custom data");
//cookiestr = FormsAuthentication.Encrypt(tkt);
//ck = new HttpCookie(FormsAuthentication.FormsCookieName, cookiestr);
//if (true)
// ck.Expires = tkt.Expiration;
//ck.Path = FormsAuthentication.FormsCookiePath;
//Response.Cookies.Add(ck);
//string strRedirect;
//strRedirect = Request["ReturnUrl"];
//if (strRedirect == null)
// strRedirect = "~/default.aspx";
//Response.Redirect(strRedirect, true);
}
else
{
List <NameValueCollection> menuItems = new List <NameValueCollection>();
NameValueCollection nvc1 = new NameValueCollection();
nvc1["href"] = "ImpAskSuggestionOne.aspx";
nvc1["title"] = "Improvement Plan";
menuItems.Add(nvc1);
nvc1 = new NameValueCollection();
nvc1["href"] = "ImpRuleList.aspx";
nvc1["title"] = "Rules";
menuItems.Add(nvc1);
nvc1 = new NameValueCollection();
nvc1["href"] = "ImpRuleQuestionList.aspx";
nvc1["title"] = "Rule Questions";
menuItems.Add(nvc1);
Session["menuItems"] = menuItems;
Response.Redirect("/KMSPages/ImpRuleList.aspx");
}
}
else if (Session["userTypeId"] != null && Session["userTypeId"].ToString() == "2") //Instructor
{
if (Session["expTypeId"].ToString() == "1") //QUESTION BANK
{
//FormsAuthentication.RedirectFromLoginPage(username.Text, true);
List <NameValueCollection> menuItems = new List <NameValueCollection>();
NameValueCollection nvc1 = new NameValueCollection();
nvc1["href"] = "QueFavoriteListAddEdit.aspx";
nvc1["title"] = "Start New/Update Assessment";
menuItems.Add(nvc1);
nvc1 = new NameValueCollection();
nvc1["href"] = "QueQuestionList.aspx";
nvc1["title"] = "View All Questions";
menuItems.Add(nvc1);
nvc1 = new NameValueCollection();
nvc1["href"] = "QueFavQuestionList.aspx";
nvc1["title"] = "View/Edit Assessments";
menuItems.Add(nvc1);
Session["menuItems"] = menuItems;
Response.Redirect("/KMSPages/QueFavoriteListAddEdit");
}
else
{
//FormsAuthentication.RedirectFromLoginPage(username.Text, true);
List <NameValueCollection> menuItems = new List <NameValueCollection>();
NameValueCollection nvc1 = new NameValueCollection();
nvc1["href"] = "ImpAskSuggestionOne.aspx";
nvc1["title"] = "Improvement Plan";
menuItems.Add(nvc1);
Session["menuItems"] = menuItems;
Response.Redirect("/KMSPages/ImpAskSuggestionOne.aspx");
}
}
else if (Session["userTypeId"] != null && Session["userTypeId"].ToString() == "3") //Super Admin
{
List <NameValueCollection> menuItems = new List <NameValueCollection>();
NameValueCollection nvc1 = new NameValueCollection();
nvc1["href"] = "/KMSPages/UserManagement.aspx";
nvc1["title"] = "User";
menuItems.Add(nvc1);
NameValueCollection nvc5 = new NameValueCollection();
nvc5["href"] = "/AppPages/ProgramView.aspx";
nvc5["title"] = "Program";
menuItems.Add(nvc5);
NameValueCollection nvc2 = new NameValueCollection();
nvc2["href"] = "/AppPages/CoursesViews.aspx";
nvc2["title"] = "Course";
menuItems.Add(nvc2);
NameValueCollection nvc4 = new NameValueCollection();
nvc4["href"] = "/AppPages/CourseTopic.aspx";
nvc4["title"] = "Course Topic";
menuItems.Add(nvc4);
NameValueCollection nvc3 = new NameValueCollection();
nvc3["href"] = "/AppPages/CLO.aspx";
nvc3["title"] = "CLO";
menuItems.Add(nvc3);
Session["menuItems"] = menuItems;
Response.Redirect("/KMSPages/UserManagement");
}
}
else
{
Session["loginStatus"] = false;
Response.Redirect("/KMSPages/LoginPage.aspx");
}
}
else
{
Response.Redirect("/KMSPages/LoginPage.aspx");
}
}
protected void b_Click(object sender, EventArgs e)
{
AppUser appUserObj = new AppUser();
appUserObj.username = usernameTb.Text;
appUserObj.pwd = passwordTb.Text;
String pwdConfirm = ConfirmPwdTb.Text;
appUserObj.fullName = fullNameTb.Text;
appUserObj.email = emailTb.Text;
appUserObj.module = moduleTypeDdl.SelectedValue;
appUserObj.userType = userTypeDdl.SelectedValue;
appUserObj.course = courseDdl.SelectedValue;
Boolean isError = false;
if (!appUserObj.pwd.Equals(pwdConfirm))
{
confirmPwdError.Text = "Confirm Password did not match.";
isError = true;
}
DBUtils dbUtils1 = new DBUtils();
SqlDataReader attributeTypeReader1 = dbUtils1.readOperation("SELECT Username FROM Users");
while (attributeTypeReader1.Read())
{
if (attributeTypeReader1[0].ToString().Equals(appUserObj.username))
{
usernameError.Text = "Username already exists";
isError = true;
break;
}
}
dbUtils1.closeDBConnection();
if (isError)
{
return;
}
AppDao appDaoObj = new AppDao();
appUserObj.instructorId = appDaoObj.insertInstructor(appUserObj);
appDaoObj.insertUser(appUserObj);
GeneralUtils guObj = new GeneralUtils();
AppEmailData emailDataObj = new AppEmailData();
emailDataObj.toAddress = appUserObj.email;
emailDataObj.ccAddress = (new AppDao()).getEmailConfiguration().fromAddress;
emailDataObj.subject = "Expert System - Account Created";
emailDataObj.bodyHtml = "Dear " + appUserObj.fullName + ","
+ "<br/><br/>Your account has been successfully created on"
+ " <a href='http://esabet.azurewebsites.net'>Expert System for AEBT</a>"
+ " for the course of " + courseDdl.SelectedItem.Text
+ " with the following credentials:"
+ "<br/><b>Username: </b>" + appUserObj.username
+ "<br/><b>Password: </b>" + appUserObj.pwd
+ "<br/><br/>Please change your password after first login."
+ " If you are not the intended person kindly ignore this email."
+ "<br/><br/>Regards,"
+ "<br/>Admin of Expert System for ABET";
guObj.sendEmail(emailDataObj);
Response.Redirect("UserManagement.aspx");
}
public ActionResult Create(ApplyDetailModel model)
{
if (ModelState.IsValid)
{
try
{
var item = new CHK_STAFF_APPLYDETAIL()
{
APPLY_STATE = (byte)6,
APPLY_TIME = DateTime.Now,
APPLY_USR_ID = UserState.UserID,
AUD_TIME = DateTime.Now,
AUD_USR_ID = UserState.UserID,
BEGIN_TIME = model.BeginTime.AddHours(model.BeginTimeHours),
CHK_STAFF_ID = model.CHK_STAFF_ID,
END_TIME = model.EndTime.AddHours(model.EndTimeHours),
HOLLI_TYP = (byte)model.HOLLI_TYP,
APPLY_REASON = model.APPLY_REASON
};
item = AppDao.AddObject(item);
var detail = new CHK_STAFF_APPLYITEM()
{
HOLLI_TYP = item.HOLLI_TYP,
APPLY_DATE = item.BEGIN_TIME,
APPLYDETAIL_ID = item.APPLYDETAIL_ID,
CHK_STAFF_ID = item.CHK_STAFF_ID,
A_P_TYP = 1
};
var d = getDiffDays(model.BeginTime, model.EndTime);
for (var i = 0; i < d; i++)
{
detail.APPLY_DATE = model.BeginTime.Date;
detail.A_P_TYP = 1;
ApplyitemDao.AddObject(detail);
detail.A_P_TYP = 2;
ApplyitemDao.AddObject(detail);
model.BeginTime = model.BeginTime.AddDays(1);
}
if (model.BeginTimeHours == 8 && model.EndTimeHours >= 12)
{
detail.A_P_TYP = 1;
detail.APPLY_DATE = model.BeginTime.Date;
ApplyitemDao.AddObject(detail);
}
if (model.BeginTimeHours == 8 && model.EndTimeHours == 17)
{
detail.A_P_TYP = 2;
detail.APPLY_DATE = model.BeginTime.Date;
ApplyitemDao.AddObject(detail);
}
if (model.BeginTimeHours == 12)
{
detail.A_P_TYP = 2;
detail.APPLY_DATE = model.BeginTime.Date;
ApplyitemDao.AddObject(detail);
}
Alter("新增成功！", util.Enum.AlterTypeEnum.Success, false, true);
return(Redirect("/Home/Blank"));
}
catch (Exception ex)
{
LogHelper.ErrorLog("新增出错。", ex);
ModelState.AddModelError("", "新增出错。");
return(View(model));
}
}
return(View(model));
}
