// GET: ApplicationTypes
        public Object OnlinePackagePost([FromBody] OnlinePackagePost OnlinePackage)
        {
            string             sJSONResponse  = "";
            DataTable          dt_AppType     = new DataTable();
            string             ServerDateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture);
            int                a = 0;
            string             olPackage_Query = "";
            PaymentDetailsPost Pdetails        = new PaymentDetailsPost();

            try
            {
                cnn.Open();
                olPackage_Query = "insert into OnlinePackages(BranchCode,EnquireTypeNo,PackageID,PackageName,PackageCost,DiscountPercentage,NumberOfSession,NumberOfDaysValidity,Description,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + OnlinePackage.branchCode + "','" + OnlinePackage.enquireTypeNo + "','" + OnlinePackage.packageId + "','" + OnlinePackage.packageName + "','" + OnlinePackage.packageCost + "','" + OnlinePackage.discountPercentage + "','" + OnlinePackage.noOFSessions + "','" + OnlinePackage.nooOfDateValidity + "','" + OnlinePackage.description + "','','" + ServerDateTime + "',0,1) SELECT @@IDENTITY;";
                SqlCommand tm_cmd = new SqlCommand(olPackage_Query, cnn);
                a = Convert.ToInt32(tm_cmd.ExecuteScalar());
                Pdetails.status        = "Success";
                Pdetails.transactionId = a;
            }
            catch (Exception ex)
            {
                Pdetails.status = "Fail";
            }
            finally
            {
                cnn.Close();
            }

            sJSONResponse = JsonConvert.SerializeObject(Pdetails);

            return(sJSONResponse);
        }
        public Object GetOnlinePackage([FromBody] OnlinePackagePost OnlinePackage)
        {
            OnlinePackageOutput daOP          = new OnlinePackageOutput();
            DataSet             SelectedSlots = new DataSet();
            string sJSONResponse = "";

            DataTable dt_Sessions = new DataTable();

            List <OnlinePackageResponse> dalots = new List <OnlinePackageResponse>();

            try
            {
                dt_Sessions = getdata(string.Format("Select ID,EnquireTypeNo,PackageID,PackageName,PackageCost,DiscountPercentage,NumberOfSession,NumberOfDaysValidity,Description,BranchCode from OnlinePackages where BranchCode='{0}'", OnlinePackage.branchCode));

                for (int i = 0; i < dt_Sessions.Rows.Count; i++)
                {
                    OnlinePackageResponse SlotsDetails = new OnlinePackageResponse {
                        id = dt_Sessions.Rows[i]["ID"].ToString(), enquireTypeNo = dt_Sessions.Rows[i]["EnquireTypeNo"].ToString(), packageId = dt_Sessions.Rows[i]["PackageID"].ToString(), packageName = dt_Sessions.Rows[i]["PackageName"].ToString(), packageCost = dt_Sessions.Rows[i]["PackageCost"].ToString(), discountPercentage = dt_Sessions.Rows[i]["DiscountPercentage"].ToString(), noOfSessions = dt_Sessions.Rows[i]["NumberOfSession"].ToString(), nooOfDateValidity = dt_Sessions.Rows[i]["NumberOfDaysValidity"].ToString(), description = dt_Sessions.Rows[i]["Description"].ToString(), branchCode = dt_Sessions.Rows[i]["BranchCode"].ToString()
                    };
                    dalots.Add(SlotsDetails);
                }

                daOP.status   = "success";
                daOP.value    = dalots;
                sJSONResponse = JsonConvert.SerializeObject(daOP);
            }
            catch (Exception ec)
            {
                daOP.status   = "fail";
                sJSONResponse = JsonConvert.SerializeObject(daOP);
            }


            return(sJSONResponse);
        }
        public Object OnlinePackageDelete([FromBody] OnlinePackagePost OnlinePackage)
        {
            SqlCommand command        = cnn.CreateCommand();
            string     ServerDateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture);

            try
            {
                cnn.Close();
                cnn.Open();
                SqlTransaction transaction;
                transaction         = cnn.BeginTransaction("SampleTransaction");
                command.Connection  = cnn;
                command.Transaction = transaction;
                try
                {
                    command.CommandText = "update OnlinePackages set PackageName='" + OnlinePackage.packageName + "',PackageCost='" + OnlinePackage.packageCost + "',DiscountPercentage='" + OnlinePackage.discountPercentage + "',NumberOfSession='" + OnlinePackage.noOFSessions + "',NumberOfDaysValidity='" + OnlinePackage.nooOfDateValidity + "' where ID=" + OnlinePackage.Id + " ";
                    command.ExecuteNonQuery();

                    transaction.Commit();
                }
                catch (Exception ex)
                {
                    transaction.Rollback();
                }
                finally
                {
                }
            }
            catch (Exception ec)
            {
            }

            string sJSONResponse = "";

            return(sJSONResponse);
        }