public DataTable InsertDocumentApprovalLevel(PL_DocumentApprovalLevel pl)
{
DataTable dt = new DataTable();
// int i=0;
try
{
cmd = new SqlCommand("SpMenus", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@ParentMenuId", pl.ParentMenuId);
cmd.Parameters.AddWithValue("@Title", "ApprovalMenus");
cmd.Parameters.AddWithValue("@Url", "Home.aspx");
cmd.Parameters.AddWithValue("@LevelProfile", pl.LevelProfile);
cmd.Parameters.AddWithValue("@AllowMenu", pl.AllowMenu);
con.Open();
SqlDataAdapter ad = new SqlDataAdapter(cmd);
ad.Fill(dt);
// cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception ex) { msg = ex.Message; }
return(dt);
}
public DataTable ApprovalDelete(PL_DocumentApprovalLevel ObjPlUserProfile)
{
//ObjPlProfile.UserTypeId = UserTypeID;
// ObjPldocumentApproval.Ind = Ind;
// ObjPldocumentApproval.ItemId = ItemId;
DataTable dt = new DataTable();
// SqlDataAdapter da = new SqlDataAdapter();
dt = ObjDldocumentApproval.ApprovalDelete(ObjPlUserProfile);
return(dt);
}
public DataTable InsertDocumentApprovalLevel(PL_DocumentApprovalLevel pl)
{
//ObjPlProfile.UserTypeId = UserTypeID;
//ObjPlProfile.Ind = Ind;
//ObjPlProfile.ItemId = ItemId;
DataTable dt = new DataTable();
// SqlDataAdapter da = new SqlDataAdapter();
dt = ObjDldocumentApproval.InsertDocumentApprovalLevel(pl);
return(dt);
}
public DataTable GetUserLevel(PL_DocumentApprovalLevel pl)
{
cmd = new SqlCommand("SpGetAllMaster", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ind", pl.Ind);
dt = new DataTable();
da = new SqlDataAdapter(cmd);
da.Fill(dt);
if (dt.Rows.Count > 0 && dt != null)
{
}
else
{
dt = null;
}
return(dt);
}
public DataTable ApprovalDelete(PL_DocumentApprovalLevel pl)
{
DataTable dt = new DataTable();
// int i=0;
try
{
cmd = new SqlCommand("SPMenus", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@AllowMenu", pl.AllowMenu);
con.Open();
SqlDataAdapter ad = new SqlDataAdapter(cmd);
ad.Fill(dt);
// cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception ex) { msg = ex.Message; }
return(dt);
}