public IEnumerable <Issuestbl> IssuesAll(int type, Issuestbl iss)
{
List <Issuestbl> objIssues = new List <Issuestbl>();
try
{
MySqlCommand cmd = new MySqlCommand("Sp_Issues", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("ptype", type);
cmd.Parameters.AddWithValue("pIssuesID", iss.IssuesID);
cmd.Parameters.AddWithValue("pBookingID", iss.BookingID);
cmd.Parameters.AddWithValue("pIssue", iss.Issue);
cmd.Parameters.AddWithValue("pStatus", iss.Status);
cmd.Parameters.AddWithValue("pPriority", iss.Priority);
cmd.Parameters.AddWithValue("pAssignToEmployee", iss.AssignToEmployee);
cmd.Parameters.AddWithValue("pNote", iss.Note);
cmd.Parameters.AddWithValue("pIsActive", iss.IsActive);
cmd.Parameters.AddWithValue("pCreatedBy", iss.CreatedBy);
cmd.Parameters.AddWithValue("pCreatedDate", iss.CreatedDate);
cmd.Parameters.AddWithValue("pUpdatedBy", iss.UpdatedBy);
cmd.Parameters.AddWithValue("pUpdatedDate", iss.UpdatedDate);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
MySqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
objIssues.Add(new Issuestbl
{
IssuesID = Convert.ToInt32(dr["IssuesID"]),
BookingID = string.IsNullOrEmpty(dr["BookingID"].ToString()) ? 0 : Convert.ToInt32(dr["BookingID"]),
Issue = dr["Issue"].ToString(),
Status = Convert.ToInt32(dr["Status"]),
Priority = Convert.ToInt32(dr["Priority"]),
AssignToEmployee = dr["AssignToEmployee"].ToString(),
Note = dr["Note"].ToString(),
IsActive = Convert.ToInt32(dr["IsActive"]),
CreatedBy = string.IsNullOrEmpty(dr["CreatedBy"].ToString()) ? 0:Convert.ToInt32(dr["CreatedBy"]),
CreatedDate = dr["CreatedDate"].ToString(),
UpdatedBy = string.IsNullOrEmpty(dr["UpdatedBy"].ToString()) ? 0 : Convert.ToInt32(dr["UpdatedBy"]),
UpdatedDate = dr["UpdatedDate"].ToString(),
Message = "Success",
});
}
}
catch (Exception ex)
{
objIssues.Add(new Issuestbl
{
Message = "Error",
ErrorMessage = ex.Message
});
}
finally
{
con.Close();
}
return(objIssues);
}
