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