// GET: ApplicationTypes
public Object SlotsCapacityPost([FromBody] SlotAllocationInput sai)
{
string sJSONResponse = "";
DataTable dt_AppType = new DataTable();
string ServerDateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture);
string a = "";
string olPackage_Query = "insert into CMSSlotWiseAllocation(TrainerCode,PackageCode,SlotCode,AllocatedCount,FreeTrialAllocatedCount,BranchCode,Duration,MinPrice,MaxPrice,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + sai.TrainerCode + "','" + sai.PackageCode + "','" + sai.SlotCode + "','" + sai.AllocatedCount + "','" + sai.FreeTrialAllocatedCount + "','" + sai.BranchCode + "','" + sai.Duration + "','" + sai.MinPrice + "','" + sai.MaxPrice + "','" + sai.CreatedBy + "','" + ServerDateTime + "',0,1)";
SlotAllocationOutput sapost = new SlotAllocationOutput();
try
{
cnn.Open();
SqlCommand tm_cmd = new SqlCommand(olPackage_Query, cnn);
tm_cmd.ExecuteNonQuery();
sapost.status = "Success";
sapost.value = a;
}
catch (Exception ex)
{
sapost.status = "fail";
}
finally
{
cnn.Close();
}
sJSONResponse = JsonConvert.SerializeObject(sapost);
return(sJSONResponse);
}
public Object SlotsCapacityDelete([FromBody] SlotAllocationInput sai)
{
string sJSONResponse = "";
SlotAllocationOutput sapost = new SlotAllocationOutput();
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 = "delete from CMSSlotWiseAllocation where ID='" + sai.ID + "' ";
command.ExecuteNonQuery();
transaction.Commit();
sapost.status = "Success";
}
catch (Exception ex)
{
transaction.Rollback();
}
finally
{
}
}
catch (Exception ec)
{
sapost.status = "fail";
}
sJSONResponse = JsonConvert.SerializeObject(sapost);
return(sJSONResponse);
}
public Object SlotsCapacityUpdate([FromBody] SlotAllocationInput sai)
{
string sJSONResponse = "";
SlotAllocationOutput sapost = new SlotAllocationOutput();
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 CMSSlotWiseAllocation set TrainerCode='" + sai.TrainerCode + "',PackageCode='" + sai.PackageCode + "',SlotCode='" + sai.SlotCode + "',AllocatedCount='" + sai.AllocatedCount + "',FreeTrialAllocatedCount='" + sai.FreeTrialAllocatedCount + "',Duration='" + sai.Duration + "',MinPrice='" + sai.MinPrice + "',MaxPrice='" + sai.MaxPrice + "' where ID='" + sai.ID + "' ";
command.ExecuteNonQuery();
transaction.Commit();
sapost.status = "Success";
}
catch (Exception ex)
{
transaction.Rollback();
}
finally
{
}
}
catch (Exception ec)
{
sapost.status = "fail";
}
sJSONResponse = JsonConvert.SerializeObject(sapost);
return(sJSONResponse);
}