public void ProcessRequest(HttpContext context)
{
string response = "";
string functionCall = "";
string callback = "";
ResponseObjectForAnything obj = new ResponseObjectForAnything();
List<SteviArt.Common.DTO.File> lstuploadfile = new List<File>();
if (context.Request.QueryString != null)
{
if (context.Request.QueryString["func"] != null)
functionCall = context.Request.QueryString["func"].ToLower();
else
{
response = "Error! Function Call ('func=...') parameter was not provided.";
goto WriteResponse;
}
//assign the local variable for the callback param...
callback = context.Request.QueryString["callback"];
//we use this in some of the calls...
String ThisCallersIPaddress = "127.0.0.1";
if (context.Request.ServerVariables["remote_addr"] != null)
{
ThisCallersIPaddress = context.Request.ServerVariables["remote_addr"].ToString();
}
switch (functionCall)
{
case "uploadfile":
if (context.Request.Files.Count > 0)
{
HttpFileCollection files = context.Request.Files;
string[] uplaodedfiles = new string[files.Count];
for (int i = 0; i < files.Count; i++)
{
File uploadedfile = new File();
HttpPostedFile file = files[i];
string fname;
if (HttpContext.Current.Request.Browser.Browser.ToUpper() == "IE" || HttpContext.Current.Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER")
{
string[] testfiles = file.FileName.Split(new char[] { '\\' });
fname = testfiles[testfiles.Length - 1];
}
else
{
fname = file.FileName;
}
fname=System.IO.Path.Combine(context.Server.MapPath("~/uploads/"), fname);
file.SaveAs(fname);
uploadedfile.FilePath = fname;
lstuploadfile.Add(uploadedfile);
}
}
context.Response.ContentType = "text/plain";
obj.ResultCode = "SUCCESS";
response = SteviArt.Common.Utilities.Serializer.ObjectToJSON(lstuploadfile);
break;
}
}
WriteResponse:
if (context.Request.QueryString["callback"] != null)
{
context.Response.Write(callback.ToString() + "(" + response + ")");
}
else
{
context.Response.Write(response);
}
}
/// <summary>
/// Get department list.
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="departmentid">string</param>
/// <returns>string</returns>
public string GetPrivateProject(string sessionKey, string privateprojectid, string approvalstatusid)
{
string retValue = string.Empty;
List<PrivateProject> lstdepartment = new List<PrivateProject>();
ResponseObjectForAnything obj = new ResponseObjectForAnything();
int count = 0;
bool isValid = true;
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_GetPrivateProject");
if (!string.IsNullOrEmpty(privateprojectid)) { db.AddInParameter(dbCommand, "@PrivateProjectID", DbType.Int32, Int32.Parse(privateprojectid)); }
else { db.AddInParameter(dbCommand, "@PrivateProjectID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(approvalstatusid)) { db.AddInParameter(dbCommand, "@ApprovalStatusID", DbType.Int32, Int32.Parse(approvalstatusid)); }
else { db.AddInParameter(dbCommand, "@ApprovalStatusID", DbType.Int32, null); }
DataSet dsStates = db.ExecuteDataSet(dbCommand);
if (dsStates.Tables.Count > 0)
{
DataTable tState = dsStates.Tables[0];
foreach (DataRow dr in tState.Rows)
{
PrivateProject department = new PrivateProject();
if (dr["PrivateProjectID"] != DBNull.Value) { department.PrivateProjectID = Int32.Parse(dr["PrivateProjectID"].ToString()); }
if (dr["PersonID"] != DBNull.Value) { department.PersonID = Int32.Parse(dr["PersonID"].ToString()); }
if (dr["ApprovalStatusID"] != DBNull.Value) { department.ApprovalStatusID = Int32.Parse(dr["ApprovalStatusID"].ToString()); }
if (dr["ApprovalStatusName"] != DBNull.Value) { department.ApprovalStatusName = dr["ApprovalStatusName"].ToString(); }
if (dr["VideoFileName"] != DBNull.Value) { department.VideoFileName = dr["VideoFileName"].ToString(); }
if (dr["PhotoURL"] != DBNull.Value) { department.PhotoURL = dr["PhotoURL"].ToString(); }
if (dr["CreatedDate"] != DBNull.Value) { department.CreatedDate = Convert.ToDateTime(dr["CreatedDate"].ToString()); }
if (dr["IsEnabled"] != DBNull.Value) { department.IsEnabled = Convert.ToBoolean(dr["IsEnabled"].ToString()); }
lstdepartment.Add(department);
count++;
}
obj.ResultObjectJSON = Serializer.ObjectToJSON(lstdepartment);
obj.ResultCode = "SUCCESS";
obj.ResultObjectRecordCount = count;
if (obj.ResultObjectRecordCount <= 0) { obj.ResultMessage = "No records found."; }
}
}
catch (Exception ex)
{
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "GetDepartments", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
return Serializer.ObjectToJSON(obj);
}
/// <summary>
/// Get All or specific Help Content
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="helpcontentid">string</param>
/// <returns>string</returns>
public string GetHelpContent(string sessionKey, string helpsubjectid, string helpcontentid)
{
string retValue = string.Empty;
int count = 0;
ContentObject contentobject = new ContentObject();
List<HelpContent> lsthelpcontent = new List<HelpContent>();
List<HelpSubject> lsthelpsubject = new List<HelpSubject>();
List<HelpVideo> lsthelpvideo = new List<HelpVideo>();
ResponseObjectForAnything responseObject = new ResponseObjectForAnything();
bool isValid = true;
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_GetHelpContent");
if (!string.IsNullOrEmpty(helpsubjectid)) { db.AddInParameter(dbCommand, "@HelpSubjectID", DbType.String, helpsubjectid); }
else { db.AddInParameter(dbCommand, "@HelpSubjectID", DbType.String, null); }
if (!string.IsNullOrEmpty(helpcontentid)) { db.AddInParameter(dbCommand, "@HelpContentID", DbType.String, helpcontentid); }
else { db.AddInParameter(dbCommand, "@HelpContentID", DbType.String, null); }
DataSet dsHelpContent = db.ExecuteDataSet(dbCommand);
if (dsHelpContent.Tables.Count > 0)
{
DataTable tHelpContent = dsHelpContent.Tables[0];
foreach (DataRow dr in tHelpContent.Rows)
{
HelpSubject helpsubject = new HelpSubject();
if (dr["HelpSubjectID"] != DBNull.Value) { helpsubject.HelpSubjectID = Int32.Parse(dr["HelpSubjectID"].ToString()); }
if (dr["Title"] != DBNull.Value) { helpsubject.Title = dr["Title"].ToString(); }
if (dr["AudioURL"] != DBNull.Value) { helpsubject.AudioURL = dr["AudioURL"].ToString(); }
lsthelpsubject.Add(helpsubject);
count++;
}
contentobject.HelpSubjects = lsthelpsubject;
}
if (dsHelpContent.Tables.Count > 1)
{
DataTable tHelpContent = dsHelpContent.Tables[1];
foreach (DataRow dr in tHelpContent.Rows)
{
HelpContent helpcontent = new HelpContent();
if (dr["HelpContentID"] != DBNull.Value) { helpcontent.HelpContentID = Int32.Parse(dr["HelpContentID"].ToString()); }
if (dr["HelpSubjectID"] != DBNull.Value) { helpcontent.HelpSubjectID = Int32.Parse(dr["HelpSubjectID"].ToString()); }
if (dr["HelpContentTitle"] != DBNull.Value) { helpcontent.HelpContentTitle = dr["HelpContentTitle"].ToString(); }
if (dr["TitleAudioURL"] != DBNull.Value) { helpcontent.TitleAudioURL = dr["TitleAudioURL"].ToString(); }
if (dr["HTMLContent"] != DBNull.Value) { helpcontent.HTMLContent = dr["HTMLContent"].ToString(); }
if (dr["HTMLContentAudioURL"] != DBNull.Value) { helpcontent.HTMLContentAudioURL = dr["HTMLContentAudioURL"].ToString(); }
lsthelpcontent.Add(helpcontent);
}
contentobject.HelpContents = lsthelpcontent;
}
if (dsHelpContent.Tables.Count > 2)
{
DataTable tHelpVideo = dsHelpContent.Tables[2];
foreach (DataRow dr in tHelpVideo.Rows)
{
HelpVideo helpvideo = new HelpVideo();
if (dr["HelpVideoID"] != DBNull.Value) { helpvideo.HelpVideoID = Int32.Parse(dr["HelpVideoID"].ToString()); }
//if (dr["HelpContentID"] != DBNull.Value) { helpvideo.HelpContentID = Int32.Parse(dr["HelpContentID"].ToString()); }
if (dr["VideoURL"] != DBNull.Value) { helpvideo.VideoURL = dr["VideoURL"].ToString(); }
lsthelpvideo.Add(helpvideo);
}
contentobject.HelpVideos = lsthelpvideo;
}
responseObject.ResultObjectJSON = Serializer.ObjectToJSON(contentobject);
responseObject.ResultCode = "SUCCESS";
responseObject.ResultObjectRecordCount = count;
if (responseObject.ResultObjectRecordCount <= 0) { responseObject.ResultMessage = "No records found."; }
}
catch (Exception ex)
{
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "GetHelpContent", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
return Serializer.ObjectToJSON(contentobject);
}
/// <summary>
/// Get video questions and answers based on
/// video ID.
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="videoid">string</param>
/// <param name="langid">string</param>
/// <returns></returns>
public string GetHelpVideos(string sessionKey, string videoid)
{
string retValue = string.Empty;
int count = 0;
List<HelpVideo> lstvideos = new List<HelpVideo>();
ResponseObjectForAnything responseObject = new ResponseObjectForAnything();
bool isValid = true;
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_GetHelpVideos");
if (!string.IsNullOrEmpty(videoid)) { db.AddInParameter(dbCommand, "@VideoID", DbType.String, videoid); }
else { db.AddInParameter(dbCommand, "@VideoID", DbType.String, null); }
DataSet dsHelpContent = db.ExecuteDataSet(dbCommand);
if (dsHelpContent.Tables.Count > 0)
{
DataTable tHelpContent = dsHelpContent.Tables[0];
foreach (DataRow dr in tHelpContent.Rows)
{
HelpVideo video = new HelpVideo();
if (dr["HelpVideoID"] != DBNull.Value) { video.HelpVideoID = Int32.Parse(dr["HelpVideoID"].ToString()); }
if (dr["HelpModuleID"] != DBNull.Value) { video.HelpModuleID = Int32.Parse(dr["HelpModuleID"].ToString()); }
if (dr["HelpModuleName"] != DBNull.Value) { video.HelpModuleName = dr["HelpModuleName"].ToString(); }
if (dr["AudioURL"] != DBNull.Value) { video.AudioURL = dr["AudioURL"].ToString(); }
if (dr["VideoTitle"] != DBNull.Value) { video.VideoTitle = dr["VideoTitle"].ToString(); }
if (dr["VideoURL"] != DBNull.Value) { video.VideoURL = dr["VideoURL"].ToString(); }
lstvideos.Add(video);
count++;
}
}
responseObject.ResultObjectJSON = Serializer.ObjectToJSON(lstvideos);
responseObject.ResultCode = "SUCCESS";
responseObject.ResultObjectRecordCount = count;
if (responseObject.ResultObjectRecordCount <= 0) { responseObject.ResultMessage = "No records found."; }
}
catch (Exception ex)
{
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "GetQuestions", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
return Serializer.ObjectToJSON(responseObject);
}
/// <summary>
/// This method creates the session for logged in user
/// and returns all information needed to show on app
/// and website landing page.
/// </summary>
/// <param name="userName">string</param>
/// <param name="password">string</param>
/// <param name="deviceToken">string</param>
/// <returns>SessionResponseObject</returns>
public string CreateSession(string emailID, string password, string deviceToken)
{
ResponseObjectForAnything responseObject = new ResponseObjectForAnything();
SessionResponseObject sessionObject = new SessionResponseObject();
int count = 0;
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_CreateSession");
db.AddInParameter(dbCommand, "@Username", DbType.String, emailID);
string password1 = BitConverter.ToString(SHA1.Create().ComputeHash(Encoding.Default.GetBytes(password + ""))).Replace("-", "");
db.AddInParameter(dbCommand, "@Password", DbType.String, BitConverter.ToString(SHA1.Create().ComputeHash(Encoding.Default.GetBytes(password + ""))).Replace("-", ""));
db.AddInParameter(dbCommand, "@DeviceToken", DbType.String, deviceToken);
DataSet dsAuth = db.ExecuteDataSet(dbCommand);
if (dsAuth.Tables.Count > 0)
{
DataTable tUser = dsAuth.Tables[0];
Session session = new Session();
if (tUser.Rows.Count > 0)
{
if (tUser.Rows[0]["SessionKey"] != DBNull.Value) { session.SessionKey = tUser.Rows[0]["SessionKey"].ToString(); }
if (tUser.Rows[0]["SessionID"] != DBNull.Value) { session.ID = Int32.Parse(tUser.Rows[0]["SessionID"].ToString()); }
count++;
}
sessionObject.session = session;
}
if (dsAuth.Tables.Count > 1)
{
DataTable tUser = dsAuth.Tables[1];
Person person = new Person();
if (tUser.Rows.Count > 0)
{
if (tUser.Rows[0]["PersonID"] != DBNull.Value) { person.PersonID = Int32.Parse(tUser.Rows[0]["PersonID"].ToString()); }
if (tUser.Rows[0]["PersonTypeID"] != DBNull.Value) { person.PersonTypeID = Int32.Parse(tUser.Rows[0]["PersonTypeID"].ToString()); }
if (tUser.Rows[0]["PreferredLanguageID"] != DBNull.Value) { person.PreferredLanguageID = Int32.Parse(tUser.Rows[0]["PreferredLanguageID"].ToString()); }
if (tUser.Rows[0]["FirstName"] != DBNull.Value) { person.FirstName = tUser.Rows[0]["FirstName"].ToString(); }
if (tUser.Rows[0]["LastName"] != DBNull.Value) { person.LastName = tUser.Rows[0]["LastName"].ToString(); }
if (tUser.Rows[0]["Username"] != DBNull.Value) { person.Username = tUser.Rows[0]["Username"].ToString(); }
if (tUser.Rows[0]["ProfilePicPath"] != DBNull.Value) { person.ProfilePicPath = tUser.Rows[0]["ProfilePicPath"].ToString(); }
if (tUser.Rows[0]["Email"] != DBNull.Value) { person.Email = tUser.Rows[0]["Email"].ToString(); }
}
sessionObject.person = person;
}
string sessionresponse = Serializer.ObjectToJSON(sessionObject);
responseObject.ResultObjectJSON = sessionresponse;
responseObject.ResultCode = "SUCCESS";
responseObject.ResultObjectRecordCount = count;
if (responseObject.ResultObjectRecordCount == 0) { responseObject.ResultMessage = "Invalid Email Id or Password"; }
}
catch (Exception exception)
{
sessionObject.ResultCode = "ERROR";
sessionObject.ResultMessage = "Invalid Email Id or Password";
CustomException exc = new CustomException(exception.ToString(), this.ToString(), "CreateSession", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
return Serializer.ObjectToJSON(responseObject);
}
/// <summary>
/// Get country list.
/// </summary>
/// <returns></returns>
public string GetCountries()
{
string retValue = string.Empty;
List<Country> lstcountry = new List<Country>();
ResponseObjectForAnything responseObject = new ResponseObjectForAnything();
int count = 0;
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_GetCountries");
DataSet dsCountries = db.ExecuteDataSet(dbCommand);
if (dsCountries.Tables.Count > 0)
{
DataTable tCountry = dsCountries.Tables[0];
foreach (DataRow dr in tCountry.Rows)
{
Country country = new Country();
if (dr["CountryID"] != DBNull.Value) { country.CountryID = Int32.Parse(dr["CountryID"].ToString()); }
if (dr["CountryName"] != DBNull.Value) { country.CountryName = dr["CountryName"].ToString(); }
lstcountry.Add(country);
count++;
}
responseObject.ResultCode = "SUCCESS";
responseObject.ResultObjectJSON = Serializer.ObjectToJSON(lstcountry);
responseObject.ResultObjectRecordCount = count;
if (responseObject.ResultObjectRecordCount == 0) { responseObject.ResultMessage = "No records found"; }
}
}
catch (Exception ex)
{
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "IsValidSession", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
return Serializer.ObjectToJSON(responseObject);
}
/// <summary>
/// Get session key by email ID
/// </summary>
/// <param name="emailID">string</param>
/// <returns>string</returns>
public ResponseObjectForAnything GetUserFromSession(string sessionKey)
{
string retValue = string.Empty;
ResponseObjectForAnything obj = new ResponseObjectForAnything();
bool isValid = true;
List<Person> lstPerson = new List<Person>();
int count = 0;
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_GetUserFromSession");
db.AddInParameter(dbCommand, "@SessionKey", DbType.String, sessionKey);
DataSet dsPerson = db.ExecuteDataSet(dbCommand);
if (dsPerson.Tables.Count > 0)
{
DataTable tPerson = dsPerson.Tables[0];
foreach (DataRow dr in tPerson.Rows)
{
Person person = new Person();
if (dr["PersonID"] != DBNull.Value) { person.PersonID = Int32.Parse(dr["PersonID"].ToString()); }
if (dr["PersonTypeID"] != DBNull.Value) { person.PersonTypeID = Int32.Parse(dr["PersonTypeID"].ToString()); }
if (dr["PreferredLanguageID"] != DBNull.Value) { person.PreferredLanguageID = Int32.Parse(dr["PreferredLanguageID"].ToString()); }
if (dr["FirstName"] != DBNull.Value) { person.FirstName = dr["FirstName"].ToString(); }
if (dr["LastName"] != DBNull.Value) { person.LastName = dr["LastName"].ToString(); }
if (dr["Username"] != DBNull.Value) { person.Username = dr["Username"].ToString(); }
if (dr["Email"] != DBNull.Value) { person.Email = dr["Email"].ToString(); }
if (dr["CountryID"] != DBNull.Value) { person.CountryID = Int32.Parse(dr["CountryID"].ToString()); }
if (dr["StateID"] != DBNull.Value) { person.StateID = Int32.Parse(dr["StateID"].ToString()); }
if (dr["ProfilePicPath"] != DBNull.Value) { person.ProfilePicPath = dr["ProfilePicPath"].ToString(); }
if (dr["PersonGroupID"] != DBNull.Value) { person.PersonGroupID = Int32.Parse(dr["PersonGroupID"].ToString()); }
if (dr["GroupName"] != DBNull.Value) { person.GroupName = dr["GroupName"].ToString(); }
if (dr["PersonType"] != DBNull.Value) { person.PersonType = dr["PersonType"].ToString(); }
if (dr["PointsEarned"] != DBNull.Value) { person.PointsEarned = Int32.Parse(dr["PointsEarned"].ToString()); }
if (dr["AvgFeedback"] != DBNull.Value) { person.AvgFeedback = Convert.ToDecimal(dr["AvgFeedback"].ToString()); }
lstPerson.Add(person);
count++;
}
}
obj.ResultCode = "SUCCESS";
obj.ResultObjectJSON = Serializer.ObjectToJSON(lstPerson);
obj.ResultObjectRecordCount = count;
if (obj.ResultObjectRecordCount == 0) { obj.ResultMessage = "Invalid session."; }
}
catch (Exception ex)
{
obj.ResultCode = "ERROR";
obj.ResultMessage = ex.Message.ToString();
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "GetUserFromSession", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
return obj;
}
/// <summary>
/// This method is used to save groups.
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="groupid">string</param>
/// <param name="langid">string</param>
/// <param name="title">string</param>
/// <param name="audiofilePath">string</param>
/// <param name="isEdit">string</param>
/// <returns>string</returns>
public string SaveTrainingVideo(string sessionKey, string videoid, string subjectid, string langid, string title, string videofilePath, string pointsearned, string audiourl)
{
string retValue = string.Empty;
ResponseObjectForAnything obj = new ResponseObjectForAnything();
Int32 pId = -1;
bool isValid = true;
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_SaveVideo");
if (videoid != "0") { db.AddInParameter(dbCommand, "@VideoID", DbType.Int32, Int32.Parse(videoid)); }
else { db.AddInParameter(dbCommand, "@VideoID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(subjectid)) { db.AddInParameter(dbCommand, "@SubjectID", DbType.Int32, Int32.Parse(subjectid)); }
else { db.AddInParameter(dbCommand, "@SubjectID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(langid)) { db.AddInParameter(dbCommand, "@LangID", DbType.Int32, Int32.Parse(langid)); }
else { db.AddInParameter(dbCommand, "@LangID", DbType.Int32, null); }
db.AddInParameter(dbCommand, "@Title", DbType.String, title);
db.AddInParameter(dbCommand, "@VideoURL", DbType.String, videofilePath);
db.AddInParameter(dbCommand, "@PointsEarned", DbType.Int32, Int32.Parse(pointsearned));
db.AddInParameter(dbCommand, "@AudioURL", DbType.String, audiourl);
if (videoid == "0")
{
pId = Int32.Parse(db.ExecuteScalar(dbCommand).ToString());
obj.ResultObjectID = pId;
if (pId > 0)
obj.ResultCode = "SUCCESS";
else
obj.ResultCode = "ERROR";
obj.ResultObjectID = pId;
obj.ResultObjectRecordCount = pId;
if (obj.ResultObjectRecordCount <= 0) { obj.ResultMessage = "Unable to save training video."; }
}
else
{
db.ExecuteNonQuery(dbCommand);
obj.ResultCode = "SUCCESS";
}
}
catch (Exception ex)
{
obj.ResultCode = "ERROR";
obj.ResultMessage = ex.Message;
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "SaveGroups", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
retValue = Serializer.ObjectToJSON(obj);
return retValue;
}
/// <summary>
/// Get task types.
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="taskid">string</param>
/// <returns>string</returns>
public string GetTaskType(string sessionKey, string taskypeid)
{
string retValue = string.Empty;
ResponseObjectForAnything obj = new ResponseObjectForAnything();
bool isValid = true;
List<TaskType> lsttasktypes = new List<TaskType>();
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
int count = 0;
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_GetTaskType");
if (!string.IsNullOrEmpty(taskypeid)) { db.AddInParameter(dbCommand, "@TaskTypeID", DbType.Int32, Int32.Parse(taskypeid)); }
else { db.AddInParameter(dbCommand, "@TaskTypeID", DbType.Int32, null); }
DataSet dsTaskType = db.ExecuteDataSet(dbCommand);
if(dsTaskType.Tables.Count > 0)
{
DataTable tTaskType = dsTaskType.Tables[0];
foreach(DataRow dr in tTaskType.Rows)
{
TaskType tasktype = new TaskType();
if (dr["TaskTypeID"] != DBNull.Value) { tasktype.TaskTypeID = Int32.Parse(dr["TaskTypeID"].ToString()); }
if (dr["langid"] != DBNull.Value) { tasktype.langid = Int32.Parse(dr["langid"].ToString()); }
if (dr["PointsEarned"] != DBNull.Value) { tasktype.PointsEarned = Int32.Parse(dr["PointsEarned"].ToString()); }
if (dr["Title"] != DBNull.Value) { tasktype.Title = dr["Title"].ToString(); }
if (dr["IconURL"] != DBNull.Value) { tasktype.IconURL = dr["IconURL"].ToString(); }
if (dr["AudioURL"] != DBNull.Value) { tasktype.AudioURL = dr["AudioURL"].ToString(); }
if (dr["MinQuota"] != DBNull.Value) { tasktype.MinQuota = Int32.Parse(dr["MinQuota"].ToString()); }
lsttasktypes.Add(tasktype);
count++;
}
}
obj.ResultObjectJSON = Serializer.ObjectToJSON(lsttasktypes);
obj.ResultCode = "SUCCESS";
obj.ResultObjectRecordCount = count;
if (obj.ResultObjectRecordCount <= 0) { obj.ResultMessage = "No records found."; }
}
catch (Exception ex)
{
obj.ResultCode = "ERROR";
obj.ResultMessage = ex.Message.ToString();
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "GetTaskType", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
retValue = Serializer.ObjectToJSON(obj);
return retValue;
}
/// <summary>
/// Delete tasks.
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="taskid">string</param>
/// <returns>string</returns>
public string GetTrainingVideos(string sessionKey, string videoid, string subjectid)
{
string retValue = string.Empty;
ResponseObjectForAnything obj = new ResponseObjectForAnything();
int count = 0;
bool isValid = true;
List<SteviArt.Common.DTO.TrainingVideo> lsttasks = new List<SteviArt.Common.DTO.TrainingVideo>();
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_GetTrainingVideo");
if (!string.IsNullOrEmpty(videoid)) { db.AddInParameter(dbCommand, "@VideoID", DbType.Int32, Int32.Parse(videoid)); }
else { db.AddInParameter(dbCommand, "@VideoID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(subjectid)) { db.AddInParameter(dbCommand, "@SubjectID", DbType.Int32, subjectid); }
else { db.AddInParameter(dbCommand, "@SubjectID", DbType.Int32, null); }
DataSet dsTask = db.ExecuteDataSet(dbCommand);
if (dsTask.Tables.Count > 0)
{
DataTable tTask = dsTask.Tables[0];
foreach (DataRow dr in tTask.Rows)
{
SteviArt.Common.DTO.TrainingVideo task = new SteviArt.Common.DTO.TrainingVideo();
if (dr["TrainingVideoID"] != DBNull.Value) { task.TrainingVideoID = Int32.Parse(dr["TrainingVideoID"].ToString()); }
if (dr["SubjectID"] != DBNull.Value) { task.SubjectID = Int32.Parse(dr["SubjectID"].ToString()); }
if (dr["langid"] != DBNull.Value) { task.langid = Int32.Parse(dr["langid"].ToString()); }
if (dr["VideoTitle"] != DBNull.Value) { task.VideoTitle = dr["VideoTitle"].ToString(); }
if (dr["VideoURL"] != DBNull.Value) { task.VideoURL = dr["VideoURL"].ToString(); }
if (dr["PointsEarned"] != DBNull.Value) { task.PointsEarned = Int32.Parse(dr["PointsEarned"].ToString()); }
if (dr["AudioURL"] != DBNull.Value) { task.AudioURL = dr["AudioURL"].ToString(); }
lsttasks.Add(task);
count++;
}
}
obj.ResultCode = "SUCCESS";
obj.ResultObjectJSON = Serializer.ObjectToJSON(lsttasks);
obj.ResultObjectRecordCount = count;
if (obj.ResultObjectRecordCount == 0) { obj.ResultMessage = "No records found."; }
}
catch (Exception ex)
{
obj.ResultCode = "ERROR";
obj.ResultMessage = ex.Message.ToString();
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "GetTask", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
retValue = Serializer.ObjectToJSON(obj);
return retValue;
}
/// <summary>
/// Delete tasks.
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="taskid">string</param>
/// <returns>string</returns>
public string GetTask(string sessionKey, string personid, string taskid, string duedate, string tasktypeid)
{
string retValue = string.Empty;
ResponseObjectForAnything obj = new ResponseObjectForAnything();
int count = 0;
bool isValid = true;
List<SteviArt.Common.DTO.Task> lsttasks = new List<SteviArt.Common.DTO.Task>();
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
//ResponseObjectForAnything responseObject = GetUserFromSession(sessionKey);
//List<Person> person = (List<Person>)Serializer.JSONStringToObject<List<Person>>(responseObject.ResultObjectJSON);
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_GetTask");
if (!string.IsNullOrEmpty(personid)) { db.AddInParameter(dbCommand, "@TaskID", DbType.Int32, Int32.Parse(taskid)); }
else { db.AddInParameter(dbCommand, "@TaskID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(personid)) { db.AddInParameter(dbCommand, "@PersonID", DbType.Int32, personid); }
else { db.AddInParameter(dbCommand, "@PersonID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(duedate)) { db.AddInParameter(dbCommand, "@DueDate", DbType.DateTime, Convert.ToDateTime(duedate)); }
else { db.AddInParameter(dbCommand, "@DueDate", DbType.Int32, null); }
if (!string.IsNullOrEmpty(tasktypeid)) { db.AddInParameter(dbCommand, "@TaskTypeID", DbType.Int32, Int32.Parse(tasktypeid)); }
else { db.AddInParameter(dbCommand, "@TaskTypeID", DbType.Int32, null); }
DataSet dsTask = db.ExecuteDataSet(dbCommand);
if (dsTask.Tables.Count > 0)
{
DataTable tTask = new DataTable();
foreach (DataRow dr in tTask.Rows)
{
SteviArt.Common.DTO.Task task = new SteviArt.Common.DTO.Task();
if (dr["TaskID"] != DBNull.Value) { task.TaskID = Int32.Parse(dr["TaskID"].ToString()); }
if (dr["TaskTypeID"] != DBNull.Value) { task.TaskTypeID = Int32.Parse(dr["TaskTypeID"].ToString()); }
if (dr["langid"] != DBNull.Value) { task.langid = Int32.Parse(dr["langid"].ToString()); }
if (dr["IsCompleted"] != DBNull.Value) { task.IsCompleted = Convert.ToBoolean(dr["IsCompleted"].ToString()); }
if (dr["LastCompletionDate"] != DBNull.Value) { task.LastCompletionDate = Convert.ToDateTime(dr["LastCompletionDate"].ToString()); }
if (dr["DueDate"] != DBNull.Value) { task.DueDate = Convert.ToDateTime(dr["DueDate"].ToString()); }
if (dr["CreatedDate"] != DBNull.Value) { task.CreatedDate = Convert.ToDateTime(dr["CreatedDate"].ToString()); }
if (dr["Title"] != DBNull.Value) { task.Title = dr["Title"].ToString(); }
if (dr["AssignedToPersonID"] != DBNull.Value) { task.AssignedToPersonID = Int32.Parse(dr["AssignedToPersonID"].ToString()); }
if (dr["PercentComplete"] != DBNull.Value) { task.PercentComplete = Convert.ToDecimal(dr["PercentComplete"].ToString()); }
if (dr["AudioURL"] != DBNull.Value) { task.AudioURL = dr["AudioURL"].ToString(); }
lsttasks.Add(task);
count++;
}
}
obj.ResultCode = "SUCCESS";
obj.ResultObjectJSON = Serializer.ObjectToJSON(lsttasks);
obj.ResultObjectRecordCount = count;
if (obj.ResultObjectRecordCount == 0) { obj.ResultMessage = "No records found."; }
}
catch (Exception ex)
{
obj.ResultCode = "ERROR";
obj.ResultMessage = ex.Message.ToString();
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "GetTask", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
retValue = Serializer.ObjectToJSON(obj);
return retValue;
}
/// <summary>
/// Get department list.
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="subjectid">string</param>
/// <returns>string</returns>
public string GetSubjects(string sessionKey, string subjectid)
{
string retValue = string.Empty;
List<HelpSubject> lstdepartment = new List<HelpSubject>();
ResponseObjectForAnything obj = new ResponseObjectForAnything();
int count = 0;
bool isValid = true;
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_GetHelpSubject");
if (!string.IsNullOrEmpty(subjectid)) { db.AddInParameter(dbCommand, "@SubjectID", DbType.Int32, Convert.ToInt32(subjectid)); }
else { db.AddInParameter(dbCommand, "@SubjectID", DbType.Int32, null); }
DataSet dsStates = db.ExecuteDataSet(dbCommand);
if (dsStates.Tables.Count > 0)
{
DataTable tState = dsStates.Tables[0];
foreach (DataRow dr in tState.Rows)
{
HelpSubject subject = new HelpSubject();
if (dr["HelpSubjectID"] != DBNull.Value) { subject.HelpSubjectID = Int32.Parse(dr["HelpSubjectID"].ToString()); }
if (dr["langid"] != DBNull.Value) { subject.langid = Int32.Parse(dr["langid"].ToString()); }
if (dr["Title"] != DBNull.Value) { subject.Title = dr["Title"].ToString(); }
if (dr["AudioURL"] != DBNull.Value) { subject.AudioURL = dr["AudioURL"].ToString(); }
if (dr["alias"] != DBNull.Value) { subject.alias = dr["alias"].ToString(); }
if (dr["IconURL"] != DBNull.Value) { subject.IconURL = dr["IconURL"].ToString(); }
lstdepartment.Add(subject);
count++;
}
obj.ResultObjectJSON = Serializer.ObjectToJSON(lstdepartment);
obj.ResultCode = "SUCCESS";
obj.ResultObjectRecordCount = count;
if (obj.ResultObjectRecordCount <= 0) { obj.ResultMessage = "No records found."; }
}
}
catch (Exception ex)
{
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "GetDepartments", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
return Serializer.ObjectToJSON(obj);
}
/// <summary>
/// Get state list.
/// </summary>
/// <returns></returns>
public string GetStates(string countryid)
{
string retValue = string.Empty;
List<State> lststate = new List<State>();
ResponseObjectForAnything responseObject = new ResponseObjectForAnything();
int count = 0;
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_GetStates");
db.AddInParameter(dbCommand, "@CountryID", DbType.Int32, Int32.Parse(countryid));
DataSet dsStates = db.ExecuteDataSet(dbCommand);
if (dsStates.Tables.Count > 0)
{
DataTable tState = dsStates.Tables[0];
foreach (DataRow dr in tState.Rows)
{
State state = new State();
if (dr["StateID"] != DBNull.Value) { state.StateID = Int32.Parse(dr["StateID"].ToString()); }
if (dr["StateName"] != DBNull.Value) { state.StateName = dr["StateName"].ToString(); }
lststate.Add(state);
count++;
}
}
responseObject.ResultObjectJSON = Serializer.ObjectToJSON(lststate);
responseObject.ResultCode = "SUCCESS";
responseObject.ResultObjectRecordCount = count;
if (responseObject.ResultObjectRecordCount <= 0) { responseObject.ResultMessage = "No records found."; }
}
catch (Exception ex)
{
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "GetStates", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
return Serializer.ObjectToJSON(responseObject);
}
/// <summary>
/// save tasks
/// </summary>
/// <param name="sessionKey"></param>
/// <param name="helpcotentid"></param>
/// <param name="subjectid"></param>
/// <param name="langid"></param>
/// <param name="title"></param>
/// <param name="htmlcontent"></param>
/// <param name="audioURL"></param>
/// <returns></returns>
public string SaveTask(string sessionKey, string taskid, string tasktypeid, string iscompleted, string lastcompletiondate, string duedate, string assignedtopersonid,
string isnotifiedafterassigned, string assignedbypersonid, string percentcomplete, string langid, string title, string audiourl, string numbercompleted)
{
string retValue = string.Empty;
ResponseObjectForAnything obj = new ResponseObjectForAnything();
Int32 pId = -1;
bool isValid = true;
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_SaveTask");
if (!string.IsNullOrEmpty(taskid)) { db.AddInParameter(dbCommand, "@TaskID", DbType.Int32, Int32.Parse(taskid)); }
else { db.AddInParameter(dbCommand, "@TaskID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(tasktypeid)) { db.AddInParameter(dbCommand, "@TaskTypeID", DbType.Int32, Int32.Parse(tasktypeid)); }
else { db.AddInParameter(dbCommand, "@TaskTypeID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(iscompleted)) { db.AddInParameter(dbCommand, "@IsCompleted", DbType.Boolean, Convert.ToBoolean(iscompleted)); }
else { db.AddInParameter(dbCommand, "@IsCompleted", DbType.Boolean, null); }
if (!string.IsNullOrEmpty(lastcompletiondate)) { db.AddInParameter(dbCommand, "@LastCompletionDate", DbType.DateTime, DateTime.ParseExact(lastcompletiondate,"yyyy-MM-dd", DateTimeFormatInfo.CurrentInfo)); }
else { db.AddInParameter(dbCommand, "@LastCompletionDate", DbType.DateTime, null); }
if (!string.IsNullOrEmpty(duedate)) { db.AddInParameter(dbCommand, "@DueDate", DbType.DateTime, Convert.ToDateTime(duedate)); }
else { db.AddInParameter(dbCommand, "@DueDate", DbType.DateTime, null); }
if (!string.IsNullOrEmpty(assignedtopersonid)) { db.AddInParameter(dbCommand, "@AssignedToPersonID", DbType.Int32, Int32.Parse(assignedtopersonid)); }
else { db.AddInParameter(dbCommand, "@AssignedToPersonID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(isnotifiedafterassigned)) { db.AddInParameter(dbCommand, "@IsNotifiedAfterAssigned", DbType.Boolean, Convert.ToBoolean(isnotifiedafterassigned)); }
else { db.AddInParameter(dbCommand, "@IsNotifiedAfterAssigned", DbType.Boolean, false); }
if (!string.IsNullOrEmpty(assignedbypersonid)) { db.AddInParameter(dbCommand, "@AssignedByPersonID", DbType.Int32, Int32.Parse(assignedbypersonid)); }
else { db.AddInParameter(dbCommand, "@AssignedByPersonID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(numbercompleted)) { db.AddInParameter(dbCommand, "@NumberCompleted", DbType.Int32, Int32.Parse(numbercompleted)); }
else { db.AddInParameter(dbCommand, "@NumberCompleted", DbType.Boolean, 0); }
if (!string.IsNullOrEmpty(langid)) { db.AddInParameter(dbCommand, "@langid", DbType.Int32, Int32.Parse(langid)); }
else { db.AddInParameter(dbCommand, "@langid", DbType.Boolean, null); }
db.AddInParameter(dbCommand, "@Title", DbType.String, title);
db.AddInParameter(dbCommand, "@AudioURL", DbType.String, audiourl);
if (taskid == null)
{
pId = Int32.Parse(db.ExecuteScalar(dbCommand).ToString());
obj.ResultObjectID = pId;
if (pId > 0)
{
obj.ResultCode = "SUCCESS";
obj.ResultMessage = "Task has been saved successfully.";
}
else
obj.ResultCode = "ERROR";
}
else
{
db.ExecuteNonQuery(dbCommand);
obj.ResultCode = "SUCCESS";
obj.ResultMessage = "Task has been saved successfully.";
}
}
catch (Exception ex)
{
obj.ResultCode = "ERROR";
obj.ResultMessage = ex.Message.ToString();
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "SaveGroups", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
retValue = Serializer.ObjectToJSON(obj);
return retValue;
}
/// <summary>
/// Assign videos to contents
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="helpcontentid">string</param>
/// <param name="videoid">string</param>
/// <param name="videourl">string</param>
/// <returns>string</returns>
public string SaveContentVideo(string sessionKey, string helpcontentid, string videoid, string videourl)
{
string retValue = string.Empty;
ResponseObjectForAnything obj = new ResponseObjectForAnything();
Int32 pId = -1;
bool isValid = true;
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_SaveContentVideo");
if (!string.IsNullOrEmpty(helpcontentid)) { db.AddInParameter(dbCommand, "@HelpContentID", DbType.Int32, Int32.Parse(helpcontentid)); }
else { db.AddInParameter(dbCommand, "@HelpContentID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(videoid)) { db.AddInParameter(dbCommand, "@VideoID", DbType.Int32, Int32.Parse(videoid)); }
else { db.AddInParameter(dbCommand, "@SubjectID", DbType.Int32, null); }
db.AddInParameter(dbCommand, "@VideoURL", DbType.String, videourl);
if (helpcontentid == null)
{
pId = Int32.Parse(db.ExecuteScalar(dbCommand).ToString());
obj.ResultObjectID = pId;
if (pId > 0)
{
obj.ResultCode = "SUCCESS";
obj.ResultMessage = "Video been saved successfully.";
}
else
obj.ResultCode = "ERROR";
}
else
{
db.ExecuteNonQuery(dbCommand);
obj.ResultCode = "SUCCESS";
obj.ResultMessage = "Video has been saved successfully.";
}
}
catch (Exception ex)
{
obj.ResultCode = "ERROR";
obj.ResultMessage = ex.Message.ToString();
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "SaveGroups", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
retValue = Serializer.ObjectToJSON(obj);
return retValue;
}
/// <summary>
/// Save task types.
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="tasktypeid">string</param>
/// <param name="pointsearned">string</param>
/// <param name="goalpathiconurl">string</param>
/// <param name="langid">string</param>
/// <param name="title">string</param>
/// <param name="description">string</param>
/// <param name="audiourl">string</param>
/// <returns>string</returns>
public string SaveTaskType(string sessionKey, string tasktypeid, string pointsearned, string goalpathiconurl, string langid, string title,
string audiourl, string minquota)
{
string retValue = string.Empty;
ResponseObjectForAnything obj = new ResponseObjectForAnything();
Int32 pId = -1;
bool isValid = true;
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_SaveTaskType");
if (tasktypeid != "0") { db.AddInParameter(dbCommand, "@TaskTypeID", DbType.Int32, Int32.Parse(tasktypeid)); }
else { db.AddInParameter(dbCommand, "@TaskTypeID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(pointsearned)) { db.AddInParameter(dbCommand, "@PointsEarned", DbType.Int32, Int32.Parse(pointsearned)); }
else { db.AddInParameter(dbCommand, "@PointsEarned", DbType.Int32, null); }
db.AddInParameter(dbCommand, "@IconURL", DbType.String, goalpathiconurl);
if (!string.IsNullOrEmpty(langid)) { db.AddInParameter(dbCommand, "@langid", DbType.Int32, Int32.Parse(langid)); }
else { db.AddInParameter(dbCommand, "@langid", DbType.Int32, null); }
db.AddInParameter(dbCommand, "@Title", DbType.String, title);
db.AddInParameter(dbCommand, "@AudioURL", DbType.String, audiourl);
if (!string.IsNullOrEmpty(pointsearned)) { db.AddInParameter(dbCommand, "@MinQuota", DbType.Int32, Int32.Parse(minquota)); }
else { db.AddInParameter(dbCommand, "@MinQuota", DbType.Int32, null); }
if (tasktypeid == "0")
{
pId = Int32.Parse(db.ExecuteScalar(dbCommand).ToString());
obj.ResultObjectID = pId;
if (pId > 0)
{
obj.ResultCode = "SUCCESS";
obj.ResultMessage = "Task types have been saved successfully.";
}
else
obj.ResultCode = "ERROR";
}
else
{
db.ExecuteNonQuery(dbCommand);
obj.ResultCode = "SUCCESS";
obj.ResultMessage = "Task types have been saved successfully.";
}
}
catch (Exception ex)
{
obj.ResultCode = "ERROR";
obj.ResultMessage = ex.Message.ToString();
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "SaveTaskType", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
retValue = Serializer.ObjectToJSON(obj);
return retValue;
}
/// <summary>
/// Save department method.
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="departmentid">string</param>
/// <param name="langid">string</param>
/// <param name="title">string</param>
/// <param name="audiofilePath">string</param>
/// <returns>string</returns>
public string SaveDepartment(string sessionKey, string departmentid, string langid, string title, string audiofilePath, string iconpathurl, string isenabled, string filename)
{
string retValue = string.Empty;
ResponseObjectForAnything obj = new ResponseObjectForAnything();
Int32 pId = -1;
bool isValid = true;
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_SaveDepartment");
if (!string.IsNullOrEmpty(departmentid)) { db.AddInParameter(dbCommand, "@DepartmentID", DbType.Int32, Int32.Parse(departmentid)); }
else { db.AddInParameter(dbCommand, "@DepartmentID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(langid)) { db.AddInParameter(dbCommand, "@langid", DbType.Int32, Int32.Parse(langid)); }
else { db.AddInParameter(dbCommand, "@langid", DbType.Int32, null); }
db.AddInParameter(dbCommand, "@Title", DbType.String, title);
db.AddInParameter(dbCommand, "@AudioURL", DbType.String, audiofilePath);
db.AddInParameter(dbCommand, "@IconURL", DbType.String, iconpathurl);
db.AddInParameter(dbCommand, "@IsEnabled", DbType.Boolean, Convert.ToBoolean(isenabled));
db.AddInParameter(dbCommand, "@FileName", DbType.Boolean, filename);
if (departmentid == null)
{
pId = Int32.Parse(db.ExecuteScalar(dbCommand).ToString());
obj.ResultObjectID = pId;
if (pId > 0)
{
obj.ResultCode = "SUCCESS";
obj.ResultMessage = "Department have been saved successfully.";
}
else
obj.ResultCode = "ERROR";
}
else
{
db.ExecuteNonQuery(dbCommand);
obj.ResultCode = "SUCCESS";
obj.ResultMessage = "Department have been saved successfully.";
}
}
catch (Exception ex)
{
obj.ResultCode = "ERROR";
obj.ResultMessage = ex.Message.ToString();
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "SaveGroups", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
retValue = Serializer.ObjectToJSON(obj);
return retValue;
}
/// <summary>
/// Save video question and answers.
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="videoid">string</param>
/// <param name="questiontext">string</param>
/// <param name="langid">string</param>
/// <param name="answers">string</param>
/// <param name="correctanswer">string</param>
/// <param name="points">string</param>
/// <returns>string</returns>
public string SaveVideoQuestions(string sessionKey, string questionid, string videoid, string questiontext, string langid, string correctanswer, string audioURL, string points)
{
string retValue = string.Empty;
ResponseObjectForAnything obj = new ResponseObjectForAnything();
Int32 pId = -1;
bool isValid = true;
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_SaveVideoQuestions");
if (!string.IsNullOrEmpty(videoid)) { db.AddInParameter(dbCommand, "@QuestionID", DbType.Int32, Int32.Parse(questionid)); }
else { db.AddInParameter(dbCommand, "@QuestionID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(videoid)) { db.AddInParameter(dbCommand, "@VideoID", DbType.Int32, Int32.Parse(videoid)); }
else { db.AddInParameter(dbCommand, "@VideoID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(langid)) { db.AddInParameter(dbCommand, "@LangID", DbType.Int32, Int32.Parse(langid)); }
else { db.AddInParameter(dbCommand, "@LangID", DbType.Int32, null); }
db.AddInParameter(dbCommand, "@QuestionText", DbType.String, questiontext);
db.AddInParameter(dbCommand, "@AudioURL", DbType.String, audioURL);
db.AddInParameter(dbCommand, "@CorrectAnswer", DbType.String, correctanswer);
db.AddInParameter(dbCommand, "@Points", DbType.Int32, Int32.Parse(points));
if (videoid == null)
{
pId = Int32.Parse(db.ExecuteScalar(dbCommand).ToString());
obj.ResultObjectID = pId;
if (pId > 0)
{
obj.ResultCode = "SUCCESS";
obj.ResultMessage = "Questions have been saved successfully.";
}
else
obj.ResultCode = "ERROR";
}
else
{
db.ExecuteNonQuery(dbCommand);
obj.ResultCode = "SUCCESS";
obj.ResultMessage = "Questions have been saved successfully.";
}
}
catch (Exception ex)
{
obj.ResultCode = "ERROR";
obj.ResultMessage = ex.Message.ToString();
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "SaveGroups", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
retValue = Serializer.ObjectToJSON(obj);
return retValue;
}
/// <summary>
/// Save department method.
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="departmentid">string</param>
/// <param name="langid">string</param>
/// <param name="title">string</param>
/// <param name="audiofilePath">string</param>
/// <returns>string</returns>
public string SaveLanguage(string sessionKey, string langid, bool isenabled)
{
string retValue = string.Empty;
ResponseObjectForAnything obj = new ResponseObjectForAnything();
bool isValid = true;
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_SaveLanguage");
if (langid != "0") { db.AddInParameter(dbCommand, "@langid", DbType.Int32, Int32.Parse(langid)); }
else { db.AddInParameter(dbCommand, "@langid", DbType.Int32, null); }
db.AddInParameter(dbCommand, "@isenabled", DbType.Boolean, isenabled);
db.ExecuteNonQuery(dbCommand);
obj.ResultCode = "SUCCESS";
obj.ResultMessage = "Language have been saved successfully.";
}
catch (Exception ex)
{
obj.ResultCode = "ERROR";
obj.ResultMessage = ex.Message.ToString();
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "SaveLanguages", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
retValue = Serializer.ObjectToJSON(obj);
return retValue;
}
/// <summary>
/// Delete questions
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="questionid">string</param>
/// <returns>string</returns>
public string DeleteVideoQuestions(string sessionKey, string questionid)
{
string retValue = string.Empty;
ResponseObjectForAnything obj = new ResponseObjectForAnything();
bool isValid = true;
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_DeleteQuestion");
db.AddInParameter(dbCommand, "@QuestionID", DbType.Int32, Int32.Parse(questionid));
db.ExecuteNonQuery(dbCommand);
obj.ResultCode = "SUCCESS";
obj.ResultMessage = "Questions have been deleted successfully.";
}
catch (Exception ex)
{
obj.ResultCode = "ERROR";
obj.ResultMessage = ex.Message.ToString();
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "DeleteContentVideo", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
retValue = Serializer.ObjectToJSON(obj);
return retValue;
}
/// <summary>
/// Get persons list.
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="personId">string</param>
/// <param name="personTypeId">string</param>
/// <param name="persongroupid">string</param>
/// <param name="langid">string</param>
/// <param name="firstname">string</param>
/// <param name="lastname">string</param>
/// <param name="username">string</param>
/// <param name="password">string</param>
/// <param name="email">string</param>
/// <param name="countryid">string</param>
/// <param name="stateid">string</param>
/// <param name="telhome">string</param>
/// <param name="telwork">string</param>
/// <param name="telmobile">string</param>
/// <param name="profilepicture">string</param>
/// <param name="personcode">string</param>
/// <param name="jobtitle">string</param>
/// <returns>string</returns>
public string SavePerson(string sessionKey, string personId, string personTypeId, string persongroupid, string langid, string firstname, string lastname,
string username, string password, string email, string profilepicture, string audioURL, string devicetoken)
{
string retValue = string.Empty;
ResponseObjectForAnything obj = new ResponseObjectForAnything();
Int32 pId = -1;
bool isValid = true;
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_SavePerson");
db.AddInParameter(dbCommand, "@SessionKey", DbType.String, sessionKey);
if (personId != "0") { db.AddInParameter(dbCommand, "@PersonID", DbType.Int32, Int32.Parse(personId)); }
else { db.AddInParameter(dbCommand, "@PersonID", DbType.Int32, null); }
if (personTypeId != "0") { db.AddInParameter(dbCommand, "@PersonTypeID", DbType.Int32, Int32.Parse(personTypeId)); }
else { db.AddInParameter(dbCommand, "@PersonTypeID", DbType.Int32, null); }
if (persongroupid != "0") { db.AddInParameter(dbCommand, "@PersonGroupID", DbType.Int32, Int32.Parse(persongroupid)); }
else { db.AddInParameter(dbCommand, "@PersonGroupID", DbType.Int32, null); }
db.AddInParameter(dbCommand, "@PreferredLanguageID", DbType.Int32, Int32.Parse(langid));
db.AddInParameter(dbCommand, "@FirstName", DbType.String, firstname);
db.AddInParameter(dbCommand, "@LastName", DbType.String, lastname);
db.AddInParameter(dbCommand, "@Username", DbType.String, username);
db.AddInParameter(dbCommand, "@Password", DbType.String, CalculateMD5Hash(password));
db.AddInParameter(dbCommand, "@Email", DbType.String, email);
db.AddInParameter(dbCommand, "@ProfilePictureURL", DbType.String, profilepicture);
db.AddInParameter(dbCommand, "@AudioURL", DbType.String, audioURL);
db.AddInParameter(dbCommand, "@RegisteredToken", DbType.String, devicetoken);
if (personId == "0")
{
pId = Int32.Parse(db.ExecuteScalar(dbCommand).ToString());
obj.ResultObjectID = pId;
if (pId > 0)
obj.ResultCode = "SUCCESS";
else
obj.ResultCode = "ERROR";
}
else
{
db.ExecuteNonQuery(dbCommand);
obj.ResultCode = "SUCCESS";
}
}
catch (Exception ex)
{
obj.ResultCode = "ERROR";
obj.ResultMessage = ex.Message.ToString();
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "SavePerson", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
retValue = Serializer.ObjectToJSON(obj);
return retValue;
}
/// <summary>
/// Get groups.
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="groupid">string</param>
/// <returns>string</returns>
public string GetGroups(string sessionKey, string groupid)
{
string retValue = string.Empty;
List<Group> lstgroup = new List<Group>();
ResponseObjectForAnything responseObject = new ResponseObjectForAnything();
bool isValid = true;
int count = 0;
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_GetGroups");
db.AddInParameter(dbCommand, "@GroupID", DbType.Int32, groupid);
DataSet dsStates = db.ExecuteDataSet(dbCommand);
if (dsStates.Tables.Count > 0)
{
DataTable tState = dsStates.Tables[0];
foreach (DataRow dr in tState.Rows)
{
Group group = new Group();
if (dr["GroupID"] != DBNull.Value) { group.GroupID = Int32.Parse(dr["GroupID"].ToString()); }
if (dr["langid"] != DBNull.Value) { group.langid = Int32.Parse(dr["langid"].ToString()); }
if (dr["Title"] != DBNull.Value) { group.Title = dr["Title"].ToString(); }
if (dr["AudioURL"] != DBNull.Value) { group.AudioURL = dr["AudioURL"].ToString(); }
if (dr["IconURL"] != DBNull.Value) { group.IconURL = dr["IconURL"].ToString(); }
lstgroup.Add(group);
count++;
}
responseObject.ResultObjectJSON = Serializer.ObjectToJSON(lstgroup);
responseObject.ResultCode = "SUCCESS";
responseObject.ResultObjectRecordCount = count;
if (responseObject.ResultObjectRecordCount <= 0) { responseObject.ResultMessage = "No records found."; }
}
}
catch (Exception ex)
{
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "GetDeaprtments", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
return Serializer.ObjectToJSON(responseObject);
}
/// <summary>
/// Save person completed quiz.
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="personcompletedquizid">string</param>
/// <param name="helpvideoquizid">string</param>
/// <param name="personid">string</param>
/// <param name="completeddate">string</param>
/// <returns>string</returns>
public string SavePersonCompletedQuiz(string sessionKey, string personcompletedquizid, string helpvideoquizid, string personid, string completeddate)
{
string retValue = string.Empty;
ResponseObjectForAnything obj = new ResponseObjectForAnything();
Int32 pId = -1;
bool isValid = true;
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_SavePersonCompletedQuiz");
if (!string.IsNullOrEmpty(personcompletedquizid)) { db.AddInParameter(dbCommand, "@PersonCompletedQuizID", DbType.Int32, Int32.Parse(personcompletedquizid)); }
else { db.AddInParameter(dbCommand, "@PersonCompletedQuizID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(helpvideoquizid)) { db.AddInParameter(dbCommand, "@HelpVideoQuizID", DbType.Int32, Int32.Parse(helpvideoquizid)); }
else { db.AddInParameter(dbCommand, "@HelpVideoQuizID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(personid)) { db.AddInParameter(dbCommand, "@PersonID", DbType.Int32, Int32.Parse(personid)); }
else { db.AddInParameter(dbCommand, "@PersonID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(completeddate)) { db.AddInParameter(dbCommand, "@CompletedDate", DbType.Int32, Convert.ToDateTime(completeddate)); }
else { db.AddInParameter(dbCommand, "@CompletedDate", DbType.Int32, null); }
if (personcompletedquizid == null)
{
pId = Int32.Parse(db.ExecuteScalar(dbCommand).ToString());
obj.ResultObjectID = pId;
if (pId > 0)
{
obj.ResultCode = "SUCCESS";
obj.ResultMessage = "Completed quiz details have been saved successfully.";
}
else
obj.ResultCode = "ERROR";
}
else
{
db.ExecuteNonQuery(dbCommand);
obj.ResultCode = "SUCCESS";
obj.ResultMessage = "Completed quiz details have been saved successfully.";
}
}
catch (Exception ex)
{
obj.ResultCode = "ERROR";
obj.ResultMessage = ex.Message.ToString();
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "SavePersonFeedback", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
retValue = Serializer.ObjectToJSON(obj);
return retValue;
}
//public string GetPersonFeedbackType(string sessionKey)
//{
// string retValue = string.Empty;
// int count = 0;
// List<PersonFeedback> lstfeedbacktype = new List<PersonFeedback>();
// ResponseObjectForAnything responseObject = new ResponseObjectForAnything();
// bool isValid = true;
// if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
// if (isValid)
// {
// try
// {
// Database db = DatabaseFactory.CreateDatabase();
// DbCommand dbCommand = db.GetStoredProcCommand("usp_GetPersonFeedbackType");
// DataSet dsHelpContent = db.ExecuteDataSet(dbCommand);
// if (dsHelpContent.Tables.Count > 0)
// {
// DataTable tHelpContent = dsHelpContent.Tables[0];
// foreach (DataRow dr in tHelpContent.Rows)
// {
// PersonFeedback feedback = new PersonFeedback();
// if (dr["PersonFeedbackID"] != DBNull.Value) { feedback.PersonFeedbackID = Int32.Parse(dr["PersonFeedbackID"].ToString()); }
// if (dr["Title"] != DBNull.Value) { feedback. = dr["Title"].ToString(); }
// if (dr["PointsEarned"] != DBNull.Value) { feedback.PointsEarned = Int32.Parse(dr["PointsEarned"].ToString()); }
// lstfeedbacktype.Add(feedback);
// count++;
// }
// }
// responseObject.ResultObjectJSON = Serializer.ObjectToJSON(lstfeedbacktype);
// responseObject.ResultCode = "SUCCESS";
// responseObject.ResultObjectRecordCount = count;
// if (responseObject.ResultObjectRecordCount <= 0) { responseObject.ResultMessage = "No records found."; }
// }
// catch (Exception ex)
// {
// CustomException exc = new CustomException(ex.ToString(), this.ToString(), "GetFeedbacktype", System.DateTime.Now);
// ExceptionManager.PublishException(exc);
// }
// }
// return Serializer.ObjectToJSON(responseObject);
//}
/// <summary>
/// Get video questions and answers based on
/// video ID.
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="videoid">string</param>
/// <param name="langid">string</param>
/// <returns></returns>
public string GetHelpVideoQuizes(string sessionKey, string videoid, string langid)
{
string retValue = string.Empty;
int count = 0;
QuestionObject questionobject = new QuestionObject();
List<HelpVideoQuiz> lstquestions = new List<HelpVideoQuiz>();
List<HelpVideoAnswers> lstanswers = new List<HelpVideoAnswers>();
ResponseObjectForAnything responseObject = new ResponseObjectForAnything();
bool isValid = true;
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_GetHelpVideoQuestions");
if (!string.IsNullOrEmpty(videoid)) { db.AddInParameter(dbCommand, "@VideoID", DbType.String, videoid); }
else { db.AddInParameter(dbCommand, "@VideoID", DbType.String, null); }
if (!string.IsNullOrEmpty(langid)) { db.AddInParameter(dbCommand, "@langid", DbType.String, langid); }
else { db.AddInParameter(dbCommand, "@langid", DbType.String, null); }
DataSet dsHelpContent = db.ExecuteDataSet(dbCommand);
if (dsHelpContent.Tables.Count > 0)
{
DataTable tHelpContent = dsHelpContent.Tables[0];
foreach (DataRow dr in tHelpContent.Rows)
{
HelpVideoQuiz helpquiz = new HelpVideoQuiz();
if (dr["HelpVideoQuizID"] != DBNull.Value) { helpquiz.HelpVideoQuizID = Int32.Parse(dr["HelpVideoQuizID"].ToString()); }
if (dr["HelpVideoID"] != DBNull.Value) { helpquiz.HelpVideoID = Int32.Parse(dr["HelpVideoID"].ToString()); }
if (dr["QuestionText"] != DBNull.Value) { helpquiz.QuestionText = dr["QuestionText"].ToString(); }
if (dr["AudioURL"] != DBNull.Value) { helpquiz.AudioURL = dr["AudioURL"].ToString(); }
if (dr["CorrectAnswerID"] != DBNull.Value) { helpquiz.CorrectAnswerID = Int32.Parse(dr["CorrectAnswerID"].ToString()); }
if (dr["Points"] != DBNull.Value) { helpquiz.Points = Int32.Parse(dr["Points"].ToString()); }
lstquestions.Add(helpquiz);
count++;
}
questionobject.Questions = lstquestions;
}
if (dsHelpContent.Tables.Count > 1)
{
DataTable tHelpContent = dsHelpContent.Tables[1];
foreach (DataRow dr in tHelpContent.Rows)
{
HelpVideoAnswers helpanswers = new HelpVideoAnswers();
if (dr["HelpVideoQuizAnswerID"] != DBNull.Value) { helpanswers.HelpVideoQuizAnswerID = Int32.Parse(dr["HelpVideoQuizAnswerID"].ToString()); }
if (dr["AnswerTitle"] != DBNull.Value) { helpanswers.AnswerTitle = dr["AnswerTitle"].ToString(); }
if (dr["AnswerAudioFileURL"] != DBNull.Value) { helpanswers.AnswerAudioFileURL = dr["AnswerAudioFileURL"].ToString(); }
lstanswers.Add(helpanswers);
}
questionobject.Answers = lstanswers;
}
responseObject.ResultObjectJSON = Serializer.ObjectToJSON(questionobject);
responseObject.ResultCode = "SUCCESS";
responseObject.ResultObjectRecordCount = count;
if (responseObject.ResultObjectRecordCount <= 0) { responseObject.ResultMessage = "No records found."; }
}
catch (Exception ex)
{
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "GetQuestions", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
return Serializer.ObjectToJSON(questionobject);
}
/// <summary>
/// Save person types (roles)
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="persontypeid">string</param>
/// <param name="persontype">string</param>
/// <returns>string</returns>
public string SavePersonType(string sessionKey, string persontypeid, string persontype)
{
string retValue = string.Empty;
ResponseObjectForAnything obj = new ResponseObjectForAnything();
Int32 pId = -1;
bool isValid = true;
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_SavePersonType");
if (!string.IsNullOrEmpty(persontypeid)) { db.AddInParameter(dbCommand, "@PersonTypeID", DbType.Int32, Int32.Parse(persontypeid)); }
else { db.AddInParameter(dbCommand, "@PersonTypeID", DbType.Int32, null); }
db.AddInParameter(dbCommand, "@PersonType", DbType.String, persontype);
if (persontypeid == null)
{
pId = Int32.Parse(db.ExecuteScalar(dbCommand).ToString());
obj.ResultObjectID = pId;
if (pId > 0)
obj.ResultCode = "SUCCESS";
else
obj.ResultCode = "ERROR";
obj.ResultObjectID = pId;
obj.ResultObjectRecordCount = pId;
if (obj.ResultObjectRecordCount <= 0) { obj.ResultMessage = "Unable to save group."; }
}
else
{
db.ExecuteNonQuery(dbCommand);
obj.ResultCode = "SUCCESS";
}
}
catch (Exception ex)
{
obj.ResultCode = "ERROR";
obj.ResultMessage = ex.Message.ToString();
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "SavePersonType", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
retValue = Serializer.ObjectToJSON(obj);
return retValue;
}
/// <summary>
/// Get all supported languages.
/// </summary>
/// <returns>string</returns>
public string GetLanguages(bool isAll)
{
string retValue = string.Empty;
List<Language> lstlang = new List<Language>();
ResponseObjectForAnything responseObject = new ResponseObjectForAnything();
int count = 0;
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_GetLanguages");
db.AddInParameter(dbCommand, "@isAll", DbType.Boolean, isAll);
DataSet dsLang = db.ExecuteDataSet(dbCommand);
if (dsLang.Tables.Count > 0)
{
DataTable tState = dsLang.Tables[0];
foreach (DataRow dr in tState.Rows)
{
Language lang = new Language();
if (dr["langid"] != DBNull.Value) { lang.langid = Int32.Parse(dr["langid"].ToString()); }
if (dr["alias"] != DBNull.Value) { lang.alias = dr["alias"].ToString(); }
if (dr["isenabled"] != DBNull.Value) { lang.isenabled = Convert.ToBoolean(dr["isenabled"].ToString()); }
lstlang.Add(lang);
count++;
}
responseObject.ResultObjectJSON = Serializer.ObjectToJSON(lstlang);
responseObject.ResultCode = "SUCCESS";
responseObject.ResultObjectRecordCount = count;
if (responseObject.ResultObjectRecordCount <= 0) { responseObject.ResultMessage = "No records found."; }
}
}
catch (Exception ex)
{
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "GetStates", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
return Serializer.ObjectToJSON(responseObject);
}
public string SavePrivateProject(string sessionKey, string privateprojectid, string personid, string isenabled, string videofilename, string photourl, string approvalstatusid)
{
string retValue = string.Empty;
ResponseObjectForAnything obj = new ResponseObjectForAnything();
Int32 pId = -1;
bool isValid = true;
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
if (approvalstatusid == "0") { approvalstatusid = "4"; }
if (isValid)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_SavePrivateProject");
if (privateprojectid != "0") { db.AddInParameter(dbCommand, "@PrivateProjectID", DbType.Int32, Int32.Parse(privateprojectid)); }
else { db.AddInParameter(dbCommand, "@PrivateProjectID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(personid)) { db.AddInParameter(dbCommand, "@PersonID", DbType.Int32, Int32.Parse(personid)); }
else { db.AddInParameter(dbCommand, "@PersonID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(approvalstatusid)) { db.AddInParameter(dbCommand, "@ApprovalStatusID", DbType.Int32, Int32.Parse(approvalstatusid)); }
else { db.AddInParameter(dbCommand, "@ApprovalStatusID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(isenabled)) { db.AddInParameter(dbCommand, "@IsEnabled", DbType.Boolean, Convert.ToBoolean(isenabled)); }
else { db.AddInParameter(dbCommand, "@IsEnabled", DbType.Boolean, null); }
db.AddInParameter(dbCommand, "@VideoFileName", DbType.String, videofilename);
db.AddInParameter(dbCommand, "@VideoURL", DbType.String, photourl);
if (privateprojectid == string.Empty || privateprojectid == "0")
{
pId = Int32.Parse(db.ExecuteScalar(dbCommand).ToString());
obj.ResultObjectID = pId;
if (pId > 0)
{
obj.ResultCode = "SUCCESS";
obj.ResultMessage = "Private Project have been enabled successfully.";
}
else
obj.ResultCode = "ERROR";
}
else
{
db.ExecuteNonQuery(dbCommand);
obj.ResultCode = "SUCCESS";
obj.ResultMessage = "Private Project have been saved successfully.";
}
}
catch (Exception ex)
{
obj.ResultCode = "ERROR";
obj.ResultMessage = ex.Message.ToString();
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "SavePersonFeedback", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
retValue = Serializer.ObjectToJSON(obj);
return retValue;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (cmbService.SelectedValue == "getstates")
{
txtResult.Text = w.GetStates(txtCountryID.Text);
}
if (cmbService.SelectedValue == "getcountries")
{
txtResult.Text = w.GetCountries();
}
if (cmbService.SelectedValue == "savegroups")
{
//txtResult.Text = w.SaveGroups(txtSessionKey.Text, null, "0", "Admin", @"http:\\steviart.azurewebsites.net\uploads\Elevator Shaft Or Tunnel-SoundBible.com-1359236004.wav");
}
if (cmbService.SelectedValue == "savepersontype")
{
txtResult.Text = w.SavePersonType(txtSessionKey.Text, txtPersonTypeID.Text, txtPersonType.Text);
}
if (cmbService.SelectedValue == "saveperson")
{
ResponseObjectForAnything obj = new ResponseObjectForAnything();
string filename = obj.ResultMessage;
//txtResult.Text = w.SavePerson(txtSessionKey.Text, txtPersonID.Text, txtPersonTypeID.Text, txtPersonGroupID.Text, cmbLanguage.SelectedValue, txtFirstName.Text,
// txtLastName.Text, txtDisplayName.Text, txtPassword.Text, txtEmail.Text, txtTelHome.Text, txtTelWork.Text, txtTelMobile.Text, filename, txtPersonCode.Text,
// txtJobTitle.Text, txtPersonAddressID.Text, txtAddressID.Text, txtAddressTypeID.Text, txtAddress1.Text, txtAddress2.Text, txtAddress3.Text, txtCity.Text, txtPinCode.Text,
// txtStateID.Text, txtCountryID.Text);
}
if (cmbService.SelectedValue == "getlanguages")
{
//txtResult.Text = w.GetLanguages();
}
if (cmbService.SelectedValue == "savesubject")
{
txtResult.Text = w.SaveSubject(txtSessionKey.Text, txtSubjectID.Text, txtDepartmentID.Text, cmbLanguage.SelectedValue, txtSubject.Text, @"http:\\steviart.azurewebsites.net\uploads\Elevator Shaft Or Tunnel-SoundBible.com-1359236004.wav");
}
if (cmbService.SelectedValue == "savedepartment")
{
//txtResult.Text = w.SaveDepartment(txtSessionKey.Text, txtDepartmentID.Text, cmbLanguage.SelectedValue, txtDepartment.Text, @"http:\\steviart.azurewebsites.net\uploads\Elevator Shaft Or Tunnel-SoundBible.com-1359236004.wav");
}
if (cmbService.SelectedValue == "saveprivateproject")
{
//txtResult.Text = w.SavePrivateProject(txtSessionKey.Text, txtPrivateProjectID.Text, txtPersonID.Text, txtPrivateProjectStatusID.Text, FileUpload1.FileName, @"http:\\steviart.azurewebsites.net\uploads\Elevator Shaft Or Tunnel-SoundBible.com-1359236004.wav",
// txtLangId.Text, txtTitle.Text, txtDescription.Text, "", "");
}
if (cmbService.SelectedValue == "savevideoquestion")
{
txtResult.Text = w.SaveVideoQuestions(txtSessionKey.Text, null, txtQuestionID.Text, null, txtLangId.Text, "1", @"http:\\steviart.azurewebsites.net\uploads\Elevator Shaft Or Tunnel-SoundBible.com-1359236004.wav", "10");
}
if (cmbService.SelectedValue == "savevideoanswers")
{
txtResult.Text = w.SaveVideoAnswers(txtSessionKey.Text, null, txtLangId.Text, txtQuestionID.Text, "A", @"http:\\steviart.azurewebsites.net\uploads\Elevator Shaft Or Tunnel-SoundBible.com-1359236004.wav");
}
if (cmbService.SelectedValue == "savepersonfeedback")
{
txtResult.Text = w.SavePersonFeedback(txtSessionKey.Text, null, txtPersonID.Text, "Awesome person", "1");
}
if (cmbService.SelectedValue == "savecontentvideo")
{
txtResult.Text = w.SaveContentVideo(txtSessionKey.Text, txtContentID.Text, txtVideoID.Text, @"http:\\steviart.azurewebsites.net\uploads\robotic.mp4");
}
if (cmbService.SelectedValue == "getdepartments")
{
//txtResult.Text = w.GetDepartments(txtSessionKey.Text, txtDepartmentID.Text);
}
if (cmbService.SelectedValue == "getpersons")
{
//txtResult.Text = w.GetPersons(txtSessionKey.Text, txtPersonID.Text, DateTime.Today.ToString());
}
if (cmbService.SelectedValue == "gethelpcontent")
{
txtResult.Text = w.GetHelpContent(txtSessionKey.Text, txtSubjectID.Text, txtContentID.Text);
}
if (cmbService.SelectedValue == "createsession")
{
txtResult.Text = w.CreateSession(txtEmail.Text, txtPassword.Text, txtDevice.Text);
}
if (cmbService.SelectedValue == "deletecontent")
{
txtResult.Text = w.DeleteContent(txtSessionKey.Text, txtContentID.Text);
}
if (cmbService.SelectedValue == "deletecontentvideo")
{
txtResult.Text = w.DeleteContentVideo(txtSessionKey.Text, txtVideoID.Text);
}
if (cmbService.SelectedValue == "deletegroups")
{
txtResult.Text = w.DeleteGroups(txtSessionKey.Text, txtPersonGroupID.Text);
}
if (cmbService.SelectedValue == "deleteperson")
{
txtResult.Text = w.DeletePerson(txtSessionKey.Text, txtPersonID.Text);
}
if (cmbService.SelectedValue == "deletesubject")
{
txtResult.Text = w.DeleteSubject(txtSessionKey.Text, txtSubjectID.Text);
}
if (cmbService.SelectedValue == "deletevideoanswers")
{
txtResult.Text = w.DeleteVideoAnswers(txtSessionKey.Text, txtAnswerID.Text);
}
if (cmbService.SelectedValue == "deletevideoquestions")
{
txtResult.Text = w.DeleteVideoQuestions(txtSessionKey.Text, txtQuestionID.Text);
}
if(cmbService.SelectedValue == "getsubjects")
{
//txtResult.Text = w.GetSubjects(txtSessionKey.Text, txtSubjectID.Text, txtDepartmentID.Text);
}
if (cmbService.SelectedValue == "getuserfromsession")
{
ResponseObjectForAnything responseObject = new ResponseObjectForAnything();
responseObject = w.GetUserFromSession(txtSessionKey.Text);
txtResult.Text = responseObject.ResultObjectJSON;
}
if(cmbService.SelectedValue == "savetask")
{
//txtResult.Text = w.SaveTask(txtSessionKey.Text, txtTelHome.Text, txtTelMobile.Text, "false", "", "2015-10-27", "1", "false", "2", "20", "0", "test", "test description", "steviart.azurewebsites.net/uploads/Elevator Shaft Or Tunnel-SoundBible.com-1359236004.wav", "10");
}
if (cmbService.SelectedValue == "savepersonfeedback")
{
txtResult.Text = w.SavePersonFeedback(txtSessionKey.Text, null, txtPersonID.Text, "2", "1");
}
//if (cmbService.SelectedValue == "GetSubCategories")
//{
// MasterlistEngine master = new MasterlistEngine();
// txtResult.Text = master.GetSubCategoryListJSON(txtCategory.Text);
//}
//if (cmbService.SelectedValue == "CreateSession")
//{
// AuthenticationEngine auth = new AuthenticationEngine();
// txtResult.Text = auth.CreateSessionJSON(txtEmail.Text, txtPassword.Text, "Anshu-PC");
//}
//if(cmbService.SelectedValue =="Logout")
//{
// AuthenticationEngine auth = new AuthenticationEngine();
// txtResult.Text = auth.LogoutJSON(txtSessionKey.Text, "Anshu-PC");
//}
//if (cmbService.SelectedValue == "GetUserFromSession")
//{
// AuthenticationEngine auth = new AuthenticationEngine();
// txtResult.Text = auth.GetUserFromSessionJSON(txtSessionKey.Text);
//}
//if (cmbService.SelectedValue == "PostProblem")
//{
// ProblemEngine probEngine = new ProblemEngine();
// txtResult.Text = probEngine.SaveProblemJSON(txtSessionKey.Text, txtProblemId.Text, "true", txtCompanyId.Text, txtHeading.Text, txtCategory.Text,
// txtSubCategory.Text, txtProduct.Text, txtModel.Text, txtDescription.Text, txtPurchaseMonth.Text, txtPurchaseYear.Text,
// txtProductStatus.Text, txtResolutionNeeded.Text, txtHashTags.Text, "false", "false", "130 High St", "Main St", "", "London", "", "", "WV100BA", "true");
//}
//if (cmbService.SelectedValue == "UploadFiles")
//{
// FileEngine file = new FileEngine();
// HttpContext context = HttpContext.Current;
// byte[] filearray = FileUpload1.FileBytes;
// txtResult.Text = file.UploadFilesJSON(txtSessionKey.Text, filearray, Path.GetFileName(FileUpload1.FileName), context, txtFileType.Text, txtProblemId.Text, txtResolutionId.Text, txtProblemMediaId.Text, txtResolutionMediaId.Text);
//}
//if (cmbService.SelectedValue == "EditBid")
//{
// BidEngine bid = new BidEngine();
// txtResult.Text = bid.SaveBids(txtSessionKey.Text, txtProblemId.Text, null, txtDescription.Text, "1", txtLink1.Text, txtTitle1.Text, txtLink2.Text, txtTitle2.Text, "1", "500", null, "20/09/2015,10:00,11:00;21/09/2015,17:00,19:00", "false");
//}
}
/// <summary>
/// Get persons list.
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="personId">string</param>
/// <param name="personTypeId">string</param>
/// <param name="persongroupid">string</param>
/// <param name="langid">string</param>
/// <param name="firstname">string</param>
/// <param name="lastname">string</param>
/// <param name="username">string</param>
/// <param name="password">string</param>
/// <param name="email">string</param>
/// <param name="countryid">string</param>
/// <param name="stateid">string</param>
/// <param name="telhome">string</param>
/// <param name="telwork">string</param>
/// <param name="telmobile">string</param>
/// <param name="profilepicture">string</param>
/// <param name="personcode">string</param>
/// <param name="jobtitle">string</param>
/// <returns>string</returns>
public string GetPersons(string sessionKey, string personId, string duedate, string persontypeid)
{
PersonObject personobj = new PersonObject();
List<Person> lstPerson = new List<Person>();
List<Address> lstAddress = new List<Address>();
List<PersonCompletedQuiz> lstcompletedquiz = new List<PersonCompletedQuiz>();
List<SteviArt.Common.DTO.Task> lsttasks = new List<Common.DTO.Task>();
List<PrivateProject> lstprivateprojs = new List<PrivateProject>();
List<PersonFeedback> lstfeedback = new List<PersonFeedback>();
ResponseObjectForAnything responseObject = new ResponseObjectForAnything();
int count = 0;
bool isValid = true;
if (!string.IsNullOrEmpty(sessionKey)) { isValid = IsValidSession(sessionKey); }
try
{
if (isValid)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_GetPerson");
if (!string.IsNullOrEmpty(personId)) { db.AddInParameter(dbCommand, "@PersonID", DbType.Int32, Int32.Parse(personId)); }
else { db.AddInParameter(dbCommand, "@PersonID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(duedate)) { db.AddInParameter(dbCommand, "@DueDate", DbType.DateTime, Convert.ToDateTime(duedate)); }
else { db.AddInParameter(dbCommand, "@DueDate", DbType.DateTime, null); }
if (!string.IsNullOrEmpty(persontypeid)) { db.AddInParameter(dbCommand, "@PersonTypeID", DbType.Int32, Int32.Parse(persontypeid)); }
else { db.AddInParameter(dbCommand, "@PersonTypeID", DbType.Int32, null); }
DataSet dsPersons = db.ExecuteDataSet(dbCommand);
if (dsPersons.Tables.Count > 0)
{
DataTable tUser = dsPersons.Tables[0];
foreach (DataRow dr in tUser.Rows)
{
Person person = new Person();
if (dr["PersonID"] != DBNull.Value) { person.PersonID = Int32.Parse(dr["PersonID"].ToString()); }
if (dr["PersonTypeID"] != DBNull.Value) { person.PersonTypeID = Int32.Parse(dr["PersonTypeID"].ToString()); }
if (dr["PreferredLanguageID"] != DBNull.Value) { person.PreferredLanguageID = Int32.Parse(dr["PreferredLanguageID"].ToString()); }
if (dr["FirstName"] != DBNull.Value) { person.FirstName = dr["FirstName"].ToString(); }
if (dr["LastName"] != DBNull.Value) { person.LastName = dr["LastName"].ToString(); }
if (dr["Username"] != DBNull.Value) { person.Username = dr["Username"].ToString(); }
if (dr["Email"] != DBNull.Value) { person.Email = dr["Email"].ToString(); }
if (dr["ProfilePicPath"] != DBNull.Value) { person.ProfilePicPath = dr["ProfilePicPath"].ToString(); }
if (dr["PersonGroupID"] != DBNull.Value) { person.PersonGroupID = Int32.Parse(dr["PersonGroupID"].ToString()); }
if (dr["GroupName"] != DBNull.Value) { person.GroupName = dr["GroupName"].ToString(); }
if (dr["PersonType"] != DBNull.Value) { person.PersonType = dr["PersonType"].ToString(); }
if (dr["RegisteredToken"] != DBNull.Value) { person.RegisteredToken = dr["RegisteredToken"].ToString(); }
if (dr["PointsEarned"] != DBNull.Value) { person.PointsEarned = Convert.ToInt32(dr["PointsEarned"].ToString()); }
if (dr["AvgFeedback"] != DBNull.Value) { person.AvgFeedback = Convert.ToDecimal(dr["AvgFeedback"].ToString()); }
if (dr["FullName"] != DBNull.Value) { person.FullName = dr["FullName"].ToString(); }
if (dr["AudioURL"] != DBNull.Value) { person.AudioURL = dr["AudioURL"].ToString(); }
if (dr["GroupAudioURL"] != DBNull.Value) { person.GroupAudioURL = dr["GroupAudioURL"].ToString(); }
lstPerson.Add(person);
count++;
}
personobj.Persons = lstPerson;
}
if(dsPersons.Tables.Count > 1)
{
DataTable tPersonQuiz = dsPersons.Tables[1];
foreach(DataRow dr in tPersonQuiz.Rows)
{
PersonCompletedQuiz completedquiz = new PersonCompletedQuiz();
if (dr["PersonCompletedQuizID"] != DBNull.Value) { completedquiz.PersonCompletedQuizID = Int32.Parse(dr["PersonCompletedQuizID"].ToString()); }
if (dr["VideoID"] != DBNull.Value) { completedquiz.VideoID = Int32.Parse(dr["VideoID"].ToString()); }
if (dr["VideoTitle"] != DBNull.Value) { completedquiz.VideoTitle = dr["VideoTitle"].ToString(); }
if (dr["CompletedDate"] != DBNull.Value) { completedquiz.CompletedDate = Convert.ToDateTime(dr["CompletedDate"].ToString()); }
if (dr["PointsEarned"] != DBNull.Value) { completedquiz.PointsEarned = Int32.Parse(dr["PointsEarned"].ToString()); }
lstcompletedquiz.Add(completedquiz);
}
personobj.PersonCompletedQuiz = lstcompletedquiz;
}
if (dsPersons.Tables.Count > 2)
{
DataTable tTasks = dsPersons.Tables[2];
foreach(DataRow dr in tTasks.Rows)
{
Common.DTO.Task task = new Common.DTO.Task();
if (dr["Title"] != DBNull.Value) { task.Title = dr["Title"].ToString(); }
if (dr["LastCompletionDate"] != DBNull.Value) { task.LastCompletionDate = Convert.ToDateTime(dr["LastCompletionDate"].ToString()); }
if (dr["PercentComplete"] != DBNull.Value) { task.PercentComplete = Decimal.Parse(dr["PercentComplete"].ToString()); }
if (dr["IsCompleted"] != DBNull.Value) { task.IsCompleted = Convert.ToBoolean(dr["IsCompleted"].ToString()); }
if (dr["DueDate"] != DBNull.Value) { task.DueDate = Convert.ToDateTime(dr["DueDate"].ToString()); }
lsttasks.Add(task);
}
personobj.Task = lsttasks;
}
if (dsPersons.Tables.Count > 3)
{
DataTable tPrivateProj = dsPersons.Tables[3];
foreach(DataRow dr in tPrivateProj.Rows)
{
Common.DTO.PrivateProject privateproj = new PrivateProject();
if (dr["PhotoURL"] != DBNull.Value) { privateproj.PhotoURL = dr["PhotoURL"].ToString(); }
if (dr["CreatedDate"] != DBNull.Value) { privateproj.CreatedDate = Convert.ToDateTime(dr["CreatedDate"].ToString()); }
if (dr["PersonID"] != DBNull.Value) { privateproj.PersonID = Int32.Parse(dr["PersonID"].ToString()); }
if (dr["ApprovalStatusName"] != DBNull.Value) { privateproj.ApprovalStatusName = dr["ApprovalStatusName"].ToString(); }
lstprivateprojs.Add(privateproj);
}
personobj.PrivateProject = lstprivateprojs;
}
if(dsPersons.Tables.Count > 4)
{
DataTable tFeedback = dsPersons.Tables[4];
foreach (DataRow dr in tFeedback.Rows)
{
Common.DTO.PersonFeedback feedback = new PersonFeedback();
if (dr["PersonFeedbackID"] != DBNull.Value) { feedback.PersonFeedbackID = Int32.Parse(dr["PersonFeedbackID"].ToString()); }
if (dr["PersonID"] != DBNull.Value) { feedback.PersonID = Int32.Parse(dr["PersonID"].ToString()); }
if (dr["PersonName"] != DBNull.Value) { feedback.PersonName = dr["PersonName"].ToString(); }
if (dr["Feedback"] != DBNull.Value) { feedback.Feedback = Convert.ToDecimal(dr["Feedback"].ToString()); }
if (dr["FeedbackSubmitterID"] != DBNull.Value) { feedback.FeedbackSubmitterID = Int32.Parse(dr["FeedbackSubmitterID"].ToString()); }
if (dr["FeedbackSubmitterName"] != DBNull.Value) { feedback.FeedbackSubmitterName = dr["FeedbackSubmitterName"].ToString(); }
if (dr["RankTopicID"] != DBNull.Value) { feedback.RankTopicID = Int32.Parse(dr["RankTopicID"].ToString()); }
if (dr["RankTopic"] != DBNull.Value) { feedback.RankTopic = dr["RankTopic"].ToString(); }
lstfeedback.Add(feedback);
}
personobj.PersonFeedback = lstfeedback;
}
}
responseObject.ResultObjectJSON = Serializer.ObjectToJSON(personobj);
responseObject.ResultCode = "SUCCESS";
responseObject.ResultObjectRecordCount = count;
if (responseObject.ResultObjectRecordCount <= 0) { responseObject.ResultMessage = "No records found."; }
}
catch (Exception ex)
{
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "GetPersons", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
return Serializer.ObjectToJSON(responseObject);
}
