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); }