public List<MODEL.Journals> GetAll(int userId, int journalTypeId)
{
List<MODEL.Journals> JournalsList = null;
try
{
using (context = new AdvocateHealthCareEntities())
JournalsList = context.spGetJournals(userId, journalTypeId).Select(x => new MODEL.Journals
{
ProfileJournalID=x.ProfileJournalID,
ProfileName=x.ProfileName,
JournalInfo = x.JournalInfo,
JournalTitle = x.JournalTitle,
JournalAsset =x.JournalAsset,
LMPDate=x.LMPdate,
// CreatedDate=x.CreatedDate,
CreatedDate = x.Displaydate
}).ToList();
Journals js=new Journals();
js.JournalInfo = "Ask a new question";
js.JournalTitle = "Question for my care providor";
// js.JournalAsset = "http://183.82.48.194:5560/Images-Upload/add_a_journal.jpg";
js.JournalAsset = "/Images-Upload/add_a_journal_small.png";
JournalsList.Insert(0, js);
}
catch (Exception ex)
{
throw ex;
}
return JournalsList;
}
public List<MODEL.Tiles> GetAll(int? SUBCATEGORYID)
{
List<MODEL.Tiles> TilesList = null;
try
{
//string path = System.IO.Path.Combine(System.Web.HttpContext.Current.Request.PhysicalApplicationPath, "Image-Upload");
//System.IO.DirectoryInfo DirInfo = new System.IO.DirectoryInfo(path);
//System.Security.AccessControl.DirectorySecurity DirPermission = new System.Security.AccessControl.DirectorySecurity();
//System.Security.AccessControl.FileSystemAccessRule FRule = new System.Security.AccessControl.FileSystemAccessRule
// ("Everyone", System.Security.AccessControl.FileSystemRights.ReadAndExecute, System.Security.AccessControl.AccessControlType.Allow);
//DirPermission.AddAccessRule(FRule);
//if (DirInfo.Exists == false)
//{
// System.IO.Directory.CreateDirectory(path);
//}
using (context = new AdvocateHealthCareEntities())
TilesList = context.spGetTiles(SUBCATEGORYID).Select(x => new MODEL.Tiles
{
TITLE=x.TITLE,
CONTENT=x.CONTENT,
TITLEIMAGE = x.TILEIMAGE
}).ToList();
}
catch (Exception ex)
{
throw ex;
}
return TilesList;
}
public int Save(MODEL.WeightEntries weightentries, DBNull t2)
{
var result = 0;
var dbCtx = new AdvocateHealthCareEntities();
var dtweightentriesType = new DataTable();
dtweightentriesType.Columns.Add("WeightTrackerID", typeof(int));
dtweightentriesType.Columns.Add("ProfileID", typeof(int));
dtweightentriesType.Columns.Add("Weight", typeof(decimal));
dtweightentriesType.Columns.Add("CreatedDate",typeof(DateTime));
DateTime stcreateddate =Convert.ToDateTime(weightentries.CreatedDate);
dtweightentriesType.Rows.Add(weightentries.WeightTrackerID, weightentries.ProfileID, weightentries.Weight, stcreateddate);
// dtweightentriesType.Rows.Add(null,6,null,"2015-12-30 18:05:54.993");
var spsaveweightTracker = new SqlParameter();
spsaveweightTracker.ParameterName = "@WeightTrackerType";
spsaveweightTracker.Value = dtweightentriesType;
spsaveweightTracker.SqlDbType = SqlDbType.Structured;
spsaveweightTracker.TypeName = "WeightTrackerType";
var caseId = new SqlParameter("@LoggedInUser", SqlDbType.VarChar);
// caseId.Value = "PTG";
caseId.Value = weightentries.LoggedInUser;
result = dbCtx.Database.ExecuteSqlCommand("EXEC " + DataAccess.DataAccessConstants.SaveweightTracker + " @WeightTrackerType, @LoggedInUser", new object[] { spsaveweightTracker, caseId });
if (result == 0)
{
return 0;
}
else
{
return 1;
}
}
public List<MODEL.Notifications> GetAll(int UserId, int HospitalId)
{
List<MODEL.Notifications> NotificationsList = null;
try
{
using (context = new AdvocateHealthCareEntities())
//assessmentdetailsLst = dbCtx.spGetAssessmentDetails().Select(x => new refModel.AssessmentDetails
NotificationsList = context.spGetNotifications(UserId, HospitalId).Select(x => new MODEL.Notifications
{
HospitalID = x.HospitalID,
UserName=x.UserName,
NotificationID=x.NotificationID,
NotificationText=x.NotificationText,
NotificationTitle=x.NotificationTitle,
TypeOfNotification=x.TypeOfNotification,
IsRead=x.IsRead,
NotificationDate=x.NotificationDate,
HospitalName = x.HospitalName,
}).ToList();
}
catch (Exception ex)
{
throw ex;
}
return NotificationsList;
}
/// <summary>
/// This method is for to update the notification from unread to read
/// </summary>
/// <param name="notificationreadstatus"></param>
public void Save(NotificationReadStatus notificationreadstatus)
{
var result = 0;
var dbCtx = new AdvocateHealthCareEntities();
dbCtx.spSaveNotificationReadStatus(notificationreadstatus.UserID, notificationreadstatus.NotificationID);
//dbCtx.spSaveNotificationReadStatus(3, 1);
}
public List<MODEL.UserSavedImages> GetAll(int userId)
{
List<MODEL.UserSavedImages> ImagesList = null;
try
{
//var image = "text";
////string uri = "http://183.82.48.194:5560/api/NotificationReadStatus/" + arun;
//string uri1 = "http://183.82.48.194:5560/api/NotificationReadStatus/" + image;
//string userName = WebConfigurationManager.AppSettings["baseurl"];
////string uri = userName+"/api/NotificationReadStatus/" + arun;
//string uri = userName + "" + image;
//string path = System.IO.Path.Combine(System.Web.HttpContext.Current.Request.PhysicalApplicationPath, "Image-Upload");
//System.IO.DirectoryInfo DirInfo = new System.IO.DirectoryInfo(path);
//System.Security.AccessControl.DirectorySecurity DirPermission = new System.Security.AccessControl.DirectorySecurity();
//System.Security.AccessControl.FileSystemAccessRule FRule = new System.Security.AccessControl.FileSystemAccessRule
// ("Everyone", System.Security.AccessControl.FileSystemRights.ReadAndExecute, System.Security.AccessControl.AccessControlType.Allow);
//DirPermission.AddAccessRule(FRule);
//if (DirInfo.Exists == false)
//{
// System.IO.Directory.CreateDirectory(path);
//}
using (context = new AdvocateHealthCareEntities())
ImagesList = context.spGetUserSavedImages(userId).Select(x => new MODEL.UserSavedImages
{
JournalTitle = x.JournalTitle,
JournalAsset = x.JournalAsset,
CreatedDate = x.DisplayDate
}).ToList();
UserSavedImages usi = new UserSavedImages();
// usi.JournalAsset = "http://183.82.48.194:5560/Images-Upload/camera.jpg";
usi.JournalAsset ="/Images-Upload/camera.png";
//usi.JournalAsset = "~/Images-Upload/camera-updated.png";
ImagesList.Insert(0, usi);
}
catch (Exception ex)
{
throw ex;
}
return ImagesList;
}
public int Save(MODEL.ProfileJournal profilejournal, DBNull t2)
{
var result = 0;
var dbCtx = new AdvocateHealthCareEntities();
var dtProfileJournalType = new DataTable();
dtProfileJournalType.Columns.Add("ProfileJournalID", typeof(string));
dtProfileJournalType.Columns.Add("ProfileID", typeof(int));
dtProfileJournalType.Columns.Add("JournalTitle", typeof(string));
dtProfileJournalType.Columns.Add("JournalInfo", typeof(string));
dtProfileJournalType.Columns.Add("JournalAsset", typeof(string));
dtProfileJournalType.Columns.Add("JournalTypeID", typeof(int));
//dtProfileJournalType.Columns.Add("CreatedDate", typeof(string));
dtProfileJournalType.Columns.Add("CreatedDate", typeof(DateTime));
//dtProfileJournalType.Columns.Add("CreatedBy", typeof(string));
dtProfileJournalType.Rows.Add(profilejournal.ProfileJournalID, profilejournal.ProfileID,
profilejournal.JournalTitle, profilejournal.JournalInfo,
profilejournal.JournalAsset, profilejournal.JournalTypeID,
profilejournal.CreatedDate);
// dtProfileJournalType.Rows.Add(5, 2, "sirisha", null, "~/Images-Upload/gallery_img1.png", 2);
var spSaveProfileJournal = new SqlParameter();
spSaveProfileJournal.ParameterName = "@ProfileJournalType";
spSaveProfileJournal.Value = dtProfileJournalType;
spSaveProfileJournal.SqlDbType = SqlDbType.Structured;
spSaveProfileJournal.TypeName = "ProfileJournalType";
var caseId = new SqlParameter("@LoggedInUser", SqlDbType.VarChar);
// caseId.Value = "PTG";
caseId.Value = profilejournal.LoggedInUser;
result = dbCtx.Database.ExecuteSqlCommand("EXEC " + DataAccess.DataAccessConstants.SaveProfileJournal + " @ProfileJournalType, @LoggedInUser", new object[] { spSaveProfileJournal, caseId });
if (result == 0)
{
return 0;
}
else
{
return 1;
}
}
public int Save(HospitalInfo hospitalinfo, DBNull t2)
{
var result = 0;
var dbCtx = new AdvocateHealthCareEntities();
var dtHospitalInfoType = new DataTable();
dtHospitalInfoType.Columns.Add("HospitalID", typeof(int));
dtHospitalInfoType.Columns.Add("HospitalName", typeof(string));
dtHospitalInfoType.Columns.Add("Description", typeof(string));
dtHospitalInfoType.Columns.Add("CreatedDate", typeof(DateTime));
dtHospitalInfoType.Columns.Add("CreatedBy", typeof(string));
dtHospitalInfoType.Columns.Add("ModifiedDate", typeof(DateTime));
dtHospitalInfoType.Columns.Add("ModifiedBy", typeof(string));
//dtHospitalInfoType.Rows.Add(hospitalinfo.HospitalID, hospitalinfo.HospitalName, hospitalinfo.Description,
// hospitalinfo.CreatedDate, hospitalinfo.CreatedBy, hospitalinfo.ModifiedDate,
// hospitalinfo.ModifiedBy);
dtHospitalInfoType.Rows.Add(7, "dsggcxcf", "dsggfsf",
null, null, null,
null);
var spSaveHospitalInfo = new SqlParameter();
spSaveHospitalInfo.ParameterName = "@HospitalType";
spSaveHospitalInfo.Value = dtHospitalInfoType;
spSaveHospitalInfo.SqlDbType = SqlDbType.Structured;
spSaveHospitalInfo.TypeName = "HospitalType";
var caseId = new SqlParameter("@LoggedInUser", SqlDbType.VarChar);
//caseId.Value = hospitalinfo.LoggedInUser;
caseId.Value = "PTG";
result = dbCtx.Database.ExecuteSqlCommand("EXEC " + DataAccess.DataAccessConstants.SaveHospitalInfo + "@HospitalType, @LoggedInUser", new object[] { spSaveHospitalInfo, caseId });
if (result == 0)
{
return 0;
}
else
{
return 1;
}
}
public int Save(MODEL.NotificationType notificationtype, DBNull t2)
{
var result = 0;
var dbCtx = new AdvocateHealthCareEntities();
var dtnotificationType = new DataTable();
dtnotificationType.Columns.Add("NotificationID", typeof(int));
dtnotificationType.Columns.Add("NotificationTypeID", typeof(int));
dtnotificationType.Columns.Add("ProfileID", typeof(int));
dtnotificationType.Columns.Add("Title", typeof(string));
dtnotificationType.Columns.Add("Comments", typeof(string));
dtnotificationType.Columns.Add("IsRead", typeof(bool));
dtnotificationType.Columns.Add("CreatedDate", typeof(DateTime));
dtnotificationType.Columns.Add("CreatedBy", typeof(string));
dtnotificationType.Rows.Add(notificationtype.NotificationID, notificationtype.NotificationTypeID, notificationtype.ProfileID,
notificationtype.Title, notificationtype.Comments, notificationtype.IsRead, notificationtype.CreatedDate,
notificationtype.CreatedBy);
//dtnotificationType.Rows.Add(7,1,3,"Pregnancy",null,null,null,null);
var spSaveNotifications = new SqlParameter();
spSaveNotifications.ParameterName = "@NotificationType";
spSaveNotifications.Value = dtnotificationType;
spSaveNotifications.SqlDbType = SqlDbType.Structured;
spSaveNotifications.TypeName = "NotificationType";
var caseId = new SqlParameter("@LoggedInUser", SqlDbType.VarChar);
caseId.Value = notificationtype.LoggedInUser;
// caseId.Value = "PTG";
result = dbCtx.Database.ExecuteSqlCommand("EXEC " + DataAccess.DataAccessConstants.SaveNotifications + " @NotificationType, @LoggedInUser", new object[] { spSaveNotifications, caseId });
if (result == 0)
{
return 0;
}
else
{
return 1;
}
}
public List<MODEL.WeightEntries> GetAll(int userId)
{
List<MODEL.WeightEntries> WeightEntriesList = null;
try
{
using (context = new AdvocateHealthCareEntities())
WeightEntriesList = context.spGetWeightEntries(userId).Select(x => new MODEL.WeightEntries
{
Weight=x.Weight,
LMPDATE=x.LMPDATE,
CreatedDate=x.DisplayDate
}).ToList();
}
catch (Exception ex)
{
throw ex;
}
return WeightEntriesList;
}
//public List<MODEL.JournalVideos> GetAll()
/// <summary>
/// this method is used to get the videos based on SUBCATEGORYID
/// </summary>
/// <param name="SUBCATEGORYID"></param>
/// <returns></returns>
public List<MODEL.JournalVideos> GetAll(int? SUBCATEGORYID)
{
List<MODEL.JournalVideos> JournalVideosList = null;
try
{
using (context = new AdvocateHealthCareEntities())
JournalVideosList = context.spGetJournalVideos(SUBCATEGORYID).Select(x => new MODEL.JournalVideos
{
JournalVideoName = x.JournalVideoName,
JournalVideoAsset = x.JournalVideoAsset
}).ToList();
}
catch (Exception ex)
{
throw ex;
}
return JournalVideosList;
}
public List<MODEL.HospitalInfo> GetAll()
{
List<MODEL.HospitalInfo> hosipitalDetailsList = null;
try
{
using (context = new AdvocateHealthCareEntities())
hosipitalDetailsList = context.spGetHosipitalDetails().Select(x => new MODEL.HospitalInfo
{
HospitalID = x.HospitalID,
HospitalName = x.HospitalName,
}).ToList();
}
catch (Exception ex)
{
throw ex;
}
return hosipitalDetailsList;
}
public List<MODEL.ContentSearch> GetAll(string String )
{
List<MODEL.ContentSearch> ContentSearchList = null;
try
{
using (context = new AdvocateHealthCareEntities())
ContentSearchList = context.spGetContentSearch(String).Select(x => new MODEL.ContentSearch
{
Title=x.Title,
Content=x.Content,
TileImage=x.TileImage
}).ToList();
}
catch (Exception ex)
{
throw ex;
}
return ContentSearchList;
}
/// <summary>
/// This method is used to get the images based on Hospital selection
/// </summary>
/// <param name="UserID"></param>
/// <param name="HospitalID"></param>
/// <param name="AssetPositionID"></param>
/// <returns></returns>
public List<MODEL.HospitalImages> GetAll(int UserID, int HospitalID, byte? AssetPositionID)
{
List<MODEL.HospitalImages> HospitalImagesList = null;
try
{
using (context = new AdvocateHealthCareEntities())
HospitalImagesList = context.spGetHosipitalImages(UserID, HospitalID, AssetPositionID).Select(x => new MODEL.HospitalImages
{
AssetURL=x.AssetURL,
AssetText=x.AssetText,
AssetImage=x.AssetImage,
AssetPositionID = x.AssetPositionID.Value
}).ToList();
}
catch (Exception ex)
{
throw ex;
}
return HospitalImagesList;
}
/// <summary>
/// This method is used to save the Hospital Images
/// </summary>
/// <param name="hospitalimages"></param>
/// <param name="t2"></param>
/// <returns></returns>
public int Save(MODEL.HospitalImages hospitalimages, DBNull t2)
{
var result = 0;
var dbCtx = new AdvocateHealthCareEntities();
var dtHospitalImagesType = new DataTable();
dtHospitalImagesType.Columns.Add("HospitalImagesID", typeof(int));
dtHospitalImagesType.Columns.Add("HospitalID", typeof(int));
dtHospitalImagesType.Columns.Add("AssetURL", typeof(string));
dtHospitalImagesType.Columns.Add("AssetText", typeof(string));
dtHospitalImagesType.Columns.Add("AssetImage", typeof(string));
dtHospitalImagesType.Columns.Add("AssetPositionID", typeof(byte));
dtHospitalImagesType.Rows.Add(hospitalimages.HospitalImagesID, hospitalimages.HospitalID,
hospitalimages.AssetURL, hospitalimages.AssetText, hospitalimages.AssetImage,hospitalimages.AssetPositionID);
// dtHospitalImagesType.Rows.Add(null,4,null);
var spSaveHospitalImages = new SqlParameter();
spSaveHospitalImages.ParameterName = "@HospitalImagesType";
spSaveHospitalImages.Value = dtHospitalImagesType;
spSaveHospitalImages.SqlDbType = SqlDbType.Structured;
spSaveHospitalImages.TypeName = "HospitalImagesType";
var caseId = new SqlParameter("@LoggedInUser", SqlDbType.VarChar);
//caseId.Value = "PTG";
caseId.Value = hospitalimages.LoggedInUser;
result = dbCtx.Database.ExecuteSqlCommand("EXEC " + DataAccess.DataAccessConstants.SaveHospitalImages + " @HospitalImagesType, @LoggedInUser", new object[] { spSaveHospitalImages, caseId });
if (result == 0)
{
return 0;
}
else
{
return 1;
}
}
public MODEL.AuthenticateLogin GetAll(string UserEmailId, string UserPwd)
{
MODEL.AuthenticateLogin LoginList = null;
try
{
using (context = new AdvocateHealthCareEntities())
{
LoginList = context.spAuthenticateLogin(UserEmailId, UserPwd).Select(x => new MODEL.AuthenticateLogin
{
HospitalID = Convert.ToInt32(x.HospitalID),
ProfileID = Convert.ToInt32(x.ProfileID),
Flag=x.Flag
}).FirstOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
return LoginList;
}
/// <summary>
/// This Method is for create new Profile .
/// </summary>
/// <param name="profileinfo"></param>
/// <param name="t2"></param>
/// <returns></returns>
public int Save(ProfileInfo profileinfo, DBNull t2)
{
// byte[] byteArray = profileinfo.picture1;
// MemoryStream ms = new MemoryStream(byteArray);
// System.Drawing.Image im = System.Drawing.Image.FromStream(ms);
//// im.Save("~/images/1111.jpg");
// System.Web.Hosting.HostingEnvironment.MapPath("~/Images-Upload/1111.jpg");
var result = 0;
var dbCtx = new AdvocateHealthCareEntities();
var dtProfileInfoType = new DataTable();
dtProfileInfoType.Columns.Add("ProfileID", typeof(int));
dtProfileInfoType.Columns.Add("FirstName", typeof(string));
dtProfileInfoType.Columns.Add("LastName", typeof(string));
dtProfileInfoType.Columns.Add("Email", typeof(string));
dtProfileInfoType.Columns.Add("Password", typeof(string));
dtProfileInfoType.Columns.Add("LMPdate", typeof(DateTime));
dtProfileInfoType.Columns.Add("Picture", typeof(string));
dtProfileInfoType.Columns.Add("HospitalID", typeof(int));
dtProfileInfoType.Columns.Add("CreatedDate", typeof(DateTime));
dtProfileInfoType.Rows.Add(profileinfo.ProfileID, profileinfo.FirstName, profileinfo.LastName,
profileinfo.Email, profileinfo.Password, profileinfo.LMPdate,
profileinfo.Picture, profileinfo.HospitalID, profileinfo.CreatedDate);
//dtProfileInfoType.Rows.Add(null, "dsggcxcf", "dsggfsf", "*****@*****.**", 123, null, null, 1,
// DateTime.Now);
var spSaveProfileInfo1 = new SqlParameter();
spSaveProfileInfo1.ParameterName = "@ProfileType";
spSaveProfileInfo1.Value = dtProfileInfoType;
spSaveProfileInfo1.SqlDbType = SqlDbType.Structured;
spSaveProfileInfo1.TypeName = "ProfileType";
var caseId = new SqlParameter("@LoggedInUser", SqlDbType.VarChar);
// caseId.Value = "PTG";
caseId.Value = profileinfo.LoggedInUser;
//This code is for Return the Output value
var spReturn = new SqlParameter("RetVal", SqlDbType.Int, 100);
spReturn.Direction = ParameterDirection.Output;
//result = dbCtx.Database.ExecuteSqlCommand("EXEC " + DataAccess.DataAccessConstants.SaveProfileInfo + " @ProfileType, @LoggedInUser", new object[] { spSaveProfileInfo1, caseId });
result = dbCtx.Database.ExecuteSqlCommand("EXEC " + DataAccess.DataAccessConstants.SaveProfileInfo1 + " @ProfileType, @LoggedInUser,@RetVal OUTPUT", new object[] { spSaveProfileInfo1, caseId, spReturn });
return (int)spReturn.Value == 0 ? 0 : 1;
//if (result >1)
//{
// return 1;
//}
//else
//{
// return 0;
//}
}
