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