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" }));
}
}
