internal ChechInDetails checkIn(int ticket_id)
{
try
{
SqlCommand cmd = new SqlCommand("getChechInDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ticket_id", ticket_id);
con.Open();
ChechInDetails chechInDetails = new ChechInDetails();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow dRow in ds.Tables[0].Rows)
{
chechInDetails.status = true;
chechInDetails.check_in_log.type = dRow["type"] != DBNull.Value ? dRow["type"].ToString() : "";
chechInDetails.check_in_log.id = dRow["id"] != DBNull.Value ? Convert.ToInt32(dRow["id"].ToString()) : 0;
chechInDetails.check_in_log.date = dRow["date"] != DBNull.Value ? Convert.ToInt32(dRow["date"].ToString()) : 0;
}
}
return(chechInDetails);
}
catch (Exception ex)
{
throw;
}
finally
{
con.Close();
}
}
public string checkIn(int ticket_id)
{
try
{
ChechInDetails chechInDetails = new ChechInDetails();
chechInDetails = db.checkIn(ticket_id);
object response = new object();
if (chechInDetails == null)
{
response = new { Status = "false", Message = "This ticket is already checked in at 5:55 PM" };
}
else
{
response = new { Status = "true", Payment = chechInDetails };
}
return(JsonConvert.SerializeObject(response, Newtonsoft.Json.Formatting.Indented));
}
catch (Exception)
{
throw;
}
}
