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