示例#1
0
        public void Delete(ClsBllRemainderMaster ObjBll, int flag)
        {
            ConnectToDb();

            Cmd.Parameters.Clear();
            Cmd.Parameters.Add("@FLAG", SqlDbType.BigInt).Value        = flag;
            Cmd.Parameters.Add("@REMAINDERID", SqlDbType.BigInt).Value = ObjBll.RemainderId;

            Cmd.ExecuteNonQuery();
        }
示例#2
0
        public DataTable ReturnDT(ClsBllRemainderMaster ObjBll, int flag)
        {
            ConnectToDb();

            Cmd.Parameters.Clear();

            Cmd.Parameters.Add("@FLAG", SqlDbType.BigInt).Value = flag;

            Cmd.ExecuteNonQuery();

            SqlDataAdapter sda = new SqlDataAdapter(Cmd);
            DataTable      DT  = new DataTable();

            sda.Fill(DT);
            return(DT);
        }
示例#3
0
        public void Save(ClsBllRemainderMaster ObjBll, int flag)
        {
            ConnectToDb();

            Cmd.Parameters.Clear();
            Cmd.Parameters.Add("@FLAG", SqlDbType.BigInt).Value = flag;
            if (flag == 4)
            {
                Cmd.Parameters.Add("@REMAINDERID", SqlDbType.BigInt).Value = ObjBll.RemainderId;
            }

            Cmd.Parameters.Add("@NAME", SqlDbType.VarChar).Value               = ObjBll.Name;
            Cmd.Parameters.Add("@MESSAGE", SqlDbType.VarChar).Value            = ObjBll.Message;
            Cmd.Parameters.Add("@STARTTIME", SqlDbType.DateTime).Value         = ObjBll.StartTime;
            Cmd.Parameters.Add("@STOPTIME", SqlDbType.DateTime).Value          = ObjBll.StopTime;
            Cmd.Parameters.Add("@PRIORITYID", SqlDbType.BigInt).Value          = ObjBll.PriorityId;
            Cmd.Parameters.Add("@INTERVALSID", SqlDbType.BigInt).Value         = ObjBll.Intervals;
            Cmd.Parameters.Add("@DAYS", SqlDbType.VarChar).Value               = ObjBll.Days;
            Cmd.Parameters.Add("@APPLICABLEUSERSIDS", SqlDbType.VarChar).Value = ObjBll.ApplicableUsers;

            Cmd.ExecuteNonQuery();
        }