public void BulkDeleteByTicket(int ticketId) { using (TsicsContext db = new TsicsContext()) { db.Database.ExecuteSqlCommand("DELETE FROM TicketParcipant WHERE TicketId = {0}", ticketId); } }
public void DeleteAllParticipant(int tickedId) { using (TsicsContext db = new TsicsContext()) { db.Database.ExecuteSqlCommand("Delete from TicketParcipant where TicketId = '" + tickedId + "'"); } }
public void DeleteAllTagsInTicket(int TicketId) { using (TsicsContext db = new TsicsContext()) { db.Database.ExecuteSqlCommand("Delete from ArticleTag where TicketId = '" + TicketId + "'"); } }
public void DeleteAllAttachmentInTicket(int TicketId) { using (TsicsContext db = new TsicsContext()) { db.Database.ExecuteSqlCommand("Delete from TicketAttachment where TicketId = '" + TicketId + "'"); } }
public void DeleteUseFullLink(int id) { using (TsicsContext db = new TsicsContext()) { db.Database.ExecuteSqlCommand("delete from Article where Article.ArticleId = " + id); } }
public void setActiveBranchInvolved(int Areaid) { using (TsicsContext db = new TsicsContext()) { db.Database.ExecuteSqlCommand("UPDATE MasterBranch set Status = 1 where MasterAreaId = " + Areaid); }; }
public void DeleteChild(int parent) { using (TsicsContext db = new TsicsContext()) { db.Database.ExecuteSqlCommand("UPDATE ArticleCategory set Status = 2 where Parent = " + parent); }; }
public void DeleteAll(int ArticleId) { using (TsicsContext db = new TsicsContext()) { db.Database.ExecuteSqlCommand("delete from ArticleFile where ArticleId = " + ArticleId); } }
public Article AddUseFullLink(Article article) { using (TsicsContext db = new TsicsContext()) { _dBtsicsContext.Article.Add(article); _dBtsicsContext.SaveChanges(); return(article); } }
public void Delete(ArticleCategory data) { using (TsicsContext db = new TsicsContext()) { db.Database.ExecuteSqlCommand("Delete from ArticleCategory where Parent = " + data.Parent); } _dBtsics.Entry(data).State = EntityState.Deleted; _dBtsics.SaveChanges(); }
public Delegation AddDelegation(Delegation delegation) { _dBtsics.Delegation.Add(delegation); _dBtsics.SaveChanges(); using (TsicsContext db = new TsicsContext()) { db.Database.ExecuteSqlCommand("UPDATE UserTsics set IsDelegate = " + delegation.DelegateId + "where UserId = " + delegation.FromUser); } if (delegation.CreatedAt >= delegation.StartDate) { DelegateUser(delegation); } return(delegation); }
public void EndDelegate() { List <Delegation> result = _dBtsics.Delegation.Where(d => DateTime.Now > d.EndDate && d.Status.Equals(1)).ToList(); if (result.Count > 0) { using (TsicsContext db = new TsicsContext()) { foreach (var list in result) { db.Database.ExecuteSqlCommand("UPDATE UserTsics set IsDelegate = 0 where UserId = " + list.FromUser); db.Database.ExecuteSqlCommand("UPDATE Delegation set Status = 2 where DelegateId = " + list.DelegateId); } } } }
public void DelegateUser(Delegation delegation) { using (TsicsContext db = new TsicsContext()) { var DelegationData = _dBtsics.Delegation.OrderByDescending(d => d.CreatedAt).FirstOrDefault().DelegateId; db.Database.ExecuteSqlCommand("update ticket set ticket.Responder = " + delegation.ToUser + ",ticket.NextCommenter = " + delegation.ToUser + ", DelegateId = " + DelegationData + " where (ticket.Responder = " + delegation.FromUser + ") and (ticket.Status != 3 and ticket.Status != 5) and (ticket.DelegateId = 0 ) and (ticket.NextCommenter = ticket.Responder)"); db.Database.ExecuteSqlCommand("update ticket set ticket.Responder = " + delegation.ToUser + ", DelegateId = " + DelegationData + " where (ticket.Responder = " + delegation.FromUser + ") and (ticket.Status != 3 and ticket.Status != 5) and (ticket.DelegateId = 0 ) and (ticket.NextCommenter != ticket.Responder)"); db.Database.ExecuteSqlCommand("update ticket set ticket.Submiter = " + delegation.ToUser + ", ticket.NextCommenter = " + delegation.ToUser + ", DelegateId = " + DelegationData + " where(ticket.Submiter = " + delegation.FromUser + ") and (ticket.Status != 3 and ticket.Status != 5) and (ticket.DelegateId = 0 ) and (ticket.NextCommenter = ticket.Submiter)"); db.Database.ExecuteSqlCommand("update ticket set ticket.Submiter = " + delegation.ToUser + ", DelegateId = " + DelegationData + " where(ticket.Submiter = " + delegation.FromUser + ") and (ticket.Status != 3 and ticket.Status != 5) and (ticket.DelegateId = 0 ) and (ticket.NextCommenter != ticket.Submiter)"); db.Database.ExecuteSqlCommand("update ticketparcipant set ticketparcipant.userid = " + delegation.ToUser + " where (ticketparcipant.userid = " + delegation.FromUser + ")"); } }
public Delegation EditDelegation(Delegation delegation, int id, int currentuser) { using (TsicsContext db = new TsicsContext()) { db.Database.ExecuteSqlCommand("UPDATE UserTsics set IsDelegate = " + id + " where UserId = " + delegation.FromUser); db.Database.ExecuteSqlCommand("update ticket set ticket.Responder = " + delegation.ToUser + ", ticket.NextCommenter = " + delegation.ToUser + " where (ticket.Responder = " + currentuser + ") and (ticket.Status != 3 and ticket.Status != 5) and (ticket.DelegateId = " + id + " ) and (ticket.Responder = Ticket.NextCommenter)"); db.Database.ExecuteSqlCommand("update ticket set ticket.Responder = " + delegation.ToUser + " where (ticket.Responder = " + currentuser + ") and (ticket.Status != 3 and ticket.Status != 5) and (ticket.DelegateId = " + id + " ) and (ticket.Responder != Ticket.NextCommenter)"); db.Database.ExecuteSqlCommand("update ticket set ticket.Submiter = " + delegation.ToUser + ", ticket.NextCommenter = " + delegation.ToUser + " where (ticket.Submiter = " + currentuser + ") and (ticket.Status != 3 and ticket.Status != 5) and (ticket.DelegateId = " + id + " ) and (ticket.Submiter = Ticket.NextCommenter)"); db.Database.ExecuteSqlCommand("update ticket set ticket.Submiter = " + delegation.ToUser + " where (ticket.Submiter = " + currentuser + ") and (ticket.Status != 3 and ticket.Status != 5) and (ticket.DelegateId = " + id + " ) and (ticket.Submiter != Ticket.NextCommenter)"); db.Database.ExecuteSqlCommand("update ticketparcipant set ticketparcipant.userid = " + delegation.ToUser + " where (ticketparcipant.userid = " + currentuser + ")"); } _dBtsics.Entry(delegation).State = EntityState.Modified; _dBtsics.SaveChanges(); return(delegation); }
// POST: api/MobileLogin public IHttpActionResult Post(MobileLogin plainTextLoginData) { if (!Common.GetAuthorization(Request)) { return(Ok(new { Code = 401, Message = "Unauthorization" })); } using (TsicsContext db = new TsicsContext()) { db.Database.ExecuteSqlCommand("delete from UserDevices where PlayerId = '' or PlayerId = null"); } //Check User Login UserBusinessService userBs = Factory.Create <UserBusinessService>("User", ClassType.clsTypeBusinessService); MobileLogin loginData = new MobileLogin { Xupj = plainTextLoginData.Xupj, Password = Common.Base64Encode(plainTextLoginData.Password) }; User userM = userBs.CheckLoginMobile(loginData); if (userM != null) { var usrd = new UserDevices { UserId = userM.UserId, PlayerId = plainTextLoginData.PlayerId }; userM.MobileToken = Common.AccessToken() + userM.UserId; userM.PlayerId = plainTextLoginData.PlayerId; userBs.Edit(userM); if (usrd.PlayerId != null) { userBs.InsertData(usrd); } if (!string.IsNullOrWhiteSpace(userM.PhotoProfile)) { userM.PhotoProfile = WebConfigure.GetDomain() + "/Upload/UserProfile/" + userM.PhotoProfile; } else { userM.PhotoProfile = WebConfigure.GetDomain() + "/assets/images/repository/avatar-default.jpg"; } UserAPI userData = new UserAPI() { UserId = userM.UserId, Name = userM.Name, EmployeeId = userM.EmployeeId, AreaName = string.IsNullOrWhiteSpace(userM.AreaName) ? "HEAD OFFICE" : userM.AreaName, BranchName = string.IsNullOrWhiteSpace(userM.BranchName) ? "" : userM.BranchName, CreatedAt = userM.CreatedAt, AreaCode = userM.AreaCode, BranchCode = userM.BranchCode, MasterAreaId = userM.MasterAreaId, MasterBranchId = userM.MasterBranchId, Email = userM.Email, RoleId = userM.RoleId, RoleDescription = userM.RoleDescription, RoleName = userM.RoleId == 0 || _UserRoleBusinessService.GetDetail(userM.RoleId) == null ? "GUEST" : _UserRoleBusinessService.GetDetail(userM.RoleId).Name, Dob = userM.Dob, IsDelegate = userM.IsDelegate, MobileToken = userM.MobileToken, PhotoProfile = userM.PhotoProfile, POH_Name = userM.POH_Name, Status = userM.Status, MobilePassword = userM.MobilePassword, Position = userM.Position, Phone = userM.Phone, PlayerId = userM.PlayerId, Username = userM.Username, TechnicalJobExperienceDuration = userM.TechnicalJobExperienceDuration, TechnicalJobTitle = userM.TechnicalJobTitle, }; Delegation userD = userBs.GetDetailDelegationByUserFrom(userM.UserId); if (userD != null) { DelegationAPI delegationAPI = new DelegationAPI() { DelegateId = userD.DelegateId, StartDate = userD.StartDate.Value.ToString("dddd, dd MMMM yyyy"), EndDate = userD.EndDate.Value.ToString("dddd, dd MMMM yyyy"), ToUser = userBs.GetDetail(userD.ToUser), Status = userD.Status, CreatedAt = userD.CreatedAt.Value.ToString("dddd, dd MMMM yyyy") }; return(Ok(new { Code = 200, Authorization = "true", Data = userData, delegation = delegationAPI })); } else { DelegationAPI delegationAPI = new DelegationAPI() { DelegateId = 0, StartDate = null, EndDate = null, FromUser = null, ToUser = null, Status = 0, CreatedAt = null }; return(Ok(new { Code = 200, Authorization = "true", Data = userData, delegation = delegationAPI })); } } else { return(Ok(new { Code = 401, Authorization = "false", Message = "Gagal Login" })); } }