// RaiseTicket :
// FunctoionName : GetMembersTickets || Table :
//
public Object GetMembersTickets([FromBody] BookingDetailsInput bdi)
{
MembersOpt mo = new MembersOpt();
DataSet SelectedSlots = new DataSet();
string sJSONResponse = "";
DataTable dt_MembersTickets = new DataTable();
List <MembersTicketDetails> bdetails = new List <MembersTicketDetails>();
try
{
dt_MembersTickets = getdata(string.Format("select TIT.ID,TT.RequestType as RequestName,TB.CreatedOn as RaisedOn,TIT.CreatedOn as CloserDated,TIT.PostPoneDate as NextUpdate,TIT.StatusId,TIT.StatusName,TIT.Comments from TicketTypes TT,TicketBooking TB,TicketTransaction TIT where TT.ID=TB.RequestTypeId and TB.TicketId=TIT.TicketId and TB.InvoiceId='{0}'", bdi.InvoiceId));
for (int i = 0; i < dt_MembersTickets.Rows.Count; i++)
{
MembersTicketDetails fd = new MembersTicketDetails {
Id = dt_MembersTickets.Rows[i]["ID"].ToString(), RequestName = dt_MembersTickets.Rows[i]["RequestName"].ToString(), StatusId = dt_MembersTickets.Rows[i]["StatusId"].ToString(), StatusName = dt_MembersTickets.Rows[i]["StatusName"].ToString(), CloserDated = Convert.ToDateTime(dt_MembersTickets.Rows[i]["CloserDated"].ToString()), RaisedOn = Convert.ToDateTime(dt_MembersTickets.Rows[i]["RaisedOn"].ToString()), NextUpdate = Convert.ToDateTime(dt_MembersTickets.Rows[i]["NextUpdate"].ToString()), Comments = dt_MembersTickets.Rows[i]["Comments"].ToString()
};
bdetails.Add(fd);
}
mo.status = "success";
mo.value = bdetails;
sJSONResponse = JsonConvert.SerializeObject(mo);
}
catch (Exception ec)
{
mo.status = "fail";
sJSONResponse = JsonConvert.SerializeObject(mo);
}
return(sJSONResponse);
}
public Object GetClosedTickets([FromBody] BookingDetailsInput bdi)
{
OpenTicketOpts mo = new OpenTicketOpts();
DataSet SelectedSlots = new DataSet();
string sJSONResponse = "";
DataTable dt_MembersTickets = new DataTable();
List <OpenTickets> bdetails = new List <OpenTickets>();
try
{
dt_MembersTickets = getdata(string.Format("select TT.MemberShipCode,TT.TicketId,TT.RequestTypeId,TTP.RequestType,TT.Comments,TT.PostPoneDate,TT.InvoiceId,TT.CreatedBy,TT.CreatedOn,TT.StatusId from TicketTransaction TT,TicketTypes TTP where TT.ID=TTP.ID and BranchCode='{0}' and StatusId=2", bdi.BranchCode));
for (int i = 0; i < dt_MembersTickets.Rows.Count; i++)
{
OpenTickets fd = new OpenTickets {
memberShipCode = dt_MembersTickets.Rows[0]["MemberShipCode"].ToString(), TicketId = Convert.ToInt32(dt_MembersTickets.Rows[0]["TicketId"].ToString()), RequestTypeId = Convert.ToInt32(dt_MembersTickets.Rows[0]["RequestTypeId"].ToString()), RequestType = dt_MembersTickets.Rows[0]["RequestType"].ToString(), Comments = dt_MembersTickets.Rows[0]["Comments"].ToString(), PostPoneDate = dt_MembersTickets.Rows[0]["PostPoneDate"].ToString(), InvoiceId = dt_MembersTickets.Rows[0]["InvoiceId"].ToString(), CreatedBy = dt_MembersTickets.Rows[0]["CreatedBy"].ToString(), CreatedOn = Convert.ToDateTime(dt_MembersTickets.Rows[0]["CreatedOn"].ToString()), StatusId = Convert.ToInt32(dt_MembersTickets.Rows[0]["StatusId"].ToString())
};
bdetails.Add(fd);
}
mo.status = "success";
mo.value = bdetails;
sJSONResponse = JsonConvert.SerializeObject(mo);
}
catch (Exception ec)
{
mo.status = "fail";
sJSONResponse = JsonConvert.SerializeObject(mo);
}
return(sJSONResponse);
}
//FunName : GetBookingDetails
//Mode : Offline || Offline = Request : MoboleNo || Table : CCRMMembership || Reponse : PackageName , StartDate , InvoiceId
//Mode : Online || Online = Request : MobileNo || Table : OnlinePackagePurchase || Reponse : PackageName , StartDate , InvoiceId
public Object GetBookingDetails([FromBody] BookingDetailsInput bdi)
{
BookingDetailsOpt bdo = new BookingDetailsOpt();
DataSet SelectedSlots = new DataSet();
string sJSONResponse = "";
DataTable dt_BookingDetails = new DataTable();
List <BookingDetails> bdetails = new List <BookingDetails>();
try
{
if (bdi.Mode == "OffLine")
{
dt_BookingDetails = getdata(string.Format("select InvoiceID,CCRMM.PackageCode,CMSP.PackageName,StartDate,CCRMM.BranchCode,B.BranchName from CCRMMembership CCRMM,Users U,CMSPACKAGES CMSP,Branch B where CMSP.PackageCode=CCRMM.PackageCode and B.BranchCode=CCRMM.BranchCode and CCRMM.MembershipCode=U.UCode and U.MobileNo='{0}' ", bdi.MobileNo));
}
else if (bdi.Mode == "OnLine")
{
dt_BookingDetails = getdata(string.Format("select Invoice as InvoiceID,OPP.PackageID as PackageCode,OP.PackageName,OPP.BranchCode,BranchName='Online', StartDate from OnlinePackagePurchase OPP,OnlinePackages OP where OPP.PackageID=OP.PackageID and OPP.MobileNo='{0}'", bdi.MobileNo));
}
else
{
}
for (int i = 0; i < dt_BookingDetails.Rows.Count; i++)
{
BookingDetails fd = new BookingDetails {
InvoiceId = dt_BookingDetails.Rows[i]["InvoiceID"].ToString(), PackageCode = dt_BookingDetails.Rows[i]["PackageCode"].ToString(), PackageName = dt_BookingDetails.Rows[i]["PackageName"].ToString(), BranchName = dt_BookingDetails.Rows[i]["BranchName"].ToString(), StartDate = Convert.ToDateTime(dt_BookingDetails.Rows[i]["StartDate"].ToString()), BranchCode = dt_BookingDetails.Rows[i]["BranchCode"].ToString(),
};
bdetails.Add(fd);
}
bdo.status = "success";
bdo.value = bdetails;
sJSONResponse = JsonConvert.SerializeObject(bdo);
}
catch (Exception ec)
{
bdo.status = "fail";
sJSONResponse = JsonConvert.SerializeObject(bdo);
}
return(sJSONResponse);
}
