/// <summary>
/// 查找所有关联的公司部门岗位编号
/// </summary>
/// <param name="departmentCode">部门编号</param>
/// <param name="parentPositionCode">上级岗位编号</param>
/// item1:所有上级岗位编号 item2：所有关联的公司部门编号
/// <returns></returns>
private Tuple <string, string> GetAllCode(string departmentCode, string parentPositionCode)
{
var allParentPositionCode = "";
var fullCode = "";//所有上级公司+部门Code
if (!string.IsNullOrEmpty(parentPositionCode))
{
//查找所有上级岗位Code
var parentPosition = Repository <TbPosition> .First(p => p.PositionCode == parentPositionCode);
if (parentPosition != null)
{
allParentPositionCode = parentPosition.ParentPositionCode_F;
fullCode = parentPosition.FullCode;
}
}
else
{
//查找部门信息
var department = Repository <TbDepartment> .First(p => p.DepartmentCode == departmentCode);
if (department != null)
{
fullCode = department.FullCode;
}
}
return(new Tuple <string, string>(allParentPositionCode, fullCode));
}
/// <summary>
/// 删除数据
/// </summary>
public AjaxResult Delete(string keyValue)
{
try
{
var position = Repository <TbPosition> .First(p => p.PositionCode == keyValue);
if (position == null)
{
return(AjaxResult.Warning("信息不存在"));
}
//判断岗位是否有子集
var Any = Repository <TbPosition> .Any(p => p.ParentPositionCode == position.PositionCode);
if (Any)
{
return(AjaxResult.Warning("该岗位有下级岗位,不能删除"));
}
var count = Repository <TbPosition> .Delete(p => p.PositionCode == keyValue);
if (count > 0)
{
return(AjaxResult.Success());
}
return(AjaxResult.Error("操作失败"));
}
catch (Exception ex)
{
return(AjaxResult.Error(ex.ToString()));
}
}
public void Should_Throw_Exception_Retrieving_First_Entity_By_Id()
{
Assert.Throws <EntityNotFoundException>(() =>
{
Repository.First <TestItemModel>(Guid.NewGuid());
});
}
/// <summary>
/// Executes this command.
/// </summary>
/// <param name="imageId">The image id.</param>
/// <returns>The view model.</returns>
public ImageViewModel Execute(Guid imageId)
{
var image = Repository.First <MediaImage>(imageId);
var dimensionsCalculator = new ImageDimensionsCalculator(image);
return(new ImageViewModel
{
Id = image.Id.ToString(),
Caption = image.Caption,
Title = image.Title,
Description = image.Description,
Url = FileUrlResolver.EnsureFullPathUrl(image.PublicUrl),
ThumbnailUrl = FileUrlResolver.EnsureFullPathUrl(image.PublicThumbnailUrl),
Version = image.Version.ToString(CultureInfo.InvariantCulture),
FileName = image.OriginalFileName,
FileExtension = image.OriginalFileExtension,
FileSize = image.SizeAsText(),
ImageWidth = image.Width,
ImageHeight = image.Height,
CroppedWidth = dimensionsCalculator.ResizedCroppedWidth,
CroppedHeight = dimensionsCalculator.ResizedCroppedHeight,
OriginalImageWidth = image.OriginalWidth,
OriginalImageHeight = image.OriginalHeight,
ImageAlign = image.ImageAlign.HasValue ? image.ImageAlign.Value : MediaImageAlign.Center,
CropCoordX1 = image.CropCoordX1.HasValue ? image.CropCoordX1.Value : 0,
CropCoordY1 = image.CropCoordY1.HasValue ? image.CropCoordY1.Value : 0,
CropCoordX2 = image.CropCoordX2.HasValue ? image.CropCoordX2.Value : image.OriginalWidth,
CropCoordY2 = image.CropCoordY2.HasValue ? image.CropCoordY2.Value : image.OriginalHeight,
OriginalImageUrl = FileUrlResolver.EnsureFullPathUrl(image.PublicOriginallUrl + string.Format("?{0}", DateTime.Now.ToString(MediaManagerModuleDescriptor.HardLoadImageDateTimeFormat))),
FolderId = image.Folder != null ? image.Folder.Id : (Guid?)null,
Tags = TagService.GetMediaTagNames(imageId)
});
}
/// <summary>
/// Executes this command.
/// </summary>
/// <param name="request">The request.</param>
public void Execute(ImageViewModel request)
{
var mediaImage = Repository.First <MediaImage>(request.Id.ToGuidOrDefault());
UnitOfWork.BeginTransaction();
Repository.Save(mediaImage.CreateHistoryItem());
mediaImage.PublishedOn = DateTime.Now;
mediaImage.Caption = request.Caption;
mediaImage.Title = request.Title;
mediaImage.Description = request.Description;
mediaImage.ImageAlign = request.ImageAlign;
mediaImage.Version = request.Version.ToIntOrDefault();
// Calling resize and after then crop
ResizeAndCropImage(mediaImage, request);
Repository.Save(mediaImage);
// Save tags
IList <Root.Models.Tag> newTags;
TagService.SaveMediaTags(mediaImage, request.Tags, out newTags);
UnitOfWork.Commit();
// Notify.
Events.MediaManagerEvents.Instance.OnMediaFileUpdated(mediaImage);
}
/// <summary>
/// Executes this command.
/// </summary>
/// <param name="imageId">The image id.</param>
/// <returns>The view model.</returns>
public virtual ImageViewModel Execute(Guid imageId)
{
var image = Repository.First <MediaImage>(imageId);
return(new ImageViewModel
{
Id = image.Id.ToString(),
Caption = image.Caption,
Title = image.Title,
Url = image.PublicUrl,
ThumbnailUrl = image.PublicThumbnailUrl,
Version = image.Version.ToString(CultureInfo.InvariantCulture),
FileName = image.OriginalFileName,
FileExtension = image.OriginalFileExtension,
FileSize = MediaFileService.GetFileSizeText(image.Size),
ImageWidth = image.Width,
ImageHeight = image.Height,
OriginalImageWidth = image.OriginalWidth,
OriginalImageHeight = image.OriginalHeight,
ImageAlign = image.ImageAlign.HasValue ? image.ImageAlign.Value : MediaImageAlign.Left,
CropCoordX1 = image.CropCoordX1.HasValue ? image.CropCoordX1.Value : 0,
CropCoordY1 = image.CropCoordY1.HasValue ? image.CropCoordY1.Value : 0,
CropCoordX2 = image.CropCoordX2.HasValue ? image.CropCoordX2.Value : image.OriginalWidth,
CropCoordY2 = image.CropCoordY2.HasValue ? image.CropCoordY2.Value : image.OriginalHeight,
OriginalImageUrl = image.PublicOriginallUrl
});
}
public void Should_Retrieve_First_Entity_By_Id()
{
var entity = Repository.First <TestItemModel>(model1.Id);
Assert.IsNotNull(entity);
Assert.AreEqual(entity.Id, model1.Id);
}
public void Should_Refresh_Entity()
{
// Create entity
var model = DatabaseTestDataProvider.ProvideRandomTestItemModel();
Repository.Save(model);
UnitOfWork.Commit();
var version = model.Version;
// Load attached and detached version, touch multiple times
var detachedModel = Repository.First <TestItemModel>(model.Id);
// Open another session
using (var container = ContextScopeProvider.CreateChildContainer())
{
var repository2 = container.Resolve <IRepository>();
var unitOfWork2 = container.Resolve <IUnitOfWork>();
var attachedModel = repository2.First <TestItemModel>(model.Id);
attachedModel.Name = TestDataProvider.ProvideRandomString();
unitOfWork2.Commit();
}
Assert.AreEqual(detachedModel.Version, version);
// Refresh detached entity - version should be updated
Repository.Refresh(detachedModel);
Assert.AreNotEqual(detachedModel.Version, version);
}
/// <summary>
/// 判断信息是否已存在库存信息
/// </summary>
/// <param name="keyValue">Id</param>
/// <param name="materialCode">原材料编号</param>
/// <param name="storageCode">仓库编号</param>
/// <param name="storageCode">站点编号</param>
/// <returns></returns>
public AjaxResult AnyAdd(TbRawMaterialStockRecord model)
{
var rawMaterialStock = Repository <TbRawMaterialStockRecord> .First(p => p.MaterialCode == model.MaterialCode &&
p.StorageCode == model.StorageCode &&
p.Factory == model.Factory &&
p.BatchNumber == model.BatchNumber &&
p.WorkAreaCode == model.WorkAreaCode &&
p.SiteCode == model.SiteCode);
if (model.ID == 0)
{
if (rawMaterialStock == null)
{
return(AjaxResult.Success());
}
}
else
{
if (rawMaterialStock == null || rawMaterialStock.ID == model.ID)
{
return(AjaxResult.Success());
}
}
return(AjaxResult.Warning("操作失败,该原材所在仓库及站点库存已存在"));
}
public void Should_Detach_Entity()
{
// Create entity
var model = DatabaseTestDataProvider.ProvideRandomTestItemModel();
Repository.Save(model);
UnitOfWork.Commit();
// Touch entity - changes should be saved on flush
var version = model.Version;
var attachedModel = Repository.First <TestItemModel>(model.Id);
attachedModel.Name = TestDataProvider.ProvideRandomString();
UnitOfWork.Commit();
Assert.Greater(attachedModel.Version, version);
version = attachedModel.Version;
// Detach and touch again - changes shouldn't saved on flush
var detachedModel = Repository.First <TestItemModel>(model.Id);
Repository.Detach(detachedModel);
detachedModel.Name = TestDataProvider.ProvideRandomString();
UnitOfWork.Commit();
Assert.AreEqual(detachedModel.Version, version);
}
/// <summary>
/// 删除数据
/// </summary>
public AjaxResult DeleteNew(string depCode, bool isApi = false)
{
try
{
//查找信息
var model = Repository <TbDepartment> .First(p => p.DepartmentCode == depCode);
if (model == null)
{
return(AjaxResult.Error("信息不存在"));
}
var count = Repository <TbDepartment> .Delete(t => t.DepartmentCode == depCode, isApi);
if (count <= 0)
{
return(AjaxResult.Error());
}
return(AjaxResult.Success());
}
catch (Exception e)
{
var err = e.ToString();
return(AjaxResult.Error(err));
}
}
/// <summary>
/// Executes the specified request.
/// </summary>
/// <param name="request">The page view model.</param>
/// <returns>Created page</returns>
public virtual SavePageResponse Execute(AddNewPageViewModel request)
{
// Create / fix page url
var pageUrl = request.PageUrl;
var createPageUrl = (pageUrl == null);
if (createPageUrl && !string.IsNullOrWhiteSpace(request.PageTitle))
{
pageUrl = pageService.CreatePagePermalink(request.PageTitle, request.ParentPageUrl);
}
else
{
pageUrl = urlService.FixUrl(pageUrl);
// Validate Url
pageService.ValidatePageUrl(pageUrl);
}
var page = new PageProperties
{
PageUrl = pageUrl,
Title = request.PageTitle,
Layout = Repository.First <Root.Models.Layout>(request.TemplateId),
IsPublic = true,
Status = PageStatus.Unpublished
};
Repository.Save(page);
UnitOfWork.Commit();
// Notifying, that page is created
PagesApiContext.Events.OnPageCreated(page);
return(new SavePageResponse(page));
}
/// <summary>
/// Executes this command.
/// </summary>
/// <param name="imageId">The image id.</param>
/// <returns>The view model.</returns>
public ImageViewModel Execute(Guid imageId)
{
var image = Repository.First <MediaImage>(imageId);
return(new ImageViewModel
{
Id = image.Id.ToString(),
Caption = image.Caption,
Title = image.Title,
Description = image.Description,
Url = FileUrlResolver.EnsureFullPathUrl(image.PublicUrl),
ThumbnailUrl = FileUrlResolver.EnsureFullPathUrl(image.PublicThumbnailUrl),
Version = image.Version.ToString(CultureInfo.InvariantCulture),
FileName = image.OriginalFileName,
FileExtension = image.OriginalFileExtension,
FileSize = image.SizeAsText(),
ImageWidth = image.Width,
ImageHeight = image.Height,
OriginalImageWidth = image.OriginalWidth,
OriginalImageHeight = image.OriginalHeight,
ImageAlign = image.ImageAlign.HasValue ? image.ImageAlign.Value : MediaImageAlign.Center,
CropCoordX1 = image.CropCoordX1.HasValue ? image.CropCoordX1.Value : 0,
CropCoordY1 = image.CropCoordY1.HasValue ? image.CropCoordY1.Value : 0,
CropCoordX2 = image.CropCoordX2.HasValue ? image.CropCoordX2.Value : image.OriginalWidth,
CropCoordY2 = image.CropCoordY2.HasValue ? image.CropCoordY2.Value : image.OriginalHeight,
OriginalImageUrl = FileUrlResolver.EnsureFullPathUrl(image.PublicOriginallUrl),
Tags = TagService.GetMediaTagNames(imageId)
});
}
/// <summary>
/// Executes the specified request.
/// </summary>
/// <param name="request">The request.</param>
/// <returns></returns>
public bool Execute(DeleteWidgetRequest request)
{
UnitOfWork.BeginTransaction();
var widget = Repository.First <Root.Models.Widget>(request.WidgetId);
widget.Version = request.Version;
var isWidgetInUse = Repository.AsQueryable <PageContent>().Any(f => f.Content.Id == request.WidgetId && !f.IsDeleted && !f.Page.IsDeleted);
if (isWidgetInUse)
{
throw new ValidationException(() => string.Format(PagesGlobalization.Widgets_CanNotDeleteWidgetIsInUse_Message, widget.Name),
string.Format("A widget {0}(id={1}) can't be deleted because it is in use.", widget.Name, request.WidgetId));
}
Repository.Delete(widget);
if (widget.ContentOptions != null)
{
foreach (var option in widget.ContentOptions)
{
Repository.Delete(option);
}
}
UnitOfWork.Commit();
// Notify.
Events.PageEvents.Instance.OnWidgetDeleted(widget);
return(true);
}
public ActionResult CreateKiosk(string id)
{
var company = Repository.GetById(id);
if (company == null)
{
return(HttpNotFound());
}
if (Repository.Any(c => c.CompanyKey == company.CompanyKey + "Kiosk"))
{
return(Manage(Repository.First(c => c.CompanyKey == company.CompanyKey + "Kiosk").Id));
}
company.Id = company.CompanyKey += "Kiosk";
company.CompanyKey = company.Id;
company.CompanyName = company.Id;
AppendToSettingValue(company, "TaxiHail.ApplicationKey", "Kiosk");
AppendToSettingValue(company, "TaxiHail.ApplicationName", " Kiosk");
AppendToSettingValue(company, "TaxiHail.SiteName", " Kiosk");
AppendToSettingValue(company, "ApplicationName", " Kiosk");
AppendToSettingValue(company, "AppName", " Kiosk");
Repository.Update(company);
new AssetsManager(id).CopyTo(company.Id, "public.keystore");
new WebThemeFilesManager(id).CopyTo(company.Id);
return(Manage(company.Id));
}
/// <summary>
/// 删除数据
/// </summary>
public AjaxResult Delete(string RoleCode, bool isApi = false)
{
try
{
var model1 = Repository <TbRoleMenu> .First(p => p.RoleCode == RoleCode);
if (model1 != null)
{
return(AjaxResult.Error("该角色已经分配权限，不能删除"));
}
var model2 = Repository <TbUserRole> .First(p => p.RoleCode == RoleCode);
if (model2 != null)
{
return(AjaxResult.Error("该角色已经分配用户，不能删除"));
}
var count = Repository <TbRole> .Delete(t => t.RoleCode == RoleCode, isApi);
if (count > 0)
{
return(AjaxResult.Success());
}
return(AjaxResult.Error());
}
catch (Exception)
{
return(AjaxResult.Error());
}
}
/// <summary>
/// 修改数据(单条)
/// </summary>
public AjaxResult Update(TbFormWindowsShowFields request)
{
if (request == null)
{
return(AjaxResult.Warning("参数错误"));
}
try
{
var model = Repository <TbFormWindowsShowFields> .First(p => p.PhysicalTableName == request.PhysicalTableName && p.FieldCode == request.FieldCode);
if (model == null)
{
return(AjaxResult.Error("信息不存在"));
}
model.FieldCode = request.FieldCode;
model.FieldName = request.FieldName;
model.FieldShowOrder = request.FieldShowOrder;
model.PhysicalTableName = request.PhysicalTableName;
model.FieldIsShow = request.FieldIsShow;
model.FieldWidth = request.FieldWidth;
model.FormWindowsTableName = request.FormWindowsTableName;
var count = Repository <TbFormWindowsShowFields> .Update(model);
if (count > 0)
{
return(AjaxResult.Success());
}
return(AjaxResult.Error());
}
catch (Exception)
{
return(AjaxResult.Error());
}
}
/// <summary>
/// Executes this command.
/// </summary>
/// <param name="request">The request.</param>
public void Execute(ImageViewModel request)
{
var mediaImage = Repository.First <MediaImage>(request.Id.ToGuidOrDefault());
var archivedImage = MediaImageService.MoveToHistory(mediaImage);
// Calling resize and after then crop
var croppedFileStream = ResizeAndCropImage(mediaImage, request);
mediaImage.Caption = request.Caption;
mediaImage.Title = request.Title;
mediaImage.Description = request.Description;
mediaImage.ImageAlign = request.ImageAlign;
if (croppedFileStream != null)
{
MediaImageService.SaveEditedImage(mediaImage, archivedImage, croppedFileStream, request.ShouldOverride);
}
else
{
MediaImageService.SaveImage(mediaImage);
}
UnitOfWork.BeginTransaction();
// Save tags
IList <Root.Models.Tag> newTags;
TagService.SaveMediaTags(mediaImage, request.Tags, out newTags);
UnitOfWork.Commit();
// Notify.
Events.MediaManagerEvents.Instance.OnMediaFileUpdated(mediaImage);
}
public static Result updateTeacher(User newUser, Teacher teacher)
{
using (SGContext db = new SGContext())
{
try
{
var userRepository = new Repository <User>(db);
var tchRepo = new Repository <Teacher>(db);
var user = userRepository.First(d => d.UserId == newUser.UserId);
var tch = tchRepo.First(d => d.TeacherId == teacher.TeacherId);
user.Ad = newUser.Ad;
user.Email = newUser.Email;
user.Soyad = newUser.Soyad;
user.TCKimlik = newUser.TCKimlik;
user.Tel = newUser.Tel;
tch.GenelBasvuru = teacher.GenelBasvuru;
tch.Kidem = teacher.Kidem;
tch.SchoolId = teacher.SchoolId;
tch.Unvan = teacher.Unvan;
db.SaveChanges();
result = new Result(SystemRess.Messages.basarili_kayit.ToString(), SystemRess.Messages.basarili_durum.ToString());
return(result);
}
catch (Exception)
{
result = new Result(SystemRess.Messages.hatali_kayit.ToString(), SystemRess.Messages.hatali_durum.ToString());
return(result);
}
}
}
public void Should_Attach_Entity()
{
// Create entity
var model = DatabaseTestDataProvider.ProvideRandomTestItemModel();
Repository.Save(model);
UnitOfWork.Commit();
var version = model.Version;
// Load detached version, touch multiple times
var detachedModel = Repository.First <TestItemModel>(model.Id);
Repository.Detach(detachedModel);
detachedModel.Name = TestDataProvider.ProvideRandomString();
UnitOfWork.Commit();
detachedModel.Name = TestDataProvider.ProvideRandomString();
UnitOfWork.Commit();
Assert.AreEqual(detachedModel.Version, version);
// Attach and save again
Repository.Attach(detachedModel);
detachedModel.Name = TestDataProvider.ProvideRandomString();
UnitOfWork.Commit();
Assert.AreNotEqual(detachedModel.Version, version);
}
/// <summary>
/// Executes this command.
/// </summary>
/// <param name="request">The request.</param>
public void Execute(FileViewModel request)
{
var mediaFile = Repository.First <MediaFile>(request.Id.ToGuidOrDefault());
UnitOfWork.BeginTransaction();
Repository.Save(mediaFile.CreateHistoryItem());
mediaFile.PublishedOn = DateTime.Now;
mediaFile.Title = request.Title;
mediaFile.Description = request.Description;
mediaFile.Version = request.Version.ToIntOrDefault();
mediaFile.Image = request.Image != null && request.Image.ImageId.HasValue ? Repository.AsProxy <MediaImage>(request.Image.ImageId.Value) : null;
Repository.Save(mediaFile);
// Save tags
IList <Root.Models.Tag> newTags;
tagService.SaveMediaTags(mediaFile, request.Tags, out newTags);
// Save user access if enabled:
if (cmsConfiguration.AccessControlEnabled)
{
accessControlService.UpdateAccessControl(request.UserAccessList, mediaFile.Id);
}
UnitOfWork.Commit();
// Notify.
Events.MediaManagerEvents.Instance.OnMediaFileUpdated(mediaFile);
}
/// <summary>
/// 查询页
/// </summary>
/// <param name="keyValue"></param>
/// <returns></returns>
public DataTable Details(int keyValue, bool isApi = false)
{
var ret = Db.Context.From <TbSafeDatumManage>()
.Select(
TbSafeDatumManage._.All
, TbCompany._.CompanyFullName.As("ProcessFactoryName")
, TbUser._.UserName.As("InsertUserName"))
.LeftJoin <TbCompany>((a, c) => a.ProcessFactoryCode == c.CompanyCode)
.AddSelect(Db.Context.From <TbUser>().Select(p => p.UserName)
.Where(TbUser._.UserCode == TbSafeDatumManage._.SpeechUser), "SpeechUserName")
.LeftJoin <TbUser>((a, c) => a.InsertUserCode == c.UserCode)
.Where(p => p.ID == keyValue).ToDataTable();
//修改浏览数
var article = Repository <TbSafeDatumManage> .First(p => p.ID == keyValue);
article.BrowseCount += 1;
Repository <TbSafeDatumManage> .Update(article, p => p.ID == keyValue, isApi);
if (ret.Rows.Count > 0)
{
var data = ret.Rows[0]["SpeechContent"].ToString().Replace("<", "<").Replace(">", ">");
ret.Rows[0]["SpeechContent"] = data;
}
return(ret);
}
/// <summary>
/// Executes this command.
/// </summary>
/// <param name="request">The request.</param>
public void Execute(ImageViewModel request)
{
var mediaImage = Repository.First <MediaImage>(request.Id.ToGuidOrDefault());
mediaImage.PublishedOn = DateTime.Now;
mediaImage.Caption = request.Caption;
mediaImage.Title = request.Title;
mediaImage.Description = request.Description;
mediaImage.ImageAlign = request.ImageAlign;
// Calling resize and after then crop
var archivedImage = MediaImageService.MoveToHistory(mediaImage);
var croppedFileStream = ResizeAndCropImage(mediaImage, request);
MediaImageService.SaveEditedImage(mediaImage, archivedImage, croppedFileStream);
UnitOfWork.BeginTransaction();
// Save tags
IList <Root.Models.Tag> newTags;
TagService.SaveMediaTags(mediaImage, request.Tags, out newTags);
UnitOfWork.Commit();
// Update thumbnail
MediaImageService.UpdateThumbnail(mediaImage, Size.Empty);
// Notify.
Events.MediaManagerEvents.Instance.OnMediaFileUpdated(mediaImage);
}
/// <summary>
/// 新增数据(单条)
/// </summary>
public AjaxResult Insert(TbRoleRequset request)
{
if (request == null)
{
return(AjaxResult.Warning("参数错误"));
}
try
{
var model1 = Repository <TbRole> .First(d => d.RoleName == request.RoleName);
if (model1 != null)
{
return(AjaxResult.Error("角色名称重复"));
}
var model = MapperHelper.Map <TbRoleRequset, TbRole>(request);
model.RoleCode = request.RoleCode;
model.RoleName = request.RoleName;
model.RoleDetail = request.RoleDetail;
model.State = "启用";
var count = Repository <TbRole> .Insert(model);
if (count > 0)
{
return(AjaxResult.Success());
}
return(AjaxResult.Error());
}
catch (Exception)
{
return(AjaxResult.Error());
}
}
/// <summary>
/// 新增数据(评论)
/// </summary>
public AjaxResult InsertComment(TbArticleComment model, bool isApi = false)
{
if (model == null)
{
return(AjaxResult.Warning("参数错误"));
}
model.InsertTime = DateTime.Now;
model.Type = 1;
if (model.CommentID != 0)
{
model.Type = 2;
}
//修改浏览数
var article = Repository <TbArticle> .First(p => p.ID == model.ArticleID);
article.CommentCount += 1;
try
{
using (DbTrans trans = Db.Context.BeginTransaction())
{
//添加信息
Repository <TbArticleComment> .Insert(trans, model, isApi);
//修改浏览数
Repository <TbArticle> .Update(trans, article, p => p.ID == model.ArticleID, isApi);
trans.Commit();
return(AjaxResult.Success());
}
}
catch (Exception)
{
return(AjaxResult.Error());
}
}
/// <summary>
/// Saves SEO information.
/// </summary>
/// <param name="model">The SEO information model.</param>
/// <returns>
/// true if SEO information saved successfully; false otherwise.
/// </returns>
public virtual EditSeoViewModel Execute(EditSeoViewModel model)
{
var page = Repository.First <PageProperties>(model.PageId);
bool initialHasSeo = page.HasSEO;
Models.Redirect newRedirect = null;
page.Version = model.Version;
page.Title = model.PageTitle;
model.ChangedUrlPath = urlService.FixUrl(model.ChangedUrlPath);
if (!string.Equals(model.PageUrlPath, model.ChangedUrlPath))
{
pageService.ValidatePageUrl(model.ChangedUrlPath, model.PageId);
if (model.CreatePermanentRedirect)
{
var redirect = redirectService.CreateRedirectEntity(model.PageUrlPath, model.ChangedUrlPath);
if (redirect != null)
{
Repository.Save(redirect);
newRedirect = redirect;
}
}
page.NodeCountInSitemap = model.UpdateSitemap
? sitemapService.ChangeUrl(page.PageUrl, model.ChangedUrlPath)
: sitemapService.NodesWithUrl(model.ChangedUrlPath);
page.PageUrl = model.ChangedUrlPath;
}
page.PageUrlHash = page.PageUrl.UrlHash();
page.MetaTitle = model.MetaTitle;
page.MetaKeywords = model.MetaKeywords;
page.MetaDescription = model.MetaDescription;
page.UseCanonicalUrl = model.UseCanonicalUrl;
Repository.Save(page);
UnitOfWork.Commit();
// Notify about SEO change.
if (page.HasSEO != initialHasSeo)
{
Events.PageEvents.Instance.OnPageSeoStatusChanged(page);
}
// Notify about new redirect creation.
if (newRedirect != null)
{
Events.PageEvents.Instance.OnRedirectCreated(newRedirect);
}
return(new EditSeoViewModel {
PageUrlPath = page.PageUrl
});
}
public void Should_Throw_Exception_Retrieving_First_Entity_By_Filter()
{
Assert.Throws <EntityNotFoundException>(() =>
{
var guid = Guid.NewGuid();
Repository.First <TestItemModel>(m => m.Id == guid);
});
}
/// <summary>
/// Executes the specified request.
/// </summary>
/// <param name="request">The request.</param>
/// <returns>Media preview.</returns>
public MediaPreviewViewModel Execute(Guid request)
{
var media = Repository.First <Media>(m => m.Id == request);
return(new MediaPreviewViewModel {
HtmlForPreview = media.GetPreviewHtml()
});
}
/// <summary>
/// 确认签收
/// </summary>
public AjaxResult SemiFinishedSignNew(string OrderCode)
{
if (string.IsNullOrWhiteSpace(OrderCode))
{
return(AjaxResult.Warning("参数错误"));
}
string sql = @"select a.ID,a.OrderCodeH,b.OrderCode,b.DisEntOrderId from TbSemiFinishedSign a
left join TbSiteDischargeCargo b on a.DischargeCargoCode=b.DischargeCargoCode
where (a.DischargeCargoCode is not null and a.OperateState is null and b.OrderCode='" + OrderCode + "') or (OrderCodeH='" + OrderCode + "')";
DataTable dt = Db.Context.FromSql(sql).ToDataTable();
List <TbSemiFinishedSign> listsf = new List <TbSemiFinishedSign>();
List <TbDistributionEntOrder> listEnt = new List <TbDistributionEntOrder>();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
//半成品签收
TbSemiFinishedSign model = Repository <TbSemiFinishedSign> .First(p => p.ID == Convert.ToInt32(dt.Rows[i]["ID"]));
model.OperateState = "已签收";
model.SigninTime = DateTime.Now;
model.InsertUserCode = OperatorProvider.Provider.CurrentUser.UserCode;//签收人编号
listsf.Add(model);
if (!string.IsNullOrWhiteSpace(dt.Rows[i]["DisEntOrderId"].ToString()))
{
TbDistributionEntOrder modelEnt = Repository <TbDistributionEntOrder> .First(p => p.ID == Convert.ToInt32(dt.Rows[i]["DisEntOrderId"]));
modelEnt.SignState = "已签收"; //签收状态
modelEnt.SignStateTime = DateTime.Now; //签收完成时间
listEnt.Add(modelEnt);
}
}
}
try
{
using (DbTrans trans = Db.Context.BeginTransaction())//使用事务
{
if (listsf.Count > 0)
{
Repository <TbSemiFinishedSign> .Update(trans, listsf, true);//半成品签收
}
if (listEnt.Count > 0)
{
Repository <TbDistributionEntOrder> .Update(trans, listEnt, true); //配送装车订单
}
trans.Commit(); //提交事务
return(AjaxResult.Success());
}
}
catch (Exception ex)
{
return(AjaxResult.Error(ex.ToString()));
}
}
/// <summary>
/// 收藏
/// </summary>
public AjaxResult Collect(int keyValue, string userCode, bool isApi = false)
{
try
{
//判断信息是否存在
var anyRet = AnyInfo(keyValue);
if (anyRet.state != ResultType.success.ToString())
{
return(anyRet);
}
//判断信息是否已收藏
var collect = Repository <TbArticleCollect> .First(p => p.ArticleID == keyValue && p.InsertUserCode == userCode);
if (collect == null)
{
var newCollect = new TbArticleCollect()
{
ArticleID = keyValue,
InsertUserCode = userCode,
InsertTime = DateTime.Now
};
((TbArticle)anyRet.data).CollectCount += 1;
using (DbTrans trans = Db.Context.BeginTransaction())
{
//添加收藏信息
Repository <TbArticleCollect> .Insert(trans, newCollect, isApi);
//修改收藏数
Repository <TbArticle> .Update(trans, (TbArticle)anyRet.data, p => p.ID == keyValue, isApi);
trans.Commit();
return(AjaxResult.Success("收藏成功"));
}
}
else
{
((TbArticle)anyRet.data).CollectCount -= 1;
using (DbTrans trans = Db.Context.BeginTransaction())
{
//删除收藏信息
Repository <TbArticleCollect> .Delete(trans, collect, isApi);
//修改收藏数
Repository <TbArticle> .Update(trans, (TbArticle)anyRet.data, p => p.ID == keyValue, isApi);
trans.Commit();
return(AjaxResult.Success("取消成功"));
}
}
return(AjaxResult.Success());
}
catch (Exception)
{
return(AjaxResult.Error());
}
}
public static Setting GetSettings()
{
using (SGContext db = new SGContext())
{
try
{
var settingRepo = new Repository<Setting>(db);
var settings = settingRepo.First();
return settings;
}catch(Exception){
return new Setting();
}
}
}
public void Commit_Store_Elements()
{
ProductCategory cat = new ProductCategory {Name = "Temporary cat"};
_catRepo.Insert(cat);
_unitOfWork.Commit();
Assert.That(cat, Has.Property("Id").GreaterThan(0));
using (var ctx = new Context())
{
var adp = new DbContextAdapter(ctx);
var repo = new Repository<ProductCategory>(adp);
Assert.That(repo.First(pc => pc.Name == cat.Name), Is.Not.Null);
}
}
public static Result SinavOlustur(Sinav sinav, NameValueCollection collection)
{
using (SGContext db = new SGContext())
{
try
{
SinavOturum otur = new SinavOturum();
School sch = new School();
otur.Okullar = new List<School>();
sinav.SinavOturum = new List<SinavOturum>();
int oturumNo = 1;
//sinav.SinavDurum = db.SinavDurum.FirstOrDefault(d => d.KisaDurum == "Onaylanmadı");
foreach (var item in collection.AllKeys)
{
if (item.Contains("sinavoturum_Tarih"))
{
otur = new SinavOturum();
otur.Tarih = Convert.ToDateTime(collection.GetValues(item)[0]);
}
else if (item.Contains("sinavoturum_Saat"))
{
otur.Saat = collection.GetValues(item)[0];
otur.OturumNo = oturumNo++;
otur.SinavOturumDurumId = (int)SG_DAL.Enums.EnumSinavDurum.OnaylanmamisSinav;
sinav.SinavOturum.Add(otur);
}
else if (item.Contains("duallistbox_okullar"))
{
foreach (var okulid in collection.GetValues(item))
{
var okulRepo = new Repository<School>(db);
int id = Convert.ToInt32(okulid);
var okul = okulRepo.First(d => d.SchoolId == id);
//////////////////////
//////////////////////
List<SinavOturumOkullari> oturumokullist = new List<SinavOturumOkullari>();
foreach (var sinavoturumlari in sinav.SinavOturum)
{
sinavoturumlari.Okullar.Add(okul);
}
}
}
}
var sinavRepo = new Repository<Sinav>(db);
sinavRepo.Add(sinav);
var sinavOturumlari = SinavManager.GetSinavOturumlari(sinav.SinavId);
foreach (var oturum in sinavOturumlari)
{
var sinavoturumokulu = new SinavOturumOkullari();
var sinavOtrOkul = SchoolManager.GetSinavOturumOkullari(oturum.SinavOturumId);
foreach (var okul in sinavOtrOkul)
{
sinavoturumokulu.SchoolId = okul.SchoolId;
sinavoturumokulu.SinavOturumId = oturum.SinavOturumId;
sinavoturumokulu.AsilGozetmenSayisi = 0;
sinavoturumokulu.YedekGozetmenSayisi = 0;
db.SinavOturumOkullari.Add(sinavoturumokulu);
db.SaveChanges();
}
}
result = new Result(SystemRess.Messages.basarili_kayit.ToString(), SystemRess.Messages.basarili_durum.ToString());
return result;
}
catch (Exception)
{
result = new Result(SystemRess.Messages.hatali_kayit.ToString(), SystemRess.Messages.hatali_durum.ToString());
return result;
}
}
}
public static SinavOturumOkullari GetSinavOturumOkulu(int okulID, int SinavOturumId)
{
using (SGContext db = new SGContext())
{
try
{
var repo = new Repository<SinavOturumOkullari>(db);
var okul = repo.First(d => d.SchoolId == okulID && d.SinavOturumId == SinavOturumId);
return okul;
}
catch (Exception)
{
return null;
}
}
}
public static SinavGorevli GetSinavGorevli(int SinavOturumId, int TeacherId)
{
using (SGContext db = new SGContext())
{
try
{
var gorevliRepo = new Repository<SinavGorevli>(db);
var gorevli = gorevliRepo.First(d => d.SinavOturumId == SinavOturumId && d.TeacherId == TeacherId);
return gorevli;
}
catch (Exception)
{
return null;
}
}
}
public static Result OkulGuncelle(School guncelokul)
{
using (SGContext db = new SGContext())
{
try
{
var repo = new Repository<School>(db);
School okul = repo.First(d => d.SchoolId == guncelokul.SchoolId);
okul.MebKodu = guncelokul.MebKodu;
okul.Ad = guncelokul.Ad;
repo.UpdateSaveChanges();
result = new Result("İşlem başarılı", SystemRess.Messages.basarili_durum.ToString());
return result;
}
catch (Exception)
{
result = new Result(SystemRess.Messages.hatali_kayit.ToString(), SystemRess.Messages.hatali_durum.ToString());
return result;
}
}
}
public void OneCard()
{
var oneCards = new Repository().GetCard("01001");
Assert.IsNotNull(oneCards);
Assert.AreEqual(oneCards.First().Title, "Noise: Hacker Extraordinaire");
}
public void Decklist()
{
var decklists = new Repository().GetDecklist("20866");
Assert.IsNotNull(decklists);
Assert.AreEqual(20866, decklists.First().Id);
}
public static List<Teacher> ReadTeachersFromExcel(string filePath)
{
var data = new StringBuilder();
try
{
Net.SourceForge.Koogra.IWorkbook wb = null;
string fileExt = Path.GetExtension(filePath);
if (string.IsNullOrEmpty(fileExt))
{
throw new Exception("File extension not found");
}
if (fileExt.Equals(".xlsx", StringComparison.OrdinalIgnoreCase))
{
wb = Net.SourceForge.Koogra.WorkbookFactory.GetExcel2007Reader(filePath);
}
else if (fileExt.Equals(".xls", StringComparison.OrdinalIgnoreCase))
{
wb = Net.SourceForge.Koogra.WorkbookFactory.GetExcelBIFFReader(filePath);
}
Net.SourceForge.Koogra.IWorksheet ws = wb.Worksheets.GetWorksheetByIndex(0);
List<Teacher> list = new List<Teacher>();
for (uint r = ws.FirstRow + 1; r <= ws.LastRow; ++r)
{
Net.SourceForge.Koogra.IRow row = ws.Rows.GetRow(r);
if (row != null)
{
Teacher teacher = new Teacher();
teacher.User = new User();
teacher.Unvan = (int)SG_DAL.Enums.EnumUnvan.Ogretmen;
teacher.GenelBasvuru = true;
teacher.User.Rol = (int)SG_DAL.Enums.EnumRol.ogretmen;
teacher.GorevSayisi = 0;
for (uint colCount = ws.FirstCol; colCount <= ws.LastCol; ++colCount)
{
string cellData = string.Empty;
if (row.GetCell(colCount) != null && row.GetCell(colCount).Value != null)
{
cellData = row.GetCell(colCount).Value.ToString();
switch (colCount)
{
case 0: teacher.User.Ad = cellData;
break;
case 1: teacher.User.Soyad = cellData;
break;
case 2: teacher.User.TCKimlik = Convert.ToInt64(cellData);
teacher.User.Sifre = cellData;
break;
case 3: teacher.User.Email = cellData;
break;
case 4: teacher.User.Tel = cellData;
break;
case 5: teacher.Kidem = cellData;
break;
case 6:
using (SGContext db = new SGContext())
{
var schoolRepo = new Repository<School>(db);
int mebkodu = Convert.ToInt32(cellData);
School sch = schoolRepo.First(d => d.MebKodu == mebkodu);
teacher.SchoolId = sch.SchoolId;
}
break;
default:
break;
}
}
}
list.Add(teacher);
}
}
return list;
}
catch (Exception)
{
return new List<Teacher>();
}
}
public static Result updateTeacher(User newUser, Teacher teacher)
{
using (SGContext db = new SGContext())
{
try
{
var userRepository = new Repository<User>(db);
var tchRepo = new Repository<Teacher>(db);
var user = userRepository.First(d => d.UserId == newUser.UserId);
var tch = tchRepo.First(d => d.TeacherId == teacher.TeacherId);
user.Ad = newUser.Ad;
user.Email = newUser.Email;
user.Soyad = newUser.Soyad;
user.TCKimlik = newUser.TCKimlik;
user.Tel = newUser.Tel;
tch.GenelBasvuru = teacher.GenelBasvuru;
tch.Kidem = teacher.Kidem;
tch.SchoolId = teacher.SchoolId;
tch.Unvan = teacher.Unvan;
db.SaveChanges();
result = new Result(SystemRess.Messages.basarili_kayit.ToString(), SystemRess.Messages.basarili_durum.ToString());
return result;
}
catch (Exception)
{
result = new Result(SystemRess.Messages.hatali_kayit.ToString(), SystemRess.Messages.hatali_durum.ToString());
return result;
}
}
}
