public void UpdateTrainTypeTask(TrainTypeTask obj) { Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_TRAIN_TYPE_TASK_U"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_train_type_id", DbType.Int32, obj.TrainTypeID); db.AddInParameter(dbCommand, "p_paper_id", DbType.Int32, obj.PaperID); db.ExecuteNonQuery(dbCommand); }
protected void btnDel_Click(object sender, EventArgs e) { TrainTypeTaskBLL objBll = new TrainTypeTaskBLL(); GridItemCollection activeItems = Grid2.GetCheckedItems(Grid2.Levels[0].Columns[0]); foreach (GridItem activeItem in activeItems) { TrainTypeTask obj = new TrainTypeTask(); obj.TrainTypeID = Convert.ToInt32(ViewState["TrainTypeID"].ToString()); obj.PaperID = Convert.ToInt32(activeItem[1]); objBll.DelTrainTypeTask(obj.TrainTypeID, obj.PaperID); } BindGrid(); BindGridSelect(); }
protected void btnAdd_Click(object sender, EventArgs e) { TrainTypeTaskBLL objBll = new TrainTypeTaskBLL(); ArrayList objList = GetPaperList(); GridItemCollection activeItems = Grid1.GetCheckedItems(Grid1.Levels[0].Columns[0]); foreach (GridItem activeItem in activeItems) { if (objList.IndexOf(activeItem[1]) == -1) { TrainTypeTask obj = new TrainTypeTask(); obj.TrainTypeID = Convert.ToInt32(ViewState["TrainTypeID"].ToString()); obj.PaperID = Convert.ToInt32(activeItem[1]); objBll.AddTrainTypeTask(obj); } } BindGrid(); BindGridSelect(); }
public IList <TrainTypeTask> GetTrainTypeTaskByTrainTypeID(int trainTypeID) { IList <TrainTypeTask> objList = new List <TrainTypeTask>(); Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_TRAIN_TYPE_TASK_G"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_train_type_id", DbType.Int32, trainTypeID); db.AddInParameter(dbCommand, "p_paper_id", DbType.Int32, 0); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { TrainTypeTask obj = CreateModelObject(dataReader); objList.Add(obj); } } return(objList); }
public void UpdateTrainTypeTask(TrainTypeTask trainTypeTask) { dal.UpdateTrainTypeTask(trainTypeTask); }
public void AddTrainTypeTask(TrainTypeTask trainTypeTask) { dal.AddTrainTypeTask(trainTypeTask); }