public async Task <bool> Delete(SLAStatus SLAStatus) { if (await ValidateId(SLAStatus)) { } return(SLAStatus.IsValidated); }
public async Task <SLAStatus> Get(long Id) { SLAStatus SLAStatus = await UOW.SLAStatusRepository.Get(Id); if (SLAStatus == null) { return(null); } return(SLAStatus); }
public TicketReport_SLAStatusDTO(SLAStatus SLAStatus) { this.Id = SLAStatus.Id; this.Code = SLAStatus.Code; this.Name = SLAStatus.Name; this.ColorCode = SLAStatus.ColorCode; this.Errors = SLAStatus.Errors; }
public Customer_SLAStatusDTO(SLAStatus SLAStatus) { this.Id = SLAStatus.Id; this.Code = SLAStatus.Code; this.Name = SLAStatus.Name; this.ColorCode = SLAStatus.ColorCode; this.Errors = SLAStatus.Errors; }
/// <summary> /// Get status of SLA /// </summary> /// <param name="TenantID"></param> /// <returns></returns> public List <SLAStatus> GetSLAStatusList(int TenantID) { DataSet ds = new DataSet(); MySqlCommand cmd = new MySqlCommand(); List <SLAStatus> slas = new List <SLAStatus>(); try { conn.Open(); cmd.Connection = conn; MySqlCommand cmd1 = new MySqlCommand("SP_GetSLAStatusList", conn); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@Tenant_Id", TenantID); MySqlDataAdapter da = new MySqlDataAdapter(); da.SelectCommand = cmd1; da.Fill(ds); if (ds != null && ds.Tables[0] != null) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { SLAStatus sla = new SLAStatus(); sla.SLAId = Convert.ToInt32(ds.Tables[0].Rows[i]["SlaId"]); sla.SLATargetId = Convert.ToInt32(ds.Tables[0].Rows[i]["SLATargetId"]); sla.TenatID = Convert.ToInt32(ds.Tables[0].Rows[i]["TenantId"]); sla.SLARequestResponse = Convert.ToString(ds.Tables[0].Rows[i]["Respond"]) + "/" + Convert.ToString(ds.Tables[0].Rows[i]["Resolution"]); slas.Add(sla); } } } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } if (ds != null) { ds.Dispose(); } } return(slas); }
public async Task <SLAStatus> Get(long Id) { SLAStatus SLAStatus = await DataContext.SLAStatus.AsNoTracking() .Where(x => x.Id == Id) .Select(x => new SLAStatus() { Id = x.Id, Code = x.Code, Name = x.Name, ColorCode = x.ColorCode, }).FirstOrDefaultAsync(); if (SLAStatus == null) { return(null); } return(SLAStatus); }
public async Task <bool> ValidateId(SLAStatus SLAStatus) { SLAStatusFilter SLAStatusFilter = new SLAStatusFilter { Skip = 0, Take = 10, Id = new IdFilter { Equal = SLAStatus.Id }, Selects = SLAStatusSelect.Id }; int count = await UOW.SLAStatusRepository.Count(SLAStatusFilter); if (count == 0) { SLAStatus.AddError(nameof(SLAStatusValidator), nameof(SLAStatus.Id), ErrorCode.IdNotExisted); } return(count == 1); }
public async Task <bool> Create(SLAStatus SLAStatus) { return(SLAStatus.IsValidated); }