// GET: ApplicationTypes public Object OnlineTrainersSlotMappingPost([FromBody] OnlineTrainersSlotMapping mts) { 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 OnlineTrainersSlotMapping(BranchCode,TrainerCode,TrainerName,SessionCode,SessionName,SlotCode,SlotName,PackageCode,PackageName,Description,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + mts.branchCode + "','" + mts.trainerCode + "','" + mts.trainerName + "','" + mts.sessionCode + "','" + mts.sessionName + "','" + mts.slotCode + "','" + mts.slotName + "','" + mts.packageCode + "','" + mts.packageName + "','" + mts.description + "','" + mts.createdBy + "','" + 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 GetOnlineTrainersSlotMapping([FromBody] OnlineTrainersSlotMapping mts) { OnlineTrainersSlotMappingOutput daOP = new OnlineTrainersSlotMappingOutput(); DataSet SelectedSlots = new DataSet(); string sJSONResponse = ""; DataTable dt_Sessions = new DataTable(); List <OnlineTrainersSlotMappingResponse> dalots = new List <OnlineTrainersSlotMappingResponse>(); try { dt_Sessions = getdata(string.Format("select OTSM.ID,OTSM.PackageCode,OTSM.PackageName,OTSM.SessionCode,OTSM.SessionName,OTSM.SlotCode,OTSM.SlotName,OTSM.IsActive,OTSM.FreeTrialIsActive,OTSM.Description from OnlineTrainersSlotMapping OTSM where OTSM.IsDeleted=0 and OTSM.BranchCode='{0}' and OTSM.TrainerCode='{1}' and OTSM.SessionCode='{2}' ", mts.branchCode, mts.trainerCode, mts.sessionCode)); for (int i = 0; i < dt_Sessions.Rows.Count; i++) { OnlineTrainersSlotMappingResponse SlotsDetails = new OnlineTrainersSlotMappingResponse { id = Convert.ToInt32(dt_Sessions.Rows[i]["ID"].ToString()), packageCode = dt_Sessions.Rows[i]["PackageCode"].ToString(), packageName = dt_Sessions.Rows[i]["PackageName"].ToString(), sessionCode = dt_Sessions.Rows[i]["SessionCode"].ToString(), sessionName = dt_Sessions.Rows[i]["SessionName"].ToString(), slotCode = dt_Sessions.Rows[i]["SlotCode"].ToString(), slotName = dt_Sessions.Rows[i]["SlotName"].ToString(), isActive = Convert.ToBoolean(dt_Sessions.Rows[i]["IsActive"].ToString()), description = dt_Sessions.Rows[i]["Description"].ToString(), freeTrialIsActive = Convert.ToBoolean(dt_Sessions.Rows[i]["FreeTrialIsActive"].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 OnlineTrainersSlotMappingDelete([FromBody] OnlineTrainersSlotMapping mts) { 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 OnlineTrainersSlotMapping where Id='" + mts.Id + "' "; command.ExecuteNonQuery(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); } finally { } } catch (Exception ec) { } string sJSONResponse = ""; return(sJSONResponse); }
public Object OnlineTrainersSlotMappingUpdate([FromBody] OnlineTrainersSlotMapping mts) { 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 OnlineTrainersSlotMapping set TrainerCode='" + mts.trainerCode + "',TrainerName='" + mts.trainerName + "',SessionCode='" + mts.sessionCode + "',SessionName='" + mts.sessionName + "',SlotCode='" + mts.slotCode + "',SlotName='" + mts.slotName + "',PackageCode='" + mts.packageCode + "',PackageName='" + mts.packageName + "' where ID=" + mts.Id + " "; command.ExecuteNonQuery(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); } finally { } } catch (Exception ec) { } string sJSONResponse = ""; return(sJSONResponse); }