public ActionResult Messageview(ViewModels.MessageViewModel msgvm)
{
ClinicalELDAL.EntityLayer.Message message = new ClinicalELDAL.EntityLayer.Message();
msgrp = new ClinicalELDAL.Repository.MessageRepository();
if (ModelState.IsValid)
{
message.SenderID = Convert.ToInt32(Session["UserID"]);
message.RecieverID = msgvm.RecieverID;
message.Body = msgvm.Body;
message.Date = msgvm.Date;
message.Time = msgvm.Time;
message.Status = "unread";
bool b = msgrp.AddMessage(message);
if (b == true)
{
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("Messageview"));
}
}
ViewModels.MessageViewModel msgvmobj = new ViewModels.MessageViewModel();
return(View(msgvmobj));
}
public ActionResult Messageview()
{
string docid = Request.QueryString["docid"];
ViewBag.DoctorID = docid;
ViewModels.MessageViewModel mvm = new ViewModels.MessageViewModel();
mvm.RecieverID = Convert.ToInt32(docid);
return(View(mvm));
}
public System.Web.Mvc.JsonResult DoSomething2_2()
{
// ایجاد یک لختی تصنعی
System.Threading.Thread.Sleep(millisecondsTimeout: 5000);
ViewModels.MessageViewModel viewModel =
new ViewModels.MessageViewModel
{
Message = "Hello, World!",
};
return(Json(data: viewModel,
behavior: System.Web.Mvc.JsonRequestBehavior.AllowGet));
}
// GET: /<controller>/
public IActionResult Index()
{
int pageIndex = Framework.Core.Transform.GetInt(Request.Query["p"], 1);
int pageSize = 10;
int userId = Framework.Core.Transform.GetInt(HttpContext.Session.GetString("UserId"), 0);
ViewModels.MessageViewModel model = new ViewModels.MessageViewModel();
//分页显示分享数据
MessageRepository repository = new MessageRepository();
var query = repository.GetMessageList();
model.ListData = query.Where(m => m.UserId == userId).Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList();
model.TotalCount = query.Where(m => m.UserId == userId).Count();
return(View(model));
}
public ActionResult SearchPost(string Search, string Save, string saveName, int tableId,
string[] SearchWhereName,
string[] SearchValue,
string[] SearchRange,
string[] SearchGroupName,
string[] SearchSelectName,
string[] SearchSelectValue)
{
var vm = new ViewModels.SearchQueryViewModel();
if (SearchSelectName == null)
{
vm.Query = "Selectは1つ以上指定してください。";
return(PartialView("_SearchQuery", vm));
}
var tableInfoInput = new Models.Search.FetchTableInfoInput();
tableInfoInput.TableId = tableId;
var tableInfo = fetchTableInfoRepository.FetchTableInfo(tableInfoInput);
if (tableInfo == null)
{
vm.Query = "選択されたテーブルがありません。テーブル選択からやり直してください。";
return(PartialView("_SearchQuery", vm));
}
var model = new Models.SearchModel();
model.WhereModel = new List <Models.SearchWhereModel>();
if (SearchWhereName != null)
{
for (var i = 0; i <= SearchWhereName.Length - 1; i++)
{
var sm = new Models.SearchWhereModel(SearchWhereName[i], (Models.WhereRangeEnum) int.Parse(SearchRange[i]), SearchValue[i]);
model.WhereModel.Add(sm);
}
}
model.SelectModel = new List <Models.SearchSelectModel>();
if (SearchSelectName != null)
{
for (var i = 0; i <= SearchSelectName.Length - 1; i++)
{
var sm = new Models.SearchSelectModel(SearchSelectName[i], (Models.SelectValueEnum) int.Parse(SearchSelectValue[i]));
model.SelectModel.Add(sm);
}
}
if (Save != null)
{
if (string.IsNullOrWhiteSpace(saveName))
{
return(PartialView("_Message", new MessageViewModel()
{
Message = "名前入力してください。"
}));
}
var tableInput = new Models.Search.FetchTableAllColumnInfoInput();
tableInput.TableId = tableId;
var tableOutput = fetchTableInfoRepository.FetchTableAllColumnInfo(tableInput);
var input = new Models.Search.SaveSearchSettingInput();
input.SearchSettingName = saveName;
input.SearchTableId = tableId;
var wheres = new List <Models.Search.SaveSearchWhereInput>();
var selects = new List <Models.Search.SaveSearchSelectInput>();
foreach (var item in model.SelectModel)
{
var select = new Models.Search.SaveSearchSelectInput();
var r = tableOutput.FetchTableColumnDetails.Where(x => x.ColumnName == item.SelectColumn).SingleOrDefault();
select.SelectColumnId = r.ColumnId;
select.SearchSelectValue = item.SelectValue;
selects.Add(select);
}
foreach (var item in model.WhereModel)
{
var where = new Models.Search.SaveSearchWhereInput();
var r = tableOutput.FetchTableColumnDetails.Where(x => x.ColumnName == item.WhereColumn).SingleOrDefault();
where.WhereColumnId = r.ColumnId;
where.WhereRange = item.WhereRange;
where.WhereValue = item.WhereValue;
wheres.Add(where);
}
input.Wheres = wheres;
input.Selects = selects;
saveSearchSettingRepository.SaveSearchSetting(input);
var messageVm = new ViewModels.MessageViewModel();
messageVm.Message = "Success";
return(PartialView("_Message", messageVm));
}
else
{
//Search
var parameters = new List <string>();
var query = new DbExtensions.SqlBuilder();
foreach (var item in model.SelectModel)
{
query.SELECT(item.ToSelectSql());
}
query.FROM(tableInfo.TableInfo.TableName);
foreach (var item in model.WhereModel)
{
query.WHERE(item.ToWhereSql(), item.WhereValue);
parameters.Add(item.WhereValue);
}
if (model.SelectModel.Any(x => x.SelectValue != Models.SelectValueEnum.Raw))
{
foreach (var item in model.SelectModel.Where(x => x.SelectValue == Models.SelectValueEnum.Raw))
{
query.GROUP_BY(item.SelectColumn);
}
}
DbExtensions.DatabaseConfiguration.DefaultProviderInvariantName = Properties.Settings.Default.ProviderName;
DbExtensions.DatabaseConfiguration.DefaultConnectionString = Properties.Settings.Default.DefaultConnection;
var db = new DbExtensions.Database();
var command = db.CreateCommand(query);
var paramstring = new System.Text.StringBuilder();
foreach (var item in parameters)
{
paramstring.AppendLine(item);
}
vm.Query = command.CommandText + "\r\n" + paramstring.ToString();
return(PartialView("_SearchQuery", vm));
}
}
