//public Req_Opt_Junc GetReq_Opt_JuncDetails(int req_opt_ID)
//{
// Req_Opt_Junc req_opt_junc = null;
// SqlParameter[] parameters = new SqlParameter[]
// {
// new SqlParameter("@ID", req_opt_ID)
// };
// using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("[Resource_Control].[sp_Req_Opt_JuncSelect]", CommandType.StoredProcedure, parameters))
// {
// if (table.Rows.Count == 1)
// {
// DataRow row = table.Rows[0];
// req_opt_junc = new Req_Opt_Junc();
// req_opt_junc.ID = Convert.ToInt32(row["ID"]);
// req_opt_junc.Req_id = Convert.ToInt32(row["Req_id"]);
// req_opt_junc.Opt_id = Convert.ToInt32(row["Opt_id"]);
// }
// }
// return req_opt_junc;
//}
//public List<Req_Opt_Junc> GetReq_Opt_JuncList()
//{
// List<Req_Opt_Junc> req_opt_junclist = null;
// using (DataTable table = SqlDBHelper.ExecuteSelectCommand("sp_Req_Opt_JuncsSelectAll", CommandType.StoredProcedure))
// {
// if (table.Rows.Count > 0)
// {
// req_opt_junclist = new List<Req_Opt_Junc>();
// foreach (DataRow row in table.Rows)
// {
// Req_Opt_Junc req_opt_junc = new Req_Opt_Junc();
// req_opt_junc.ID = Convert.ToInt32(row["ID"]);
// req_opt_junc.Req_id = Convert.ToInt32(row["Req_id"]);
// req_opt_junc.Opt_id = Convert.ToInt32(row["Opt_id"]);
// req_opt_junclist.Add(req_opt_junc);
// }
// }
// }
// return req_opt_junclist;
//}
public List <Req_Opt_Junc> GetReq_Opt_JuncListByReqID(int reqID)
{
List <Req_Opt_Junc> req_opt_junclist = null;
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ReqID", reqID)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("[Resource_Control].[sp_req_opt_juncSelectByReqID]", CommandType.StoredProcedure, parameters))
{
if (table.Rows.Count > 0)
{
req_opt_junclist = new List <Req_Opt_Junc>();
foreach (DataRow row in table.Rows)
{
Req_Opt_Junc req_opt_junc = new Req_Opt_Junc();
req_opt_junc.ID = Convert.ToInt32(row["ID"]);
req_opt_junc.Req_id = Convert.ToInt32(row["Req_id"]);
req_opt_junc.Opt_id = Convert.ToInt32(row["Opt_id"]);
req_opt_junc.IsActive = Convert.ToBoolean(row["IsActive"]);
req_opt_junclist.Add(req_opt_junc);
}
}
}
return(req_opt_junclist);
}
public bool AddNewReq_Opt_Junc(Req_Opt_Junc req_opt_junc)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@Req_id", req_opt_junc.Req_id),
new SqlParameter("@Opt_id", req_opt_junc.Opt_id)
};
return(SqlDBHelper.ExecuteNonQuery("[Resource_Control].[sp_req_opt_juncInsert]", CommandType.StoredProcedure, parameters));;
}
public bool UpdateReq_Opt_Junc(Req_Opt_Junc req_opt_junc)
{
SqlParameter[] parameters = new SqlParameter[]
{
//new SqlParameter("@ID",req_opt_junc.ID),
new SqlParameter("@Req_id", req_opt_junc.Req_id),
new SqlParameter("@Opt_id", req_opt_junc.Opt_id),
new SqlParameter("@IsActive", req_opt_junc.IsActive)
};
return(SqlDBHelper.ExecuteNonQuery("[Resource_Control].[sp_req_opt_juncUpdate]", CommandType.StoredProcedure, parameters));
}
public bool AddNewReq_Opt_Junc(Req_Opt_Junc req_opt_junc)
{
return(Req_Opt_JuncDB.AddNewReq_Opt_Junc(req_opt_junc));
}
public bool UpdateReq_Opt_Junc(Req_Opt_Junc req_opt_junc)
{
return(Req_Opt_JuncDB.UpdateReq_Opt_Junc(req_opt_junc));
}
