public DataSet ModifyTicket(JsonMember.VisiterManagement obj)
{
try
{
Sqldbmanager.Open();
Sqldbmanager.CreateParameters(13);
Sqldbmanager.AddParameters(0, "@VisiterId", obj.VisiterId);
Sqldbmanager.AddParameters(1, "@VisiterName", obj.VisiterName);
Sqldbmanager.AddParameters(2, "@GenderId", obj.GenderId);
Sqldbmanager.AddParameters(3, "@VisiterAge", obj.VisiterAge);
Sqldbmanager.AddParameters(4, "@VisiterPassportNo", obj.VisiterPassportNo);
Sqldbmanager.AddParameters(5, "@VisiterAddress", obj.VisiterAddress);
Sqldbmanager.AddParameters(6, "@CountryId", obj.CountryId);
Sqldbmanager.AddParameters(7, "@CurrencyId", obj.CurrencyId);
Sqldbmanager.AddParameters(8, "@TicketAmount", obj.TicketAmount);
Sqldbmanager.AddParameters(9, "@TicketCount", obj.TicketCount);
Sqldbmanager.AddParameters(10, "@SloatId", obj.SloatId);
Sqldbmanager.AddParameters(11, "@UserId", obj.UserId);
Sqldbmanager.AddParameters(12, "@Remark", obj.Remark);
DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_ModifyTicket");
}
catch (Exception Ex)
{
DS = LogError("Modify Ticket", Ex.Message.ToString(), "SP Name: USP_ModifyTicket");
}
finally
{
Sqldbmanager.Close();
}
return(DS);
}
public DataSet GetSlotByEntryData(JsonMember.VisiterManagement obj)
{
try
{
Sqldbmanager.Open();
Sqldbmanager.CreateParameters(1);
Sqldbmanager.AddParameters(0, "@VisitDate", obj.VisitDate);
DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_ManageSlotByEntryDate");
}
catch (Exception Ex)
{
DS = LogError("Get SlotBy Entry Data", Ex.Message.ToString(), "SP Name: USP_ManageSlotByEntryDate");
}
finally
{
Sqldbmanager.Close();
}
return(DS);
}
public DataSet CancelTicket(JsonMember.VisiterManagement obj)
{
try
{
Sqldbmanager.Open();
Sqldbmanager.CreateParameters(5);
Sqldbmanager.AddParameters(0, "@VisiterId", obj.VisiterId);
Sqldbmanager.AddParameters(1, "@CancelCharge", obj.TicketAmount);
Sqldbmanager.AddParameters(2, "@ReturnCount", obj.TicketCount);
Sqldbmanager.AddParameters(3, "@UserId", obj.UserId);
Sqldbmanager.AddParameters(4, "@CancelReason", obj.Remark);
DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_CancelTicket");
}
catch (Exception Ex)
{
DS = LogError("Cancel Ticket", Ex.Message.ToString(), "SP Name: USP_CancelTicket");
}
finally
{
Sqldbmanager.Close();
}
return(DS);
}
