public ResponseModel GetChatTicketsOnSearch([FromBody] ChatTicketSearch searchModel)
{
List <CustomGetChatTickets> searchResultList = null;
ResponseModel objResponseModel = new ResponseModel();
int statusCode = 0;
string statusMessage = "";
HSChatTicketingCaller chatTicketingCaller = new HSChatTicketingCaller();
try
{
string token = Convert.ToString(Request.Headers["X-Authorized-Token"]);
Authenticate authenticate = new Authenticate();
authenticate = SecurityService.GetAuthenticateDataFromToken(_radisCacheServerAddress, SecurityService.DecryptStringAES(token));
searchModel.UserID = authenticate.UserMasterID;
searchModel.TenantID = authenticate.TenantId;
searchResultList = chatTicketingCaller.GetChatTicketsOnSearch(new HSChatTicketingService(_connectioSting), searchModel);
statusCode = searchResultList.Count.Equals(0) ? (int)EnumMaster.StatusCode.RecordNotFound : (int)EnumMaster.StatusCode.Success;
statusMessage = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)statusCode);
objResponseModel.Status = true;
objResponseModel.StatusCode = statusCode;
objResponseModel.Message = statusMessage;
objResponseModel.ResponseData = searchResultList.Count > 0 ? searchResultList : null;
}
catch (Exception)
{
throw;
}
return(objResponseModel);
}
/// <summary>
/// Get tickets On View Search click
/// </summary>
/// <param name="searchparams"></param>
/// <returns></returns>
public List <CustomGetChatTickets> GetChatTicketsOnSearch(IHSChatTicketing _hSChatTicketing, ChatTicketSearch searchModel)
{
hSChatTicketing = _hSChatTicketing;
return(hSChatTicketing.GetTicketsOnSearch(searchModel));
}
/// <summary>
/// Get tickets On View Search click
/// </summary>
/// <param name="searchparams"></param>
/// <returns></returns>
public List <CustomGetChatTickets> GetTicketsOnSearch(ChatTicketSearch searchModel)
{
DataSet ds = new DataSet();
MySqlCommand cmd = new MySqlCommand();
List <CustomGetChatTickets> lstGetChatTickets = new List <CustomGetChatTickets>();
List <string> countList = new List <string>();
try
{
conn.Open();
cmd.Connection = conn;
MySqlCommand sqlcmd = new MySqlCommand("SP_HSSearchChatTicket", conn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("Category_Id", searchModel.CategoryId);
sqlcmd.Parameters.AddWithValue("SubCategory_Id", searchModel.SubCategoryId);
sqlcmd.Parameters.AddWithValue("IssueType_Id", searchModel.IssueTypeId);
sqlcmd.Parameters.AddWithValue("TicketStatus_ID", searchModel.TicketStatusID);
sqlcmd.Parameters.AddWithValue("Tenant_ID", searchModel.TenantID);
sqlcmd.Parameters.AddWithValue("User_ID", searchModel.UserID);
MySqlDataAdapter da = new MySqlDataAdapter();
da.SelectCommand = sqlcmd;
da.Fill(ds);
if (ds != null && ds.Tables[0] != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
CustomGetChatTickets customGetChatTickets = new CustomGetChatTickets
{
TicketID = ds.Tables[0].Rows[i]["TicketID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["TicketID"]),
TicketStatus = ds.Tables[0].Rows[i]["StatusID"] == DBNull.Value ? string.Empty : Convert.ToString((EnumMaster.TicketStatus)Convert.ToInt32(ds.Tables[0].Rows[i]["StatusID"])),
TicketTitle = ds.Tables[0].Rows[i]["TicketTitle"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["TicketTitle"]),
TicketDescription = ds.Tables[0].Rows[i]["TicketDescription"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["TicketDescription"]),
Category = ds.Tables[0].Rows[i]["CategoryName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["CategoryName"]),
SubCategory = ds.Tables[0].Rows[i]["SubCategoryName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["SubCategoryName"]),
IssueType = ds.Tables[0].Rows[i]["IssueTypeName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["IssueTypeName"]),
AssignTo = ds.Tables[0].Rows[i]["Assignee"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["Assignee"]),
Priority = ds.Tables[0].Rows[i]["PriortyName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["PriortyName"]),
CreatedOn = ds.Tables[0].Rows[i]["CreationOn"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["CreationOn"]),
CreatedBy = ds.Tables[0].Rows[i]["CreatedBy"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["CreatedBy"]),
CreatedDate = ds.Tables[0].Rows[i]["CreationOn"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["CreationOn"]),
UpdatedBy = ds.Tables[0].Rows[i]["ModifyBy"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["ModifyBy"]),
UpdatedDate = ds.Tables[0].Rows[i]["ModifiedDate"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["ModifiedDate"]),
};
lstGetChatTickets.Add(customGetChatTickets);
}
}
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(lstGetChatTickets);
}
