public bool AddMNotification(MNotification mnotification) { SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "AddMNotification"; cmd.Parameters.AddWithValue("@NotifyNo", mnotification.NotifyNo); cmd.Parameters.AddWithValue("@NotifyType", mnotification.NotifyType); cmd.Parameters.AddWithValue("@NotifyMessage", mnotification.NotifyMessage); cmd.Parameters.AddWithValue("@NotifyDate", mnotification.NotifyDate); cmd.Parameters.AddWithValue("@NotifyStatus", mnotification.NotifyStatus); cmd.Parameters.AddWithValue("@NotifyFileName", mnotification.NotifyFileName); cmd.Parameters.AddWithValue("@CompanyNo", mnotification.CompanyNo); commandcollection.Add(cmd); return(true); }
public bool UpdateNotification(MNotification mnotification) { SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "Update MNotification set NotifyStatus=@NotifyStatus ,StatusNo=2 where NotifyNo=@NotifyNo"; cmd.Parameters.AddWithValue("@NotifyNo", mnotification.NotifyNo); cmd.Parameters.AddWithValue("@NotifyStatus", mnotification.NotifyStatus); commandcollection.Add(cmd); return(true); }